Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You are designing a stream processing solution that must upsert stream data into a database efficiently. Describe how you would configure the system to handle these upserts, including the data storage solution you would use and the mechanisms you would put in place to ensure data consistency and integrity.
A
Use a relational database and rely on database transactions to ensure data consistency during upserts.
B
Store data in a key-value store and use batch processing to manage upserts efficiently.
C
Archive data in a NoSQL database and use snapshotting to ensure consistency during upserts.
D
Use a message broker for data storage and rely on its built-in upsert functionality to handle data integrity.