Query and analyze data
5 practice questions under this official exam objective (DP-600) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
Which file format and shortcut location enable Fabric SQL endpoint queries?
This DP-600 question asks which two actions let you query Amazon S3 sales files from a Fabric lakehouse SQL endpoint. The page establishes that you mu
Which Join Returns All Rows in Both Tables?
To return all rows from both tables in a Fabric lakehouse visual query, a full outer join is required. This page explains why full outer join is the c
PySpark DataFrame explain vs describe Method
The df.explain() method in PySpark displays the execution plan, not statistical summaries. This page confirms that df.describe() is the correct method
Does PySpark df.explain() Calculate Summary Statistics?
This page evaluates whether the PySpark expression df.explain().show() meets the goal of calculating summary statistics for string and numeric columns
Transform and Visualize OneLake JSON Data for Time Series Analysis
This page explains how to transform and visualize a massive dataset of JSON files in OneLake for time series analysis and anomaly detection. It establ