A data engineer needs to ingest data from an on-premises SQL Server database into Azure Databricks on a scheduled basis. Which tool is most appropriate for this task?

Databricks notebook with a JDBC connection

An e-commerce platform generates clickstream events continuously. The data team needs to make these events available for near-real-time dashboards with sub-minute latency, and also needs to retain raw events for historical analysis. Which approach should you implement?

Use Azure Data Factory to copy events every 5 minutes from an event hub to a Delta table.

Batch ingest events every hour into a Parquet table and use that table for both dashboards and history.

Stream events directly into a CSV file in cloud storage and query it with Spark.

Stream the events into a Delta table using Structured Streaming, and create a separate Delta table for aggregated dashboard data.

Microsoft Certified:Azure Databricks Data Engineer Associate

Domain 3Objective 1

Design and Implement Data Modeling in Unity Catalog DP-750 Practice Questions (Page 8)

Part of the Prepare and process data domain, which accounts for 30–35% of the DP-750 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~15–28 in this domain), expect 4–7 from this objective — we provide 42 practice questions to prepare you well beyond it. (estimate)

42questions here

9free pages

10concepts

30–35%of the exam

Questions 36–40

36foundation · easy
Which data table format provides ACID transactions, time travel, and schema enforcement, making it the recommended format for most Databricks tables?
Select an answer first
37foundation · easy
A data engineer needs to ingest data from an on-premises SQL Server database into Azure Databricks on a scheduled basis. Which tool is most appropriate for this task?
Select an answer first
38foundation · easy
Which column is most suitable for partitioning a large sales fact table?
Select an answer first
39application · medium
An e-commerce platform generates clickstream events continuously. The data team needs to make these events available for near-real-time dashboards with sub-minute latency, and also needs to retain raw events for historical analysis. Which approach should you implement?
Select an answer first
40foundation · easy
Which slowly changing dimension type overwrites the existing value without keeping any history?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-750

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-750” is a trademark of its owner, used for identification only.

Design and Implement Data Modeling in Unity Catalog DP-750 Practice Questions (Page 8)

Questions 36–40

Which data table format provides ACID transactions, time travel, and schema enforcement, making it the recommended format for most Databricks tables?

A data engineer needs to ingest data from an on-premises SQL Server database into Azure Databricks on a scheduled basis. Which tool is most appropriate for this task?

Which column is most suitable for partitioning a large sales fact table?

An e-commerce platform generates clickstream events continuously. The data team needs to make these events available for near-real-time dashboards with sub-minute latency, and also needs to retain raw events for historical analysis. Which approach should you implement?

Which slowly changing dimension type overwrites the existing value without keeping any history?

Keep studying — Prepare and process data