Free Microsoft DP-600 Practice Test & Real Exam Questions
You have a Fabric tenant.
You are creating a Fabric Data Factory pipeline.
You have a stored procedure that returns the number of active customers and their average sales for the current month.
You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline.
Which type of activity should you add?
You are creating a Fabric Data Factory pipeline.
You have a stored procedure that returns the number of active customers and their average sales for the current month.
You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline.
Which type of activity should you add?
Correct Answer: B
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You have a Fabric tenant that contains customer churn data stored as Parquet files in OneLake. The data contains details about customer demographics and product usage.
You create a Fabric notebook to read the data into a Spark DataFrame. You then create column charts in the notebook that show the distribution of retained customers as compared to lost customers based on geography, the number of products purchased, age. and customer tenure.
Which type of analytics are you performing?
You create a Fabric notebook to read the data into a Spark DataFrame. You then create column charts in the notebook that show the distribution of retained customers as compared to lost customers based on geography, the number of products purchased, age. and customer tenure.
Which type of analytics are you performing?
Correct Answer: D
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You need to migrate the Research division data for Productline2. The solution must meet the data preparation requirements. How should you complete the code? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Comprehensive Detailed Explanation
From the case study:
Research division data for Productline2 is currently in CSV format in storage2.
Requirement: "All the Research division data in the lakehouses must be presented as managed tables in Lakehouse explorer." In Fabric lakehouses, managed tables are stored in Delta format inside the Tables folder.
Step 1: Reading the source
df = spark.read.format( " csv " ) \
options(header= " true " , inferSchema= " true " ) \
load( " abfss://storage1.dfs.core.windows.net/files/productline2 " )
This correctly ingests the CSV source from ADLS Gen2.
Step 2: Writing to Lakehouse as a managed table
You must write the data in Delta format to ensure it is queryable and managed within the lakehouse.
The correct path is under Tables/, because this is where Fabric automatically manages Lakehouse managed tables.
The target table should be named productline2, so the correct path is:
df.write.mode( " overwrite " ).format( " delta " ).save( " Tables/productline2 " ) Why not other options?
CSV or Parquet formats would not create a managed Lakehouse table; they would just create files.
Writing to productline2 directly (without Tables/) would store unmanaged files in the Lakehouse Files area, not managed tables.
Writing to Tables/research/productline2 adds an unnecessary subdirectory and is not the standard structure for managed tables.
Correct Final Code
df.write.mode( " overwrite " ).format( " delta " ).save( " Tables/productline2 " ) References Managed tables in Microsoft Fabric Lakehouse Delta Lake support in Fabric Spark write to Lakehouse
You have a Fabric tenant that contains lakehouse named Lakehouse1. Lakehouse1 contains a Delta table with eight columns. You receive new data that contains the same eight columns and two additional columns.
You create a Spark DataFrame and assign the DataFrame to a variable named df. The DataFrame contains the new data. You need to add the new data to the Delta table to meet the following requirements:
* Keep all the existing rows.
* Ensure that all the new data is added to the table.
How should you complete the code? To answer, select the appropriate options in the answer area.
You create a Spark DataFrame and assign the DataFrame to a variable named df. The DataFrame contains the new data. You need to add the new data to the Delta table to meet the following requirements:
* Keep all the existing rows.
* Ensure that all the new data is added to the table.
How should you complete the code? To answer, select the appropriate options in the answer area.
Correct Answer:
Explanation:
o add new data to the Delta table while meeting the specified requirements:
You should use the append mode to ensure that all new data is added to the table without affecting the existing rows.
You should set the mergeSchema option to true to allow the schema of the Delta table to be updated with the new columns found in the DataFrame.
The completed code would look like this:
df.write.format( " delta " ).mode( " append " )
option( " mergeSchema " , " true " )
saveAsTable( " Lakehouse1.TableName " )
You have a Fabric tenant that contains a complex semantic model. The model is based on a star schema and contains many tables, including a fact table named Sales. You need to create a diagram of the model. The diagram must contain only the Sales table and related tables. What should you use from Microsoft Power Bl Desktop?
Correct Answer: C
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You have a Fabric workspace named Workspace1 and a warehouse named Warehouse1. Workspace1 contains a user named User1. User1 is assigned the Viewer role for Workspace1.
You need to ensure that User1 can share Warehouse1 with other users. The solution must follow the principle of least privilege.
Which role should you assign to User1?
You need to ensure that User1 can share Warehouse1 with other users. The solution must follow the principle of least privilege.
Which role should you assign to User1?
Correct Answer: B
Vote an answer
You have a Fabric workspace named Workspace 1 that contains a dataflow named Dataflow1. Dataflow1 has a query that returns 2.000 rows. You view the query in Power Query as shown in the following exhibit.
What can you identify about the pickupLongitude column?
What can you identify about the pickupLongitude column?
Correct Answer: C
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You plan to deploy Microsoft Power BI items by using Fabric deployment pipelines. You have a deployment pipeline that contains three stages named Development, Test, and Production. A workspace is assigned to each stage.
You need to provide Power BI developers with access to the pipeline. The solution must meet the following requirements:
Ensure that the developers can deploy items to the workspaces for Development and Test.
Prevent the developers from deploying items to the workspace for Production.
Ensure that developers can view items in Production.
Follow the principle of least privilege.
Which three levels of access should you assign to the developers? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
You need to provide Power BI developers with access to the pipeline. The solution must meet the following requirements:
Ensure that the developers can deploy items to the workspaces for Development and Test.
Prevent the developers from deploying items to the workspace for Production.
Ensure that developers can view items in Production.
Follow the principle of least privilege.
Which three levels of access should you assign to the developers? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
Correct Answer: B,C,E
Vote an answer
You have the following KQL query named Query1.
You need to improve the performance of Query1.
The solution must minimize resource use How should you restructure Query1?
You need to improve the performance of Query1.
The solution must minimize resource use How should you restructure Query1?
Correct Answer: D
Vote an answer
You have a Fabric tenant that contains a warehouse.
Several times a day. the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse.
What should you use to identify whether throttling is occurring?
Several times a day. the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse.
What should you use to identify whether throttling is occurring?
Correct Answer: D
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You have a Fabric tenant
You are creating a Fabric Data Factory pipeline.
You have a stored procedure that returns the number of active customers and their average sales for the current month.
You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline.
Which type of activity should you add?
You are creating a Fabric Data Factory pipeline.
You have a stored procedure that returns the number of active customers and their average sales for the current month.
You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline.
Which type of activity should you add?
Correct Answer: C
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You have a Fabric workspace named Workspace1 that contains a KQL database The database contains a table named Table1. Workspace1 is allocated to an F 128 capacity. Table1 contains 10 billion rows and 25 columns named d through c25. Column cl contains identifiers that range from 1 to 15 and are equally distributed.
You have the following query.
You modify the query as shown.
How will the execution time of the query be affected?
You have the following query.
You modify the query as shown.
How will the execution time of the query be affected?
Correct Answer: A
Vote an answer
You have a Fabric tenant that contains a workspace named Workspace1 and a user named DBUser.
Workspace1 contains a lakehouse named Lakehousel. DBUser does NOT have access to the tenant.
You grant DBUser access to Lakehouse1 as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Workspace1 contains a lakehouse named Lakehousel. DBUser does NOT have access to the tenant.
You grant DBUser access to Lakehouse1 as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
In Microsoft Fabric, the OneLake endpoint allows users with appropriate permissions to read data from a lakehouse, leveraging the unified data storage system. Since DBUser has been granted access to Lakehouse1, they can utilize the OneLake endpoint for reading data. For querying, the OneLake file explorer provides a user interface to interact with and query data within the lakehouse, aligning with DBUser ' s access rights without requiring broader tenant permissions.
You have a query in Power Query Editor that contains two columns named Order_Date and Shipping_Date.
You need to create a column that will calculate the number of days between Order_Date and Shipping_Date for each row.
Which Power Query function should you use?
You need to create a column that will calculate the number of days between Order_Date and Shipping_Date for each row.
Which Power Query function should you use?
Correct Answer: D
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
