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

Questions 46–48

1. 46foundation · easy

   What is the most common method to identify duplicate rows in a batch dataset?

   • AFiltering for null values
   • BUsing a window function to rank rows
   • CSorting the data by all columns
   • DGrouping by key columns and counting occurrences
   Reveal Solution Discussion Select an answer first
2. 47foundation · easy

   What is the primary benefit of implementing data mirroring in Microsoft Fabric?

   • AIt provides a one-time snapshot of data for archival
   • BIt creates a continuously updated copy of data from external sources into OneLake
   • CIt creates a backup for disaster recovery only
   • DIt transforms data using PySpark
   Reveal Solution Discussion Select an answer first
3. 48application · medium

   A Fabric workspace has a Lakehouse that must access data stored in an Azure Data Lake Storage Gen2 (ADLS) account in another subscription. The data is updated daily by another team. The engineers want to query the data directly from the Lakehouse without copying it, and they need the data to appear as a table in the Lakehouse. What should you create?

   • AA Dataflow Gen2 to load the ADLS data into a new table
   • BA Data Pipeline to copy the ADLS data into the Lakehouse daily
   • CA mirroring configuration from ADLS to the Lakehouse
   • DA OneLake shortcut to the ADLS container
   Reveal Solution Discussion Select an answer first