Online Access Free 70-765 Practice Test

You plan to migrate a database To Microsoft Azure SQL Database. The database requires 500 gigabytes (GB) of storage.
The database must support 50 concurrent logins. You must minimize the cost associated with hosting the database.
You need to create the database.
Which pricing tier should you use?

• A.Premium P2tier
• B.Premium P1 tier
• C.Standard S2 pricing tier
• D.Standard S3 pricing tier

You have a server named server1-contoso.database.windows.net that has a Microsoft Azure SQL database.
You need to create a group of Azure SQL databases that share the resources on server1-contoso.database.windows.net.
Which cmdlet should you run before you create the database?

• A.New-AzureRmVM
• B.New-AzureRmSqlElasticPool
• C.New-AzureRmSqlDatabaseSecondary
• D.New-AzureRmSqlDatabaseCopy
• E.New-AzureRmSqlServer
• F.New-AzureRmSqlServerCommunicationLink
• G.New-AzureRmAvailabilitySet
• H.New-AzureRmLoadBalancer

You administer a SQL 2012 server that contains a database named SalesDB. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales.
UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema.
You need to remove the Select permission for UserA on the Regions table. You also need to ensure that UserA can still access all the tables in the Customers schema, including the Regions table, through the Sales role permissions.
Which Transact-SQL statement should you use?

• A.REVOKE SELECT ON Schema::Customers FROM UserA
• B.REVOKE SELECT ON Object::Regions FROM Sales
• C.DENY SELECT ON Schema::Customers FROM Sales
• D.DENY SELECT ON Object::Regions FROM Sales
• E.DENY SELECT ON Object::Regions FROM UserA
• F.DENY SELECT ON Schema::Customers FROM UserA
• G.REVOKE SELECT ON Object::Regions FROM UserA
• H.EXEC sp_addrolemember 'Sales', 'UserA'
• I.EXEC sp_droprolemember 'Sales', 'UserA'
• J.REVOKE SELECT ON Schema::Customers FROM Sales

You need to set up the service accounts that the database engine and SQL Server Agent services will use.
How should you design the solution? To answer, select the appropriate configuration options in the answer area.

Correct Answer:

Explanation:
Box 1: Domain Account
The service startup account defines the Microsoft Windows account in which SQL Server Agent runs and its network permissions. SQL Server Agent runs as a specified user account. You select an account for the SQL Server Agent service by using SQL Server Configuration Manager, where you can choose fromthe following options:
* Built-in account. You can choose from a list of the following built-in Windows service accounts: Local System account.
* This account. Lets you specify the Windows domain account in which the SQL Server Agent service runs.
Box2: Domain users
Microsoft recommends choosing a Windows user account that is not a member of the Windows Administrators group.
Box 3: Managed Service Accounts
When resources external to the SQL Server computer are needed, Microsoft recommends using a Managed Service Account (MSA), configured with the minimum privileges necessary.
Note: A Managed Service Account (MSA) can run services on a computer in a secure and easy to maintain manner, while maintaining the capability to connect to network resources as a specific user principal.
References:
https://msdn.microsoft.com/en-us/library/ms191543.aspx

You plan to migrate a Microsoft SQL server instance between physical servers.
You must migrate the metadata associated with the database instance.
You need to ensure that the new instance retains the existing jobs and alerts.
Solutions: You restore the service master key.
Does the solution meet the goal?

• A.No
• B.Yes