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

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 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 analyzing the data in a Fabric notebook.You have a Spark DataFrame assigned to a variable named df.You need to use the Chart view in the notebook to explore the data manually. Which function should you run to make the data available in the Chart view?

• displayMTML
• show
• write
• display

You have a Fabric tenant that contains a new semantic model in OneLake. You use a Fabric notebook to read the data into a Spark DataFrame.You need to evaluate the data to calculate the min, max, mean, and standard deviation values for all the string and numeric columns.Solution: You use the following PySpark expression:df.show()Does this meet the goal?

• Yes
• No

You have a Fabric tenant that contains a machine learning model registered in a Fabric workspace. You need to use the model to generate predictions by using the predict function in a fabric notebook. Which two languages can you use to perform model scoring? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.

• T-SQL
• DAX EC.
• Spark SQL
• PySpark

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

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 contains a warehouse. The warehouse uses row-level security (RLS). You create a Direct Lake semantic model that uses the Delta tables and RLS of the warehouse. When users interact with a report built from the model, which mode will be used by the DAX queries?

• DirectQuery
• Dual
• Direct Lake
• Import

You have a Fabric tenant that contains a new semantic model in OneLake. You use a Fabric notebook to read the data into a Spark DataFrame.You need to evaluate the data to calculate the min, max, mean, and standard deviation values for all the string and numeric columns.Solution: You use the following PySpark expression:df.explain()Does this meet the goal?

• Yes
• No

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.