DP600 ASSESSMENT QUESTIONS WITH DETAILED
VERIFIED ANSWERS (100% CORRECT ANSWERS)
/ALREADY GRADED
You are profiling the data stored in a Fabric lakehouse.
You run the following statement.
df.describe().show()
Which three functions will be included in the results for the numeric
data? Each correct answer presents a complete solution.
COUNT, MEAN,TOP, UNIQUE FREQ,STD, MIN, and MAX
Ans✓✓✓Count, Mean and STD
You need to increase the Fabric capacity unit size.
What should you use? Ans✓✓✓Azure Portal
You have a new Fabric tenant.
You need to recommend a workspace architecture to meet best practices
for content distribution and data governance.
Which two actions should you recommend? Each correct answer
presents part of the solution. Ans✓✓✓Place semantic models and
reports in separate workspaces.
Reuse shared semantic models for multiple reports.
You have a table named Sales that contains the following columns:
Order_ID
,Customer_ID
Product_ID
Quantity
Sales_Date
You need to write a SQL statement to find the total number of products
sold for each Product_ID in January 2024.
What should you run? Ans✓✓✓SELECT Product_ID, SUM(Quantity)
FROM Sales WHERE MONTH(Sales_Date) = 1 AND
YEAR(Sales_Date) = 2024 GROUP BY Product_ID
You have a Fabric warehouse.
You are writing a T-SQL statement to retrieve data from a table named
Sales to display the highest sales amount for specific customers.
SELECT CustomerKey
, SalesAmount
, **<target1>** OVER(ORDER BY SalesAmount DESC) AS Ranking
FROM dbo.Sales
WHERE CustomerKey IN (1, 2, 3)
You need to ensure that after ties for SalesAmount, the next Sales
amount increments the Ranking value by one. Ans✓✓✓
You have a Fabric warehouse that contains the following tables:
Trip (TripDateID, PassengerCount)
, Date (DateID, Day, Month, Quarter, Year)
You plan to use the visual Query Editor in Warehouse explorer to write
a SQL statement that summarizes the number of passengers by year.
Which transformations should you use? Ans✓✓✓Choose Merge queries
to join Trip and Date, and then use GroupBy.
You have an Azure SQL database that contains a table named inventory.
The inventory table contains the following columns:
item_id
category
stock_quantity
last_stocked_date
You need to write a SQL statement that retrieves the latest
last_stocked_date for each category, for which stock_quantity is less
than 50.
Which SQL statement should you run? Ans✓✓✓SELECT category,
MAX(last_stocked_date) FROM inventory WHERE stock_quantity <
50 GROUP BY category
This answer is correct.
You have a Fabric tenant.
Your company has 1 TB of legacy accounting data stored in an Azure
Data Lake Storage Gen2 account. The data is queried only once a year
for a few ad-hoc reports that submit very selective queries.
You plan to create a Fabric lakehouse or warehouse to store company
sales data. Developers must be able to build reports from the lakehouse
VERIFIED ANSWERS (100% CORRECT ANSWERS)
/ALREADY GRADED
You are profiling the data stored in a Fabric lakehouse.
You run the following statement.
df.describe().show()
Which three functions will be included in the results for the numeric
data? Each correct answer presents a complete solution.
COUNT, MEAN,TOP, UNIQUE FREQ,STD, MIN, and MAX
Ans✓✓✓Count, Mean and STD
You need to increase the Fabric capacity unit size.
What should you use? Ans✓✓✓Azure Portal
You have a new Fabric tenant.
You need to recommend a workspace architecture to meet best practices
for content distribution and data governance.
Which two actions should you recommend? Each correct answer
presents part of the solution. Ans✓✓✓Place semantic models and
reports in separate workspaces.
Reuse shared semantic models for multiple reports.
You have a table named Sales that contains the following columns:
Order_ID
,Customer_ID
Product_ID
Quantity
Sales_Date
You need to write a SQL statement to find the total number of products
sold for each Product_ID in January 2024.
What should you run? Ans✓✓✓SELECT Product_ID, SUM(Quantity)
FROM Sales WHERE MONTH(Sales_Date) = 1 AND
YEAR(Sales_Date) = 2024 GROUP BY Product_ID
You have a Fabric warehouse.
You are writing a T-SQL statement to retrieve data from a table named
Sales to display the highest sales amount for specific customers.
SELECT CustomerKey
, SalesAmount
, **<target1>** OVER(ORDER BY SalesAmount DESC) AS Ranking
FROM dbo.Sales
WHERE CustomerKey IN (1, 2, 3)
You need to ensure that after ties for SalesAmount, the next Sales
amount increments the Ranking value by one. Ans✓✓✓
You have a Fabric warehouse that contains the following tables:
Trip (TripDateID, PassengerCount)
, Date (DateID, Day, Month, Quarter, Year)
You plan to use the visual Query Editor in Warehouse explorer to write
a SQL statement that summarizes the number of passengers by year.
Which transformations should you use? Ans✓✓✓Choose Merge queries
to join Trip and Date, and then use GroupBy.
You have an Azure SQL database that contains a table named inventory.
The inventory table contains the following columns:
item_id
category
stock_quantity
last_stocked_date
You need to write a SQL statement that retrieves the latest
last_stocked_date for each category, for which stock_quantity is less
than 50.
Which SQL statement should you run? Ans✓✓✓SELECT category,
MAX(last_stocked_date) FROM inventory WHERE stock_quantity <
50 GROUP BY category
This answer is correct.
You have a Fabric tenant.
Your company has 1 TB of legacy accounting data stored in an Azure
Data Lake Storage Gen2 account. The data is queried only once a year
for a few ad-hoc reports that submit very selective queries.
You plan to create a Fabric lakehouse or warehouse to store company
sales data. Developers must be able to build reports from the lakehouse
