Microsoft Implementing Analytics Solutions Using Microsoft Fabric DP-600 Exam Questions

Page: 1 / 14
Total 209 questions
Question 1

You have a Microsoft Power Bl semantic model that contains a table named Date. Date contains the following data.

You need to ensure that the visuals that use the Date table appear in chronological order. The solution must minimize administrative effort.

What should you do?



Answer : C


Question 2

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?



Answer : C


Question 3

You have a Fabric tenant that contains a semantic model.

You need to prevent report creators from populating visuals by using implicit measures.

What are two tools that you can use to achieve the goal? Each correct answer presents a complete solution.

NOTE: Each correct answer is worth one point.



Answer : A, B

Microsoft Power BI Desktop (A) and Tabular Editor (B) are the tools you can use to prevent report creators from using implicit measures. In Power BI Desktop, you can define explicit measures which can be used in visuals. Tabular Editor allows for advanced model editing, where you can enforce the use of explicit measures. Reference = Guidance on using explicit measures and preventing implicit measures in reports can be found in the Power BI and Tabular Editor official documentation.


Question 4

You have a Fabric tenant named Tenant! that contains a lakehouse named Lakehouse1.

You need to add data to Lakehouse1 from a CSV file in an Azure Storage account outside of Fabric. The solution must minimize development effort.

What should you use to add the data?



Answer : B

Comprehensive Detailed Explanation

Requirement

Tenant: Fabric tenant Tenant1

Data target: Lakehouse1

Data source: CSV file in an Azure Storage account (outside of Fabric)

Requirement: Minimize development effort

Step 1: Understand options

A . Dataflow Gen2

Used for ETL (transformations, cleansing, ingestion).

More effort because you need to build Power Query transformations.

Not minimal effort for simply exposing a file.

B . Shortcut

Fabric supports creating shortcuts to external data sources (OneLake, ADLS Gen2, Azure Blob, Dataverse, etc.).

Shortcut directly exposes external files/tables inside the lakehouse without copying or moving data.

This is the lowest-effort solution to access external CSV.

C . Copy job

Pipelines have a copy activity to physically copy data into Fabric.

Requires setup and execution. More development effort than a shortcut.

D . Pipeline

Used for orchestrating complex ETL workflows.

Overhead for this scenario.

Step 2: Correct Answer

Since the goal is simply to access a CSV in external storage with minimal development effort, the right solution is:

B . a shortcut

Reference

Shortcuts in Microsoft Fabric OneLake

Dataflow Gen2 overview


Question 5

You have a Fabric warehouse that contains a table named SalesOrderDetail. SalesOrderDetail contains three columns named OrderQty, ProductID and SalesOrderlD. SalesOrderDetail contains one row per combination of SalesOrderlD and ProductID.

You need to calculate the proportion of the total quantity of each sales order represented by each product within the sales order.

Which T-SQL statement should you run?

A)

B)

C)

D)



Answer : C


Question 6

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?



Answer : D


Question 7

You have a Fabric tenant that contains a workspace named Workspace1.

You plan to deploy a semantic model named Model1 by using the XMLA endpoint.

You need to optimize the deployment of Model1. The solution must minimize how long it takes to deploy Model1.

What should you do in Workspace1?



Answer : A


Page:    1 / 14   
Total 209 questions