Cyber Monday 2023! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: CM25OFF
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam 70-467 Topic 10 Question 5 Discussion

Actual exam question for Microsoft's 70-467 exam
Question #: 5
Topic #: 10
[All 70-467 Questions]

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.)

Show Suggested Answer Hide Answer
Suggested Answer: C


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

Save Cancel