Question 56
DP-203: Data Engineering on Microsoft Azure
DP-203: Data Engineering on Microsoft Azure practice questions, page 12 of 16, with answer review and explanations.
Question 57
You have an Azure Data Lake Storage Gen2 service. You need to design a data archiving solution that meets the following requirements: ✑ Data that is older than five years is accessed infrequently but must be available within one second when requested. ✑ Data that is older than seven years is NOT accessed. ✑ Costs must be minimized while maintaining the required availability. How should you manage the data? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Question 58
You plan to create an Azure Data Lake Storage Gen2 account. You need to recommend a storage solution that meets the following requirements: ✑ Provides the highest degree of data resiliency ✑ Ensures that content remains available for writes if a primary data center fails What should you include in the recommendation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Question 59
You need to implement a Type 3 slowly changing dimension (SCD) for product category data in an Azure Synapse Analytics dedicated SQL pool. You have a table that was created by using the following Transact-SQL statement. Which two columns should you add to the table? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. B. C. D. E.
Question 60