DP-201 Exam QuestionsBrowse all questions from this exam

DP-201 Exam - Question 154


Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

A company is developing a solution to manage inventory data for a group of automotive repair shops. The solution will use Azure Synapse Analytics 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: Configure database-level auditing in Azure Synapse Analytics and set retention to 10 days.

Does the solution meet the goal?

Show Answer
Correct Answer: B

The proposed solution of configuring database-level auditing and setting retention to 10 days does not address the requirement of ensuring that upload processes and data corruption checks do not impact reporting and analytics processes. Database-level auditing mainly tracks database events and does not prevent or mitigate the impact of data corruption checks on ongoing processes. A more appropriate solution would be to create a user-defined restore point before data uploads and delete the restore point once data corruption checks are complete. This ensures that any corruption can be resolved without disrupting the reporting and analytics processes.

Discussion

1 comment
Sign in to comment
Anonymous
Jun 25, 2021

correct