Microsoft DP-600 Implementing Analytics Solutions Using Microsoft Fabric Exam Practice Test
Implementing Analytics Solutions Using Microsoft Fabric Questions and Answers
You have a Fabric tenant that contains a lakehouse named LH1 and a notebook.
You have a Parquet file named invoice1 that contains a column named InvoiceDateKey of the timestamp data type.
You need to create a PySpark script that will import invoice1 and create a table named fact_sale in LH1. The solution must meet the following requirements:
• A new column named Year must be added to fact_sale.
• The values in Year must use the InvoiceDateKey column.
How should you complete the script? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a Fabric tenant that contains two lakehouses.
You are building a dataflow that will combine data from the lakehouses. The applied steps from one of the queries in the dataflow is 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.
You have three Fabric workspaces named Workspace1, Workspace2, and Workspace3 Workspace1 contains a report named Report1 and a semantic model named Model1 in import mode.
You perform the following actions;
• Create a deployment pipeline named Pipeline1 that has three stages named development, test, and production.
• Assign Workspace1 to the development stage of Pipeline1.
• Assign Workspace2 to the test stage of Pipeline.
• Assign Wofkspace3 to the production stage of Pipeline1
• Modify Model1.
You need to ensure that changes to Model! are available in the production stage as quickly as possible. The solution must NOT affect the availability of Report1.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You are building a Microsoft Fabric solution that will use a Microsoft Power Bl semantic model named Model 1 as a data source
Users will ask plain-English Questions about sales measures and dimensions in Modell,
You need to ensure that the solution generates answers grounded in Modell. The solution must be reusable outside a single Power Bl report
What should you use?
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 Workspace_TEST. In Pipeline1, all items that have matching names are paired.
You deploy the contents of Workspace_DEV to Workspace_TEST by using Pipeline1.
What will the contents of Workspace_TEST be once the deployment is complete?
You have a Fabric workspace named Workspace1 and an Azure SQL database.
You plan to create a dataflow that will read data from the database, and then transform the data by performing an inner join. You need to ignore spaces in the values when performing the inner join The solution must minimize development effort. What should you do?
You have a Fabric notebook that has the Python code and output shown in the following exhibit.
Which type of analytics are you performing?
You have the following T-SQL statement.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You have a Microsoft Power Bl 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 values from the data sources from being pushed to the repository. Which file should you reference?
You have a Fabric tenant named Tenant1 that contains a workspace named WS1. WS1 uses a capacity named C1 and contains a dawset named DS1. You need to ensure read-write access to DS1 is available by using the XMLA endpoint. What should be modified first?
Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether the solution meets the stated goals. More than one solution in the set might solve the problem. It is also possible that none of the solutions in the set solve the problem.
After you answer a question in this section, you will NOT be able to return. As a result, these questions do not appear on the Review Screen.
Your network contains an on-premises Active Directory Domain Services (AD DS) domain named contoso.com that syncs with a Microsoft Entra tenant by using Microsoft Entra Connect.
You have a Fabric tenant that contains a semantic model.
You enable dynamic row-level security (RLS) for the model and deploy the model to the Fabric service.
You query a measure that includes the username () function, and the query returns a blank result.
You need to ensure that the measure returns the user principal name (UPN) of a user.
Solution: You update the measure to use the USEROBJECT () function.
Does this meet the goal?
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 currency.
You need to ensure that the value returned by TotalSalesAmount is formatted to use the correct currency symbol.
What should you include in the solution?
You have a Microsoft Power Bl semantic model that contains a single table named Orders. Orders contains the following columns:
• Product Name
• Order Date
• Quantity
You have a Power Bl 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?
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?
You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains three schemas named schemaA, schemaB. and schemaC
You need to ensure that a user named User1 can truncate tables in schemaA only.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 returns 500 rows of data.
You need to identify the min and max values for each column in the query results.
Which three Data view options should you select? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Fabric tenant that contains a semantic model named Model1.
You discover that the following query performs slowly against Model1.
You need to reduce the execution time of the query.
Solution: following code:
Does this meet the goal?
You have a Fabric warehouse named Warehousel that contains a table named Table! Tablel contains customer data.
You need to implement row-level security (RLS) for Tablel. The solution must ensure that users can see only their respective data.
Which two objects should you create? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You have an Amazon Web Services (AWS) subscription that contains an Amazon Simple Storage Service (Amazon S3) bucket named bucketl.
You have a Fabric tenant that contains a lakehouse named LH1.
In LH1, you plan to create a OneLake shortcut to bucketl.
You need to configure authentication for the connection.
Which two values should you provide? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
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?
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?
You need to recommend which type of fabric capacity SKU meets the data analytics requirements for the Research division. What should you recommend?
Which syntax should you use in a notebook to access the Research division data for Productlinel?
A)
B)
C)
D)
Which workspace rote assignments should you recommend for ResearchReviewersGroupl and ResearchReviewersGroupZ? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
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.
You need to ensure that Contoso can use version control to meet the data analytics requirements and the general requirements. What should you do?
What should you use to implement calculation groups for the Research division semantic models?
You need to recommend a solution to group the Research division workspaces.
What should you include in the recommendation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution?
You need to implement the date dimension in the data store. The solution must meet the technical requirements.
What are two ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
What should you recommend using to ingest the customer data into the data store in the AnatyticsPOC workspace?
You to need assign permissions for the data store in the AnalyticsPOC workspace. The solution must meet the security requirements.
Which additional permissions should you assign when you share the data store? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to resolve the issue with the pricing group classification.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to ensure the data loading activities in the AnalyticsPOC workspace are executed in the appropriate sequence. The solution must meet the technical requirements.
What should you do?
Which type of data store should you recommend in the AnalyticsPOC workspace?
You need to recommend a solution to prepare the tenant for the PoC.
Which two actions should you recommend performing from the Fabric Admin portal? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
You need to design a semantic model for the customer satisfaction report.
Which data source authentication method and mode should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to create a DAX measure to calculate the average overall satisfaction score.
How should you complete the DAX code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
