You have an Azure SQL database.
You discover that the plan cache is full of compiled plans that were used only once.
You run the select * from sys.database_scoped_configurationsTransact-SQL command and receive the results shown in the following table.

You need relieve the memory pressure.
What should you configure?

• A.LEGACY_CARDINALITY_ESTIMATION
• B.QUERY_OPTIMIZER_HOTFIXES
• C.OPTIMIZE_FOR_AD_HOC_WORKLOADS
• D.ACCELERATED_PLAN_FORCING

Comment: *

Name: *

Email: *

Verification: *

HOTSPOT
You are evaluating the role assignments.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct Answer:

Section: [none]
Explanation:
Box 1: Yes
DBAGroup1 is member of the Contributor role.
The Contributor role grants full access to manage all resources, but does not allow you to assign roles in Azure
RBAC, manage assignments in Azure Blueprints, or share image galleries.
Box 2: No
Box 3: Yes
DBAGroup2 is member of the SQL DB Contributor role.
The SQL DB Contributor role lets you manage SQL databases, but not access to them. Also, you can't manage
their security-related policies or their parent SQL servers. As a member of this role you can create and manage
SQL databases.
Reference:
https://docs.microsoft.com/en-us/azure/role-based-access-control/built-in-roles
Question Set 3

Comment: *

Name: *

Email: *

Verification: *

You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine.
In the event of an Azure regional outage, you need to be able to restore the database backups. The solution
must minimize costs.
Which type of storage accounts should you use for the backups?

• A.locally-redundant storage (LRS)
• B.read-access geo-redundant storage (RA-GRS)
• C.zone-redundant storage (ZRS)
• D.geo-redundant storage

Comment: *

Name: *

Email: *

Verification: *

You have several Azure SQL databases on the same Azure SQL Database server in a resource group named ResourceGroup1.
You must be alerted when CPU usage exceeds 80 percent for any database. The solution must apply to any additional databases that are created on the Azure SQL server.
Which resource type should you use to create the alert?

• A.Resource Groups
• B.SQL Servers
• C.SQL Databases
• D.SQL Virtual Machines

Comment: *

Name: *

Email: *

Verification: *

You have SQL Server on an Azure virtual machine.
You need to use Policy-Based Management in Microsoft SQL Server to identify stored procedures that do not comply with your naming conventions.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

1 - Create a custom condition based an a built-in facet.
2 - Create a custom policy based an a condition.
3 - Run a policy evaluation.
Reference:
https://www.mssqltips.com/sqlservertip/2298/enforce-sql-server-database-naming-conventions-using-policy-based-management/

Comment: *

Name: *

Email: *

Verification: *