Free Implementing Analytics Solutions Using Microsoft Fabric Exam DP-600 Exam Practice Test

You have a Fabric tenant that contains a lakehouse.You plan to query sales data files by using the SQL endpoint. The files will be in an Amazon Simple Storage Service (Amazon S3) storage bucket.You need to recommend which file format to use and where to create a shortcut.Which two actions should you include in the recommendation? Each correct answer presents part of the solution.NOTE: Each correct answer is worth one point.

• Create a shortcut in the Files section.
• Use the Parquet format
• Use the CSV format.
• Create a shortcut in the Tables section.
• Use the delta format.

You have a Fabric tenant that contains a takehouse named lakehouse1. Lakehouse1 contains a Delta table named Customer.When you query Customer, you discover that the query is slow to execute. You suspect that maintenance was NOT performed on the table.You need to identify whether maintenance tasks were performed on Customer. Solution: You run the following Spark SQL statement:DESCRIBE HISTORY customer Does this meet the goal?

• Yes
• No

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 capacity in the Fabric tenant.When you initiate a refresh of Model1, the refresh fails after running out of resources. What is a possible cause of the failure?

• Query folding is occurring.
• Only refresh complete days is selected.
• XMLA Endpoint is set to Read Only.
• Query folding is NOT occurring.
• The data type of the column used to partition the data has changed.

You have source data in a folder on a local computer.You need to create a solution that will use Fabric to populate a data store. The solution must meet the following requirements:Support the use of dataflows to load and append data to the data store.Ensure that Delta tables are V-Order optimized and compacted automatically. Which type of data store should you use?

• a lakehouse
• an Azure SQL database
• a warehouse
• a KQL database

You have a Fabric workspace that contains a DirectQuery semantic model. The model queries a data source that has 500 million rows.You have a Microsoft Power Bl report named Report1 that uses the model. Report! contains visualson multiple pages.You need to reduce the query execution time for the visuals on all the pages.What are two features that you can use? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.

• user-defined aggregations
• automatic aggregation
• query caching
• OneLake integration

What should you recommend using to ingest the customer data into the data store in the AnatyticsPOC workspace?

• a stored procedure
• a pipeline that contains a KQL activity
• a Spark notebook
• a dataflow

You have a Fabric tenant that uses a Microsoft tower Bl Premium capacity. You need to enable scale- out for a semantic model. What should you do first?

• At the semantic model level, set Large dataset storage format to Off.
• At the tenant level, set Create and use Metrics to Enabled.
• At the semantic model level, set Large dataset storage format to On.
• At the tenant level, set Data Activator to Enabled.

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 should you use from Microsoft Power Bl Desktop?

• data categories
• Data view
• Model view
• DAX query view

You are the administrator of a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables:Table1: A Delta table created by using a shortcutTable2: An external table created by using SparkTable3: A managed tableYou plan to connect to Lakehouse1 by using its SQL endpoint. What will you be able to do after connecting to Lakehouse1?

• ReadTable3.
• Update the data Table3.
• ReadTable2.
• Update the data in Table1.

You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains a table named Table1.You are creating a new data pipeline.You plan to copy external data to Table1. The schema of the external data changes regularly. You need the copy operation to meet the following requirements:Replace Table1 with the schema of the external data.Replace all the data in Table1 with the rows in the external data.You add a Copy data activity to the pipeline. What should you do for the Copy data activity?

• From the Source tab, add additional columns.
• From the Destination tab, set Table action to Overwrite.
• From the Settings tab, select Enable staging
• From the Source tab, select Enable partition discovery
• From the Source tab, select Recursively