DRAG DROP -You plan to create a table in an Azure Synapse Analytics dedicated SQL pool.Data in the table will be retained for five years. Once a year, data that is older than five years will be deleted.You need to ensure that the data is distributed evenly across partitions. The solution must minimize the amount of time required to delete old data.How should you complete the Transact-SQL statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point.Select and Place:
HOTSPOT -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:
HOTSPOT -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 failsWhat 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:
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.
DRAG DROP -You have an Azure subscription.You plan to build a data warehouse in an Azure Synapse Analytics dedicated SQL pool named pool1 that will contain staging tables and a dimensional model.Pool1 will contain the following tables.You need to design the table storage for pool1. The solution must meet the following requirements:✑ Maximize the performance of data loading operations to Staging.WebSessions.✑ Minimize query times for reporting queries against the dimensional model.Which type of table distribution should you use for each table? To answer, drag the appropriate table distribution types to the correct tables. Each table distribution type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point.Select and Place:
You have a table in an Azure Synapse Analytics dedicated SQL pool. The table was created by using the following Transact-SQL statement.You need to alter the table to meet the following requirements:✑ Ensure that users can identify the current manager of employees.✑ Support creating an employee reporting hierarchy for your entire company.✑ Provide fast lookup of the managers' attributes such as name and job title.Which column should you add to the table?
