DP-600 Exam Questions

You have a Fabric warehouse named Warehouse1 that contains a table named Table1. Table1 contains customer data. You need to implement row-level security (RLS) for Table1. The solut...

You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Table1. Table1 contains the following data. You need to p...

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 deploymen...

You have a Microsoft Power BI project that contains a semantic model. You plan to use Azure DevOps for version control. You need to modify the .gitignore file to prevent the data v...

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 uses Pro license mode and contains a semantic model named Model1. You need to ensure that Model1 sup...

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 visua...

Case Study 1 - Contoso Overview Contoso, Ltd. is a US-based health supplements company. Contoso has two divisions named Sales and Research. The Sales division contains two departme...

You need to create a Microsoft Power BI file that will be used to create multiple reports. The solution must meet the following requirements: - The file must include predefined dat...

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a single semantic model that has two Microsoft Power BI reports. You have a Microsoft 365 s...

You have a Fabric tenant that contains a workspace named Workspace1 and a user named User1. User1 is assigned the Contributor role for Workspace1. You plan to configure Workspace1...

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a data pipeline named Pipeline1 and a lakehouse named Lakehouse1. You perform the following...

Your company has a finance department. You have a Fabric tenant, an Azure Storage account named storage1, and a Microsoft Entra group named Group1. Group1 contains the users in the...

You have a Fabric tenant that contains the workspaces shown in the following table. You have a deployment pipeline named Pipeline1 that deploys items from Workspace_DEV to Workspac...

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 c...

You have a query in Microsoft Power BI Desktop that contains two columns named Order_Date and Shipping_Date. You need to create a column that will calculate the number of days betw...

You have a Fabric tenant that contains a semantic model. You need to modify object-level security (OLS) for the model. What should you use?

You have a Microsoft Power BI semantic model that contains a measure named TotalSalesAmount. TotalSalesAmount returns a sales revenue amount that is translated into a selected curr...

You plan to use Fabric to store data. You need to create a data store that supports the following: - Writing data by using T-SQL - Multi-table transactions - Dynamic data masking W...

You have a Fabric tenant that contains a workspace named Workspace1 and a user named User1. Workspace1 contains a warehouse named DW1. You share DW1 with User1 and assign User1 the...

You have a Fabric tenant named Tenant1 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....

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 c...

You have a Fabric workspace named Workspace1. Workspace1 contains multiple semantic models, including a model named Model1. Model1 is updated by using an XMLA endpoint. You need to...

You have a Fabric workspace named Workspace1. You need to create a semantic model named Model1 and publish Model1 to Workspace1. The solution must meet the following requirements:...

You have a Fabric workspace named Workspace1 that is assigned to a newly created Fabric capacity named Capacity1. You create a semantic model named Model1 and deploy Model1 to Work...

You have a Fabric tenant that contains a workspace named Workspace1 and a user named User1. Workspace1 contains a warehouse named DW1. You share DW1 with User1 and assign User1 the...

You have a Fabric workspace named Workspace1 that contains an eventstream named Eventstream1. Eventstream1 reads data from an Azure event hub named Eventhub1. Eventhub1 contains th...

You have a Fabric warehouse that contains a table named Table1. Table1 contains three columns named SalesAmount, ProductCategory, and TransactionDate. You need to create a Microsof...

You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a Power Query step to identify the maxim...

You have a Fabric tenant that contains two workspaces named Workspace1 and Workspace2. Workspace1 is used as the development environment. Workspace2 is used as the production envir...

You have a semantic model named Model1 that contains data that relates to customers and their bank account balances. Model1 has the following tables and columns. A customer can hav...

You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily. You create a Microsoft Power BI semantic model named Model1 that uses the CSV files as...

Which roles within the workspace in Microsoft Fabric allow members to reshare items?

In the SQL Query Editor within Fabric, what happens to the session context when you run multiple independent query batches?

n a financial services context, a client manages approximately 8 TB of structured data, encompassing multiple schemas such as 'Customer', 'Transactions', and 'Accounts', which are...

In the data warehouse for Adventure Works, the company should track changes in sales territories over time to ensure historical facts are associated with the correct territory. Whi...

Which of the following statements accurately describe the behavior and configuration of Row- level security (RLS) with Power BI?

Which of the following features in the data profiling tools of Microsoft Fabric's Power Query Editor provides a set of visuals showcasing the frequency and distribution of the valu...

When monitoring data flow performance, which of the following should be looked for possible bottlenecks? (Select Two)

In your data cleansing project, you need to identify and remove duplicate entries from a dataset using the Aggregate transformation. Which function should you use within the Aggreg...

Power BI Premium supports the use of sensitivity labels to classify and protect data within reports, dashboards, datasets, and dataflows. When applying sensitivity labels in Power...

What is the primary use of DAX Studio and how does Tabular Editor complement its functionality in Power BI Desktop?

What are the two limitations of the Visual Query Editor? (Select 2)

What is the key feature of creating an empty materialized view?

Shortcuts in OneLake are objects that link to other storage locations, which may be internal or external to OneLake. What are two places you can create shortcuts in fabric? (Select...

When working with Power Query dataflows in Microsoft Power BI, optimizing performance and reusability is critical. An effective strategy is to separate data injection from data tra...