Microsoft Exam 70-467 Topic 10 Question 5 Discussion

Actual exam question for Microsoft's 70-467 exam

Question #: 5
Topic #: 10

You are designing an extract, transform, load (ETL) process for loading data from a SQL Azure database into a large fact table in a data warehouse each day with the prior day's sales data.

The ETL process for the fact table must meet the following requirements:

Load new data in the shortest possible time.

Remove data that is more than 36 months old.

Minimize record locking.

Minimize impact on the transaction log.

You need to design an ETL process that meets the requirements.

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

APartition the fact table by date. Insert new data directly into the fact table and delete old data directly from the fact table.

BPartition the fact table by customer. Use partition switching both to remove old data and to load new data into each partition.

CPartition the fact table by date. Use partition switching and staging tables both to remove old data and to load new data.

DPartition the fact table by date. Use partition switching and a staging table to remove old data. Insert new data directly into the fact table.

Show Suggested Answer

Suggested Answer: C

by Shawnda at May 10, 2022, 03:43 AM

Limited Time Offer

25%

Off

Get Premium 70-467 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!