A Fabric developer needs to connect to an Azure SQL Database to ingest data. The developer has the server name, database name, and credentials. What is the first step to establish the connection?

Use a Spark notebook with a JDBC connection string.

Create a shortcut in OneLake pointing to the Azure SQL Database.

Use the Real-Time hub to connect to the Azure SQL Database.

Create a connection in the Fabric portal using the Azure SQL Database connector.

When you enable OneLake integration for an Eventhouse, where is the Eventhouse data stored?

In a proprietary format only accessible by the Eventhouse

A Fabric engineer needs to ingest a live stream of IoT sensor data into an Eventhouse for real-time analytics. The engineer wants to use a no-code approach to connect to the stream and land the data in the Eventhouse. What should the engineer do?

Use a Dataflow Gen2 to connect to the IoT hub and load data into the Eventhouse.

Use a Spark notebook to read from the IoT hub and write to the Eventhouse.

Use the Real-Time hub to find the stream and create an eventstream to ingest it into the Eventhouse.

Use a OneLake shortcut to point to the IoT hub.

A Fabric administrator needs to ingest data from an on-premises SQL Server database into a Fabric lakehouse. The data volume is moderate and the refresh must occur every 30 minutes. The administrator wants to minimize the number of components to manage. What should the administrator use?

Create a Dataflow Gen2 with a SQL Server connection and schedule a refresh every 30 minutes.

Use a Spark notebook with a JDBC connection and run it on a schedule using a pipeline.

Use Azure Data Factory copy activity with a self-hosted integration runtime.

Create a shortcut in the lakehouse pointing to the SQL Server table.

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 2Objective 1

Get Data DP-600 Practice Questions (Page 5)

Part of the Prepare data domain, which accounts for 45–50% of the DP-600 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~18–33 in this domain), expect 6–11 from this objective — we provide 30 practice questions to prepare you well beyond it. (estimate)

30questions here

6free pages

8concepts

45–50%of the exam

Questions 21–25

21foundation · easy
Which Fabric data store is best suited for storing and analyzing real-time telemetry data from IoT devices?
Select an answer first
22application · medium
A Fabric developer needs to connect to an Azure SQL Database to ingest data. The developer has the server name, database name, and credentials. What is the first step to establish the connection?
Select an answer first
23foundation · easy
When you enable OneLake integration for an Eventhouse, where is the Eventhouse data stored?
Select an answer first
24application · medium
A Fabric engineer needs to ingest a live stream of IoT sensor data into an Eventhouse for real-time analytics. The engineer wants to use a no-code approach to connect to the stream and land the data in the Eventhouse. What should the engineer do?
Select an answer first
25application · medium
A Fabric administrator needs to ingest data from an on-premises SQL Server database into a Fabric lakehouse. The data volume is moderate and the refresh must occur every 30 minutes. The administrator wants to minimize the number of components to manage. What should the administrator use?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-600

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