File Info
| Exam | Implementing Analytics Solutions Using Microsoft Fabric |
| Number | DP-600 |
| File Name | Microsoft.DP-600.VCEplus.2024-03-12.30q.vcex |
| Size | 2 MB |
| Posted | Mar 12, 2024 |
| Download | Microsoft.DP-600.VCEplus.2024-03-12.30q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
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?
- The column has duplicate values.
- All the table rows are profiled.
- The column has missing values.
- There are 935 values that occur only once.
Correct answer: B
Question 2
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.
Correct answer: To work with this question, an Exam Simulator is required.
Question 3
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.
Correct answer: To work with this question, an Exam Simulator is required.
Question 4
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.
Correct answer: To work with this question, an Exam Simulator is required.
Question 5
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
Correct answer: D
Question 6
Which type of data store should you recommend in the AnalyticsPOC workspace?
- a data lake
- a warehouse
- a lakehouse
- an external Hive metaStore
Correct answer: C
Question 7
You have a Fabric warehouse that contains a table named Staging.Sales. Staging.Sales contains the following columns.
You need to write a T-SQL query that will return data for the year 2023 that displays ProductID and ProductName arxl has a summarized Amount that is higher than 10,000. Which query should you use?
Correct answer: A
Question 8
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, and the last updated time of the most recent row for each customer ID.
How should you complete the code? To answer, select the appropriate options in the answer area,
NOTE Each correct selection is worth one point.
Correct answer: To work with this question, an Exam Simulator is required.
Question 9
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.
- user-defined aggregations
- automatic aggregation
- query caching
- OneLake integration
Correct answer: AB
Question 10
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.
Correct answer: E
