Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 3 question 13 discussion

Actual exam question from Microsoft's DP-201

Question #: 13
Topic #: 3

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.
You have an Azure SQL database that has columns. The columns contain sensitive Personally Identifiable Information (PII) data.
You need to design a solution that tracks and stores all the queries executed against the PII data. You must be able to review the data in Azure Monitor, and the data must be available for at least 45 days.
Solution: You add classifications to the columns that contain sensitive data. You turn on Auditing and set the audit log destination to use Azure Log Analytics.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️
The default retention for Log Analytics is 31 days only. The Log Analytics retention settings allow you to configure a minimum of 31 days (if not using a free tier) up to 730 days.
You would need to reconfigure to at least 45 days, or, for example, use Azure Blob Storage as destination.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing https://blogs.msdn.microsoft.com/canberrapfe/2017/01/25/change-oms-log-analytics-retention-period-in-the-azure-portal/

by bansal_vikrant at April 19, 2020, 1:12 p.m.

Comments

Submit Cancel

Ash666

Highly Voted 4 years, 10 months ago

The question asks what you’ve done has met the goal or not. So, B

upvoted 19 times

memo43

4 years ago

the question dont need to mention to change/arrange retention period. All we know that it is possible to increase the period to 45. so the answer should be A

upvoted 2 times

...

cadio30

4 years ago

it is a matter how the requirement was understood and I agree with answer B. Reference: https://docs.microsoft.com/en-us/azure/azure-monitor/logs/manage-cost-storage

upvoted 2 times

...

mohowzeh

4 years, 4 months ago

Agreed. It is possible to increase the retention period, but the question makes no mention of this step. Simply doing what the question says, will lead to log files being kept for 30 days. This does not satisfy the requirement.

upvoted 5 times

...

bansal_vikrant

Highly Voted 5 years, 1 month ago

When we can change the default retention to 730 days, why is A wrong answer?

upvoted 13 times

...

muni53

Most Recent 3 years, 8 months ago

indeed default is 31 for standalone. so B

upvoted 1 times

...

AngelRio

4 years ago

The answer is YES. Reference 1: Whizlabs course. Reference 2: https://docs.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview?tabs=azure-t-sql

upvoted 2 times

...

chirag1234

4 years, 1 month ago

Answer should be yes, default Azure log analytics retention period is 90 day. https://docs.microsoft.com/en-us/azure/azure-monitor/logs/manage-cost-storage

upvoted 9 times

...

Aditya167

4 years, 5 months ago

log analytics default is 90 days so answer is A

upvoted 7 times

...

syu31svc

4 years, 6 months ago

Log analytics is correct https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview: "Auditing for Azure SQL Database and Azure Synapse Analytics tracks database events and writes them to an audit log in your Azure storage account, Log Analytics workspace, or Event Hubs."

upvoted 2 times

...

brcdbrcd

4 years, 6 months ago

You have multiple options for configuring where audit logs will be written. You can write logs to an Azure storage account, to a Log Analytics workspace for consumption by Azure Monitor logs (preview), or to event hub for consumption using event hub (preview). You can configure any combination of these options, and audit logs will be written to each. https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview should be Log analytics, for sure.

upvoted 1 times

...

NeoUp

4 years, 6 months ago

What's the point of switching to another type of storage just because you don't change the default setting that is changeable?

upvoted 2 times

...

als2kool

4 years, 8 months ago

Previous Similar question to store to blob is yes. Log analytics is no and have to set retention.

upvoted 1 times

...

extraego

4 years, 9 months ago

To set up 45 days, you have to change the default retention which is an additional step that is not stated. That's why the answer is B.

upvoted 10 times

...

passnow

4 years, 10 months ago

All similar pointer from previous indicate yes

upvoted 1 times

...

vvt

4 years, 11 months ago

The answer should be A. https://docs.microsoft.com/en-us/azure/azure-monitor/platform/manage-cost-storage#change-the-data-retention-period. https://azure.microsoft.com/en-gb/pricing/details/monitor/

upvoted 1 times

...

Lokesh08

5 years ago

The explanation says increasing to 730 days is only possible in the non-free tier, so I guess B is correct?

upvoted 2 times

wyxh

5 years ago

The question does not specify the tier. It only ask to design a solution, so: it is possiible to have 45 days ? to me the answer is yes.

upvoted 4 times

...

201p

5 years ago

It's A, the reference for this question might be old

upvoted 4 times

...