Design and implement loading patterns
8 practice questions under this official exam objective (DP-700) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
Which Fabric store supports T-SQL, KQL, and Spark reads with Spark writes?
Semi-structured Fabric data that must be read through T-SQL, KQL, and Apache Spark while being written only by Spark points to an eventhouse rather th
OneLake Shortcut Cache Retention and Data Retrieval
This question tests the behavior of OneLake shortcut caching in Microsoft Fabric, specifically how cache retention periods affect data retrieval from
How Should Contoso Access Amazon S3 Email Data in Fabric?
This DP-700 case study tests cross-cloud access to a year of historical email interaction data stored in 12 Parquet files in Amazon S3, where Fabric m
Which Columns Belong in DimProduct?
When converting a flat sales table into a star schema in Microsoft Fabric, dimension tables hold descriptive product attributes while fact tables hold
Which Fabric item copies on-premises SQL Server data to Warehouse1?
Copying on-premises SQL Server data into a Fabric warehouse through an on-premises data gateway requires a Fabric item that supports gateway-backed da
Does KQL Order By Return Ascending No_Bikes Results?
In Microsoft Fabric and Azure Data Explorer KQL, the order by (sort) operator defaults to descending order, unlike SQL's ascending default. For the Bi
Streaming IoT Data into Fabric Lakehouse for NRT Dashboards
This DP-700 scenario asks how to ingest IoT sensor telemetry in near-real-time, power NRT dashboards with anomaly detection, and land the data in Lake
Which two Fabric warehouse tables should you refresh first?
In a Fabric data warehouse star schema, dimension tables with no foreign-key dependencies must be loaded before dependent dimensions and fact tables.