DP-600 V0

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

You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily. You create a Microsoft Power Bl semantic model named Modell that uses the CSV files as a data source. You configure incremental refresh for Model 1 and publish the model to a Premium...

You need to ensure that Contoso can use version control to meet the data analytics requirements and the general requirements. What should you do?A . Store all the semantic models and reports in Data Lake Gen2 storage.B . Modify the settings of the Research workspaces to use a GitHub repository.C...

Topic 2, Contoso, ltd. Overview Contoso, ltd. is a US-based health supplements company, Contoso has two divisions named Sales and Research. The Sales division contains two departments named Online Sales and Retail Sales. The Research division assigns internally developed product lines to individual teams of researchers and analysts. Identity Environment...

HOTSPOT 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. View AnswerAnswer: Explanation: You should use CREATE VIEW to make the pricing group...

HOTSPOT 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. View AnswerAnswer: Explanation: The measure should use the AVERAGE function...

HOTSPOT You have a data warehouse that contains a table named Stage. Customers. Stage-Customers contains all the customer record updates from a customer relationship management (CRM) system. There can be multiple updates per customer You need to write a T-SQL query that will return the customer ID, name, postal code,...

What should you recommend using to ingest the customer data into the data store in the AnatyticsPOC workspace?A . a stored procedureB . a pipeline that contains a KQL activityC . a Spark notebookD . a dataflowView AnswerAnswer: D Explanation: For ingesting customer data into the data store in the...

Topic 1, Contoso Case Study Overview Litware. Inc. is a manufacturing company that has offices throughout North America. The analytics team at Litware contains data engineers, analytics engineers, data analysts, and data scientists. Existing Environment litware has been using a Microsoft Power Bl tenant for three years. Litware has NOT...

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?A . Create a pipeline that has dependencies between activities and schedule the pipeline.B . Create and schedule a Spark job definition.C...