QUESTION: 78 Exam Topic: Design and implement data storage questions

You have an Azure Synapse Analytics dedicated SQL pool.
You plan to create a fact table named Table1 that will contain a clustered columnstore index.

You need to optimize data compression and query performance for Table1.

What is the minimum number of rows that Table1 should contain before you create partitions?

100,000
600,000
1 million
60 million

Answer(s): D

Reveal Solution Next Question

QUESTION: 79 Exam Topic: Design and implement data storage questions

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named DimSalesPerson. DimSalesPerson contains the following columns:

•RepSourceID
•SalesRepID
•FirstName
•LastName
•StartDate
•EndDate
•Region

You are developing an Azure Synapse Analytics pipeline that includes a mapping data flow named Dataflow1. Dataflow1 will read sales team data from an external source and use a Type 2 slowly changing dimension (SCD) when loading the data into DimSalesPerson.

You need to update the last name of a salesperson in DimSalesPerson.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Update three columns of an existing row.
Update two columns of an existing row.
Insert an extra row.
Update one column of an existing row.

Answer(s): C,D

Reveal Solution Next Question

QUESTION: 80 Exam Topic: Design and implement data storage questions

HOTSPOT (Drag and Drop is not supported)
You plan to use an Azure Data Lake Storage Gen2 account to implement a Data Lake development environment that meets the following requirements:

•Read and write access to data must be maintained if an availability zone becomes unavailable.
•Data that was last modified more than two years ago must be deleted automatically.
•Costs must be minimized.

What should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

See Explanation section for answer.

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 81 Exam Topic: Design and implement data storage questions

HOTSPOT (Drag and Drop is not supported)
You are designing an Azure Data Lake Storage Gen2 container to store data for the human resources (HR) department and the operations department at your company.

You have the following data access requirements:

•After initial processing, the HR department data will be retained for seven years and rarely accessed.
•The operations department data will be accessed frequently for the first six months, and then accessed once per month.

You need to design a data retention solution to meet the access requirements. The solution must minimize storage costs.

What should you include in the storage policy for each department? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.