For transactional workloads, which database design principle is most important?

Denormalization to increase query speed

Normalization to reduce data redundancy

A data engineering team is developing a new Azure Stream Analytics job that reads from an Event Hub and writes to a SQL Database. They want to validate the query logic before deploying to production. They have a sample of historical events stored in a JSON file. What should they do to test the job?

Create a separate Event Hub and send the sample events to it, then run the job against that Event Hub.

Use the Stream Analytics job's 'Test' feature in the Azure portal with sample data from the JSON file.

Run the job in production and monitor for errors.

Use Azure Data Factory to run the query against the sample data.

Microsoft Certified:Azure Data Engineer Associate

Domain 2Objective 3

Develop a Stream Processing Solution DP-203 Practice Questions (Page 10)

Part of the Develop data processing domain, which accounts for 40–45% of the DP-203 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~16–29 in this domain), expect 4–7 from this objective — we provide 47 practice questions to prepare you well beyond it. (estimate)

47questions here

10free pages

16concepts

40–45%of the exam

Questions 46–47

46foundation · easy
For transactional workloads, which database design principle is most important?
Select an answer first
47application · medium
A data engineering team is developing a new Azure Stream Analytics job that reads from an Event Hub and writes to a SQL Database. They want to validate the query logic before deploying to production. They have a sample of historical events stored in a JSON file. What should they do to test the job?
Select an answer first

Finished these 2 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DP-203

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-203” is a trademark of its owner, used for identification only.

Develop a Stream Processing Solution DP-203 Practice Questions (Page 10)

Questions 46–47

For transactional workloads, which database design principle is most important?

A data engineering team is developing a new Azure Stream Analytics job that reads from an Event Hub and writes to a SQL Database. They want to validate the query logic before deploying to production. They have a sample of historical events stored in a JSON file. What should they do to test the job?

Keep studying — Develop data processing