You have SQL Server on an Azure virtual machine that contains a database named Db1.
You need to enable automatic tuning for Db1.
How should you complete the statements? To answer, select the appropriate answer in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable

Comment: *

Name: *

Email: *

Verification: *

You have the following Azure Data Factory pipelines:
* Ingest Data from System1
* Ingest Data from System2
* Populate Dimensions
* Populate Facts
Ingest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2. Populate Facts must execute after the Populate Dimensions pipeline. All the pipelines must execute every eight hours.
What should you do to schedule the pipelines for execution?

• A.Add a schedule trigger to all four pipelines.
• B.Add an event trigger to all four pipelines.
• C.Create a parent pipeline that contains the four pipelines and use an event trigger.
• D.Create a parent pipeline that contains the four pipelines and use a schedule trigger.

Comment: *

Name: *

Email: *

Verification: *

Note: This question is part of a series of questions that present the same scenario. Each question in
the series contains a unique solution that might meet the stated goals. Some question sets might have
more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these
questions will not appear in the review screen.
You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL
database named Database1.
You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on
Server2.
Solution: You restore Database1 from Server1 to the Server2 by using the RESTORETransact-SQL command
and the REPLACEoption.
Does this meet the goal?

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *

You have an Azure Data Factory instance named ADF1 and two Azure Synapse Analytics workspaces named WS1 and WS2.
ADF1 contains the following pipelines:
P1:Uses a copy activity to copy data from a nonpartitioned table in a dedicated SQL pool of WS1 to an Azure Data Lake Storage Gen2 account P2:Uses a copy activity to copy data from text-delimited files in an Azure Data Lake Storage Gen2 account to a nonpartitioned table in a dedicated SQL pool of WS2 You need to configure P1 and P2 to maximize parallelism and performance.
Which dataset settings should you configure for the copy activity of each pipeline? To answer, select the appropriate options in the answer area.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse
https://docs.microsoft.com/en-us/azure/data-factory/load-azure-sql-data-warehouse

Comment: *

Name: *

Email: *

Verification: *

Based on the PaaS prototype, which Azure SQL Database compute tier should you use?

• A.Business Critical 4-vCore
• B.Hyperscale
• C.General Purpose v-vCore
• D.Serverless

Comment: *

Name: *

Email: *

Verification: *