A manufacturing company has an existing Azure Data Lake Storage Gen2 account containing years of sensor logs. A Fabric data engineer needs to make these files available for PySpark transformations in a Fabric workspace without copying the data. The source storage account is in the same region as the Fabric workspace. What should the engineer do?

Create a OneLake shortcut in the workspace pointing to the ADLS Gen2 container.

Create a shortcut in the ADLS Gen2 account pointing to the Fabric lakehouse.

Use a data pipeline to copy the files into a Fabric lakehouse.

Mount the ADLS Gen2 account as a filesystem in the PySpark session.

A PySpark job processes a batch of transaction data. The data contains duplicate transaction IDs and some rows with missing amounts. The requirement is to keep the first occurrence of each transaction ID and fill missing amounts with 0, then calculate the total amount per day. Which sequence of operations should be used?

fillna(0, subset=['amount']).dropDuplicates(['transaction_id']).groupBy('date').sum('amount')

dropDuplicates(['transaction_id']).fillna(0, subset=['amount']).groupBy('date').sum('amount')

groupBy('date').sum('amount').dropDuplicates(['transaction_id'])

dropDuplicates().fillna(0).groupBy('date').sum('amount')

Which of the following is a valid type of OneLake shortcut?

Azure Data Lake Storage Gen2 shortcut

Azure Blob Storage shortcut (non-hierarchical)

Microsoft Certified:Fabric Data Engineer Associate

Domain 2Objective 2

Ingest and Transform Batch Data DP-700 Practice Questions (Page 6)

Part of the Ingest and transform data domain, which accounts for 30–35% of the DP-700 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~12–23 in this domain), expect 4–8 from this objective — we provide 48 practice questions to prepare you well beyond it. (estimate)

48questions here

10free pages

13concepts

30–35%of the exam

Questions 26–30

26foundation · easy
Which activity in a Fabric data pipeline is used to copy data from an external source into a lakehouse?
Select an answer first
27foundation · easy
In PySpark, which method is used to drop rows that contain any null values?
Select an answer first
28application · medium
A manufacturing company has an existing Azure Data Lake Storage Gen2 account containing years of sensor logs. A Fabric data engineer needs to make these files available for PySpark transformations in a Fabric workspace without copying the data. The source storage account is in the same region as the Fabric workspace. What should the engineer do?
Select an answer first
29expert · hard
A PySpark job processes a batch of transaction data. The data contains duplicate transaction IDs and some rows with missing amounts. The requirement is to keep the first occurrence of each transaction ID and fill missing amounts with 0, then calculate the total amount per day. Which sequence of operations should be used?
Select an answer first
30foundation · easy
Which of the following is a valid type of OneLake shortcut?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-700

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

Ingest and Transform Batch Data DP-700 Practice Questions (Page 6)

Questions 26–30

Which activity in a Fabric data pipeline is used to copy data from an external source into a lakehouse?

In PySpark, which method is used to drop rows that contain any null values?

Which of the following is a valid type of OneLake shortcut?

Keep studying — Ingest and transform data