Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 2 question 33 discussion

Actual exam question from Microsoft's DP-201

Question #: 33
Topic #: 2

HOTSPOT -
You are designing a solution to process data from multiple Azure event hubs in near real-time.
Once processed, the data will be written to an Azure SQL database.
The solution must meet the following requirements:
✑ Support the auditing of resource and data changes.
✑ Support data versioning and rollback.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: Azure Stream Analytics -
Users can now ingest, process, view, and analyze real-time streaming data into a table directly from a database in Azure SQL Database. They do so in the Azure portal using Azure Stream Analytics.
In the Azure portal, you can select an events source (Event Hub/IoT Hub), view incoming real-time events, and select a table to store events.
Stream Analytics leverages versioning of reference data to augment streaming data with the reference data that was valid at the time the event was generated.
This ensures repeatability of results.

Box 2: Replay -
Reference data is versioned, enabling to always get the same results, even when we ג€replayג€ the stream.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/stream-data-stream-analytics-integration https://azure.microsoft.com/en-us/updates/additional-support-for-managed-identity-and-new-features-in-azure-stream-analytics/

by obz at March 22, 2021, 3:16 p.m.

Comments

Submit Cancel

obz

Highly Voted 4 years, 3 months ago

Azure streaming analytics and replay are about job recovery. I would definitely go for Azure Databricks and Delta. https://databricks.com/blog/2019/02/04/introducing-delta-time-travel-for-large-scale-data-lakes.html

upvoted 38 times

hichemck

4 years ago

Also azure stream analytics does not support multiple inputs

upvoted 1 times

...

cadio30

4 years, 1 month ago

Agree with this solution. Better to compare the delta table of Azure Databricks against the Azure Stream Analytics

upvoted 2 times

...

aditya_064

Highly Voted 4 years, 2 months ago

Data is to be written to Azure SQL Database, Azure Databricks doesn't support it as a sink - https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/stream-processing. Therefore ASA is the only otpion left along with Replay feature. Replay may not be the best method but since ASA has to be included this will do. Also Azure SQL Database can handle rollbacks and auditing by itself. So given solution is correct.

upvoted 8 times

...

dakku987

Most Recent 1 year, 6 months ago

Azure synpse analytics and delta Azure Service to Use: Azure Synapse Analytics (formerly SQL Data Warehouse): Azure Synapse Analytics is a comprehensive analytics service that brings together big data and data warehousing. It supports near real-time analytics and integrates with Azure SQL Database. Feature to Use: Delta: Delta is a feature associated with Azure Synapse Analytics that provides capabilities like versioning, change tracking, and rollback options. It is designed to handle data versioning and changes efficiently.

upvoted 1 times

...

nefarious_smalls

3 years, 1 month ago

Job Replay is simply about recovering your stream to its prior state in the case of a service upgrade or any manual intervention in which you stop the stream. It has nothing to do with versioning or rolling back to a specific version. That is Delta.

upvoted 1 times

...

muni53

3 years, 9 months ago

azure databricks and delta tables. Databricks can use delta feature to load required snapshot. ADB can load data to sql db.

upvoted 1 times

...

zarga

3 years, 11 months ago

Azure databricks and Delta We can push data from databricks to azure sql db using jdbc driver.

upvoted 2 times

Tracy_Anderson

3 years, 11 months ago

https://www.sqlshack.com/load-data-into-azure-sql-database-from-azure-databricks/

upvoted 1 times

...

VG2007

4 years, 2 months ago

Not sure what is the confusion.. refrence links are already given in and looks correct .. eference: https://docs.microsoft.com/en-us/azure/azure-sql/database/stream-data-stream-analytics-integration https://azure.microsoft.com/en-us/updates/additional-support-for-managed-identity-and-new-features-in-azure-stream-analytics/

upvoted 3 times

...

niwe

4 years, 2 months ago

The given answer, I think i correct https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-concepts-checkpoint-replay

upvoted 2 times

KRV

4 years, 2 months ago

I think the questions talks about data versioning and auditing data and date related changes and not about the job recovery , and hence I think Azure Databricks and Delta happens to be logically correct with corelation to the question asked for Data changes and not job related changes or recovery

upvoted 2 times

...