DP-600 practice questions 181–190

1. Question 181 · 190 in bank

   You have a Microsoft Power BI semantic model that contains a single table named Orders. Orders contains the following columns: • Product Name • Order Date • Quantity You have a Power BI report that contains a page named Inventory. Inventory contains a slicer for the Product Name column and a clustered column chart that shows Quantity by Order Date. You need to ensure that users can select whether to display Quantity by Product Name or Quantity by Order Date in the chart. The solution must minimize development effort. What should you create?

   • Aa measure
   • Ba dynamic format sting
   • Ca field parameter
   • Da calculation group

   Show answer

   Answer: C

   Next question

2. Question 182 · 190 in bank

   You have a Fabric workspace named Workspace1. You have a GitHub repository named Repo1. You need to connect Workspace1 to the main branch of Repo1. Which information should you provide?

   • Aa shared access signature (SAS) token and the branch name of Repo1
   • Ba personal access token (PAT) and the URL of Repo1
   • Can access key and the branch name of Repo1
   • Dan access key and the URL of Repo1

   Show answer

   Answer: B

   Next question

3. Question 183 · 190 in bank

   You have an Azure SQL database named DB1 and a Fabric workspace named Workspace1. Workspace1 contains a lakehouse named LH1 and a Dataflow Gen2 named Dataflow1. Dataflow1 includes a query named Query1 that loads data from DB1, applies transformations to the data, and then filters the data. You discover that Query1 loads all the data before applying the transformations. You need to ensure that Query1 uses query folding. What should you do?

   • ARemove unused columns from Query1.
   • BEnable incremental refresh for Query1.
   • CReplace DB1 with a Microsoft SQL Server database.
   • DMove the filter steps before the transformation steps in Query1.

   Show answer

   Answer: D

   Next question

4. Question 184 · 190 in bank

   You have a Microsoft Power BI 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 solutions must minimize administrative effort. What should you do?

   • ASort the Month Number column by Column.
   • BSort the visuals by using the Sort ascending option on Fiscal Month.
   • CSort the Fiscal Month column by Column.
   • DSort the Date table by Column.

   Show answer

   Answer: C

   Next question

5. Question 185 · 190 in bank

   Select 2

   You have a Fabric tenant that contains a semantic model named Model1. Model1 contains a fact table named FactSales. FactSales has a relationship to a dimension table named DimDate on a column named OrderDate. To FactSales, you add a second relationship between FactSales and DimDate based on a column named ShippedDate. You need to filter by using ShippedDate in a new report. The solution must NOT affect the function of existing reports. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

   • AEnable the ShippedDate relationship.
   • BUse a RELATEDTABLE DAX function.
   • CUse a CROSSFILTER DAX function.
   • DUse a USERELATIONSHIP DAX function.
   • EDisable the ShippedDate relationship between the tables.

   Show answer

   Answer: DE

   Next question

6. Question 186 · 190 in bank

   You have a Fabric tenant. You need to create a semantic model that delivers fast report rendering, minimizes query latency, and maximizes flexibility for DAX calculations. Which storage mode should you select?

   • AImport
   • BDirect Lake
   • CComposite Mode
   • DDirectQuery

   Show answer

   Answer: A

   Next question

7. Question 187 · 190 in bank

   You have a Fabric workspace named Workspace1 and a user named User1. You need to ensure that User1 can perform the following tasks in Workspace1: • Create dashboards. • Publish semantic models. • Create and publish reports. The solution must follow the principle of least privilege. Which workspace role should you assign to User1?

   • AContributor
   • BMember
   • CViewer
   • DAdmin

   Show answer

   Answer: A

   Next question

8. Question 188 · 190 in bank

   You are designing a Fabric semantic model named Model1 for a financial analytics workspace. Model1 includes a DAX measure named Measure1 that returns total sales. You have a table named Currency that contains a column named Format. The Format column defines currency formatting strings for each record as follows: $#, ##0.00, €#, ##0.00, OR ¥#,##0.00. You have a report that uses the Currency column to identify which symbol and format string to display. In the report, Measure1 must appear with two decimal places and the appropriate currency symbol based on the selected value in the Currency column. You create the following DAX formula. FORMAT = SELECTEDVALUE( ‘Currency’ [Format]) You need to ensure that Measure appears correctly in visuals. The solution must minimize logic duplication. What should you do?

   • ACreate a dynamic format string for Measure1 that references the FORMAT measure.
   • BFor Model1, set the data category of Measure1 to Country/Region.
   • CFor Model1, set the format type of Measure1 to Currency.
   • DCopy the DAX expression from the Format column and paste the expression into the format string expression of Measure1.

   Show answer

   Answer: A

   Next question

9. Question 189 · 190 in bank

   You have a Fabric workspace named Workspace1 that contains the following items: • A warehouse named Warehouse1 • A semantic model named Model1 • An interactive report named Report1 You need to allow a user named User1 to access a single table in Warehouse1. The solution must follow the principle of least privilege. What should you do first?

   • AAssign the Viewer role to User1 for Workspace1.
   • BShare Warehouse1 with User1.
   • CAssign object-level permissions to User1 for Warehouse1.
   • DAssign the db_datareader role to User1 for Warehouse1.

   Show answer

   Answer: C

   Next question

10. Question 190 · 190 in bank

    You have a Fabric workspace named Workspace1 that contains a semantic model and a report named Report1. Workspace1 is connected to a Git repository named Git1. You have a deployment pipeline that contains three stages named Development, Test, and Production. You need to publish Report1 to the Production stage. What should you do?

    • ARun a Git commit.
    • BRun a full deployment.
    • CSync Workspace1 with Git1.
    • DRun a backward deployment.

    Show answer

    Answer: C

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-600 practice, question 181. 190 questions available.