Designing an Azure Data Solution

97 Questions

You can start the exam to practice all questions related to this exam.

Question No. 1

A company is developing a solution to manage inventory data for a group of automotive repair shops. The solution will use Azure SQL Data Warehouse as the data store.

Shops will upload data every 10 days.

Data corruption checks must run each time data is uploaded. If corruption is detected, the corrupted data must be removed.
You need to ensure that upload processes and data corruption checks do not impact reporting and analytics
processes that use the data warehouse.
Proposed solution: Insert data from shops and perform the data corruption check in a transaction. Rollback
transfer if corruption is detected.
Does the solution meet the goal?
Choose the correct option from the given list.
01 / 97

0 Discussions

Trending Exams