Select the answer that correctly completes the sentence.

Correct Answer:

See the answer in explanation below.
Explanation
Answer below as:

Comment: *

Name: *

Email: *

Verification: *

You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?

• A.You need to generate reports without affecting the transactional workload.
• B.You need to audit the transactional application.
• C.You need to implement high availability in the event of a regional outage
• D.You need to improve the recovery point objective (RPO).

Comment: *

Name: *

Email: *

Verification: *

You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.
What should you use to query the files?

• A.Azure Functions
• B.Microsoft SQL Server Integration Services (SSIS)
• C.PolyBase
• D.Azure Data Factory

Comment: *

Name: *

Email: *

Verification: *

You need to create a visualization of running sales totals per quarter as shown in the following exhibit.

What should you create in Power BI Desktop?

• A.a ribbon chart
• B.a decomposition tree
• C.a bar chart
• D.a waterfall chart

Comment: *

Name: *

Email: *

Verification: *

Match the datastore services to the appropriate descriptions.
To answer, drag the appropriate service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-working-with-json
https://cloud.netapp.com/blog/azure-smb-server-message-block-in-the-cloud-for-azure-files

Comment: *

Name: *

Email: *

Verification: *