You have an Azure SQL database named sqldb1.
You need to minimize the possibility of Query Store transitioning to a read-only state.
What should you do?

• A.Double the value of Data Flush interval
• B.Decrease by half the value of Data Flush Interval
• C.Double the value of Statistics Collection Interval
• D.Decrease by half the value of Statistics Collection interval

Comment: *

Name: *

Email: *

Verification: *

You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool. The date dimension table will be used by all the fact tables.
Which distribution type should you recommend to minimize data movement?

• A.HASH
• B.REPLICATE
• C.ROUND_ROBIN

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL database.
You run the following PowerShell script.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation
Text Description automatically generated

Reference:
https://docs.microsoft.com/en-us/powershell/module/az.sql/set-azsqldatabasebackupshorttermretentionpolicy?vie
https://docs.microsoft.com/en-us/powershell/module/az.sql/set-azsqldatabasebackuplongtermretentionpolicy?vie

Comment: *

Name: *

Email: *

Verification: *

You have an Azure Data Factory pipeline that performs an incremental load of source data to an Azure Data Lake Storage Gen2 account.
Data to be loaded is identified by a column named LastUpdatedDate in the source table.
You plan to execute the pipeline every four hours.
You need to ensure that the pipeline execution meets the following requirements:
Automatically retries the execution when the pipeline run fails due to concurrency or throttling limits.
Supports backfilling existing data in the table.
Which type of trigger should you use?

• A.tumbling window
• B.on-demand
• C.event
• D.schedule

Comment: *

Name: *

Email: *

Verification: *

You have an Azure subscription that contains the resources shown in the following table.

You need to configure a connection between VM1 and MIL The solution must meet the following requirements:
* The connection must be encrypted.
* Network latency must be minimized.
What should you implement?

• A.a site-to-site VPN
• B.virtual network peering
• C.private endpoints
• D.service endpoints

Comment: *

Name: *

Email: *

Verification: *