What should you implement to meet the disaster recovery requirements for the PaaS solution?

• A.Availability Zones
• B.failover groups
• C.Always On availability groups
• D.geo-replication

Comment: *

Name: *

Email: *

Verification: *

You plan to develop a dataset named Purchases by using Azure Databricks. Purchases will contain the following columns:
ProductID
ItemPrice
LineTotal
Quantity
StoreID
Minute
Month
Hour
Year
Day
You need to store the data to support hourly incremental load pipelines that will vary for each StoreID. The solution must minimize storage costs.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://intellipaat.com/community/11744/how-to-partition-and-write-dataframe-in-spark-without-deleting-partitions-with-no-new-data

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL managed instance.
You need to gather the last execution of a query plan and its runtime statistics. The solution must minimize the impact on currently running queries.
What should you do?

• A.Generate an estimated execution plan.
• B.Generate an actual execution plan.
• C.Run sys.dm_exec_query_plan_scacs.
• D.Generate Live Query Statistics.

Comment: *

Name: *

Email: *

Verification: *

You have an Azure data solution that contains an enterprise data warehouse in Azure Synapse Analytics named DW1.
Several users execute adhoc queries to DW1 concurrently.
You regularly perform automated data loads to DW1.
You need to ensure that the automated data loads have enough memory available to complete quickly and
successfully when the adhoc queries run.
What should you do?

• A.Assign a smaller resource class to the automated data load queries.
• B.Create sampled statistics to every column in each table of DW1.
• C.Assign a larger resource class to the automated data load queries.
• D.Hash distribute the large fact tables in DW1 before performing the automated data loads.

Comment: *

Name: *

Email: *

Verification: *

You need to design an analytical storage solution for the transactional dat a. The solution must meet the sales transaction dataset requirements.
What should you include in the solution? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *