2024 Valid DP-600 Dumps for Helping Passing Microsoft Exam!
Download Free Microsoft DP-600 Exam Questions & Answer
NEW QUESTION # 29
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. a lakehouse
- B. an Azure SQL database
- C. a warehouse
- D. a KQL database
Answer: A
NEW QUESTION # 30
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.
Answer:
Explanation:
NEW QUESTION # 31
You have a Fabric tenant that contains a workspace named Workspace^ Workspacel is assigned to a Fabric capacity.
You need to recommend a solution to provide users with the ability to create and publish custom Direct Lake semantic models by using external tools. The solution must follow the principle of least privilege.
Which three actions in the Fabric Admin portal should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
- A. From the Tenant settings, set Users can create Fabric items to Enabled
- B. From the Capacity settings, set XMLA Endpoint to Read Write
- C. From the Tenant settings, enable Publish to Web
- D. From the Tenant settings, select Users can edit data models in the Power Bl service.
- E. From the Tenant settings, set Allow Azure Active Directory guest users to access Microsoft Fabric to Enabled
- F. From the Tenant settings, set Allow XMLA Endpoints and Analyze in Excel with on-premises datasets to Enabled
Answer: B,C,F
NEW QUESTION # 32
You have a Fabric tenant that contains a lakehouse.
You are using a Fabric notebook to save a large DataFrame by using the following code.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 33
You have a Fabric workspace named Workspace 1 that contains a dataflow named Dataflow1. Dataflow! has a query that returns 2.000 rows. You view the query in Power Query as shown in the following exhibit.
What can you identify about the pickupLongitude column?
- A. The column has duplicate values.
- B. The column has missing values.
- C. All the table rows are profiled.
- D. There are 935 values that occur only once.
Answer: C
NEW QUESTION # 34
You have a Fabric workspace named Workspace1 that contains a data flow named Dataflow1. Dataflow1 contains a query that returns the data shown in the following exhibit.
You need to transform the date columns into attribute-value pairs, where columns become rows.
You select the VendorlD column.
Which transformation should you select from the context menu of the VendorlD column?
- A. Group by
- B. Unpivot columns
- C. Split column
- D. Remove other columns
- E. Unpivot other columns
Answer: B
NEW QUESTION # 35
You need to create a data loading pattern for a Type 1 slowly changing dimension (SCD).
Which two actions should you include in the process? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
- A. Update rows when the non-key attributes have changed.
- B. Insert new records when the natural key is a new value in the table.
- C. Update the effective end date of rows when the non-key attribute values have changed.
- D. Insert new rows when the natural key exists in the dimension table, and the non-key attribute values have changed.
Answer: A,B
NEW QUESTION # 36
You have a Fabric tenant tha1 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:
EXPLAIN TABLE customer
Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION # 37
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?
- A. the WS1 settings
- B. the Tenant1 settings
- C. the DS1 settings
- D. the C1 settings
Answer: D
NEW QUESTION # 38
You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains an unpartitioned table named Table1.
You plan to copy data to Table1 and partition the table based on a date column in the source data.
You create a Copy activity to copy the data to Table1.
You need to specify the partition column in the Destination settings of the Copy activity.
What should you do first?
- A. From the Destination tab, select the partition column,
- B. From the Destination tab, set Mode to Overwrite.
- C. From the Source tab, select Enable partition discovery
- D. From the Destination tab, set Mode to Append.
Answer: A
NEW QUESTION # 39
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.
Answer:
Explanation:
NEW QUESTION # 40
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?
- A. At the semantic model level, set Large dataset storage format to Off.
- B. At the tenant level, set Data Activator to Enabled.
- C. At the semantic model level, set Large dataset storage format to On.
- D. At the tenant level, set Create and use Metrics to Enabled.
Answer: C
NEW QUESTION # 41
You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a subfolder named Subfolder1 that contains CSV files. You need to convert the CSV files into the delta format that has V-Order optimization enabled. What should you do from Lakehouse explorer?
- A. Create a new shortcut in the Files section.
- B. Use the Optimize feature.
- C. Use the Load to Tables feature.
- D. Create a new shortcut in the Tables section.
Answer: C
NEW QUESTION # 42
You have a Fabric workspace named Workspace1 and an Azure Data Lake Storage Gen2 account named storage"!. Workspace1 contains a lakehouse named Lakehouse1.
You need to create a shortcut to storage! in Lakehouse1.
Which connection and endpoint should you specify? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 43
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.
- A. DAX EC.
- B. Spark SQL
- C. T-SQL
- D. PySpark
Answer: B,D
NEW QUESTION # 44
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 visuals on 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.
- A. user-defined aggregations
- B. automatic aggregation
- C. OneLake integration
- D. query caching
Answer: A,B
NEW QUESTION # 45
You have a Fabric tenant tha1 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:
REFRESH TABLE customer
Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION # 46
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.
Answer:
Explanation:
NEW QUESTION # 47
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 .sumary ()
Does this meet the goal?
- A. No
- B. Yes
Answer: B
NEW QUESTION # 48
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?
- A. Model view
- B. data categories
- C. DAX query view
- D. Data view
Answer: A
NEW QUESTION # 49
You have a Fabric tenant that contains a semantic model. The model contains data about retail stores.
You need to write a DAX query that will be executed by using the XMLA endpoint The query must return a table of stores that have opened since December 1,2023.
How should you complete the DAX expression? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 50
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?
- A. No
- B. Yes
Answer: B
NEW QUESTION # 51
......
DP-600 Exam Dumps For Certification Exam Preparation: https://www.real4dumps.com/DP-600_examcollection.html
Online VALID DP-600 Exam Dumps File Instantly: https://drive.google.com/open?id=1CMI41Zz_QYbs2p7G6lBmgvW5Mrb_ub9M
