You have 50 Azure SQL databases.
You need to notify the database owner when the database settings, such as the database size and pricing tier, are modified in Azure.
What should you do?

• A.Create a diagnostic setting for the activity log that has the Security log enabled.
• B.For the database, create a diagnostic setting that has the InstanceAndAppAdvanced metric enabled.
• C.Create an alert rule that uses a Metric signal type.
• D.Create an alert rule that uses an Activity Log signal type.

Comment: *

Name: *

Email: *

Verification: *

You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool.
You need to create a surrogate key for the table. The solution must provide the fastest query performance.
What should you use for the surrogate key?

• A.an IDENTITY column
• B.a GUID column
• C.a sequence object

Comment: *

Name: *

Email: *

Verification: *

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 have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1.
You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service.
How should you configure the backup of DB1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct Answer:

Section: [none]
Explanation:
Box 1: Full and log backups only
Make sure to take every backup on a separate backup media (backup files). Azure Database Migration Service doesn't support backups that are appended to a single backup file. Take full backup and log backups to separate backup files.
Box 2: WITH CHECKSUM
Azure Database Migration Service uses the backup and restore method to migrate your on-premises databases to SQL Managed Instance. Azure Database Migration Service only supports backups created using checksum.
Incorrect Answers:
NOINIT Indicates that the backup set is appended to the specified media set, preserving existing backup sets.
If a media password is defined for the media set, the password must be supplied. NOINIT is the default.
UNLOAD
Specifies that the tape is automatically rewound and unloaded when the backup is finished. UNLOAD is the default when a session begins.
Reference:
https://docs.microsoft.com/en-us/azure/dms/known-issues-azure-sql-db-managed-instance-online

Comment: *

Name: *

Email: *

Verification: *

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: *