Valid DP-600 Dumps shared by PassLeader for Helping Passing DP-600 Exam! PassLeader now offer the newest DP-600 VCE dumps and DP-600 PDF dumps, the PassLeader DP-600 exam questions have been updated and ANSWERS have been corrected, get the newest PassLeader DP-600 dumps with VCE and PDF here: https://www.passleader.com/dp-600.html (119 Q&As Dumps)
BTW, DOWNLOAD part of PassLeader DP-600 dumps from Cloud Storage: https://drive.google.com/drive/folders/12kg_74jyThTLGL-INHQU_P3Xv50caA6l
NEW QUESTION 101
You have a Fabric tenant that contains a lakehouse 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 DETAIL customer
Does this meet the goal?
A. Yes
B. No
Answer: B
Explanation:
Describe Detail give general info about delta table, not the historical operations.
https://learn.microsoft.com/en-us/azure/databricks/delta/table-details
NEW QUESTION 102
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().show()
Does this meet the goal?
A. Yes
B. No
Answer: B
Explanation:
df.explain gives execution plan.
https://spark.apache.org/docs/3.1.2/api/python/reference/api/pyspark.sql.DataFrame.explain.html
NEW QUESTION 103
You have an Azure Repos repository named Repo1 and a Fabric-enabled Microsoft Power BI Premium capacity. The capacity contains two workspaces named Workspace1 and Workspace2. Git integration is enabled at the workspace level. You plan to use Microsoft Power BI Desktop and Workspace1 to make version-controlled changes to a semantic model stored in Repo1. The changes will be built and deployed to Workspace2 by using Azure Pipelines. You need to ensure that report and semantic model definitions are saved as individual text files in a folder hierarchy. The solution must minimize development and maintenance effort. In which file format should you save the changes?
A. PBIP
B. PBIDS
C. PBIT
D. PBIX
Answer: A
Explanation:
Power BI Desktop introduces a new way to author, collaborate, and save your projects. When you save your work as a Power BI Project (PBIP), report and semantic model item definitions are saved as individual plain text files in a simple, intuitive folder structure.
https://learn.microsoft.com/en-us/power-bi/developer/projects/projects-overview
NEW QUESTION 104
You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. In Workspace1, you create a data pipeline named Pipeline1. You have CSV files stored in an Azure Storage account. You need to add an activity to Pipeline1 that will copy data from the CSV files to Lakehouse1. The activity must support Power Query M formula language expressions. Which type of activity should you add?
A. Dataflow.
B. Notebook.
C. Script.
D. Copy data.
Answer: A
Explanation:
To copy data from CSV files to Lakehouse1 in Workspace1, you should add a copy activity to Pipeline1.
https://learn.microsoft.com/en-us/fabric/data-factory/connector-lakehouse-copy-activity
NEW QUESTION 105
You have a Fabric tenant that contains a lakehouse. You plan to use a visual query to merge two tables. You need to ensure that the query returns all the rows in both tables. Which type of join should you use?
A. inner
B. full outer
C. left outer
D. right anti
E. right outer
F. left anti
Answer: B
Explanation:
Left or right will only return one table all rows and other table if exist in the other table, inner will only return if data match in both tables so Full (outer) join will return all data from both tables.
NEW QUESTION 106
You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table that has one million Parquet files. You need to remove files that were NOT referenced by the table during the past 30 days. The solution must ensure that the transaction log remains consistent, and the ACID properties of the table are maintained. What should you do?
A. From OneLake file explorer, delete the files.
B. Run the OPTIMIZE command and specify the Z-order parameter.
C. Run the OPTIMIZE command and specify the V-order parameter.
D. Run the VACUUM command.
Answer: D
Explanation:
To remove files from a Delta table that are no longer referenced by the current version of the table, you should run the VACUUM command.
https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-table-maintenance
NEW QUESTION 107
You have a Fabric workspace named Workspace1 and an Azure SQL database. You plan to create a dataflow that will read data from the database, and then transform the data by performing an inner join. You need to ignore spaces in the values when performing the inner join. The solution must minimize development effort. What should you do?
A. Append the queries by using fuzzy matching.
B. Merge the queries by using fuzzy matching.
C. Append the queries by using a lookup table.
D. Merge the queries by using a lookup table.
Answer: B
Explanation:
Fuzzy Matching: Fuzzy matching allows you to match data even when there are minor differences, such as extra spaces, in the values. This eliminates the need to manually clean or preprocess the data before the join.
https://learn.microsoft.com/en-us/powerquery-m/table-fuzzyjoin
https://learn.microsoft.com/en-us/power-query/merge-queries-fuzzy-match
NEW QUESTION 108
You have a Fabric tenant. You are creating an Azure Data Factory pipeline. You have a stored procedure that returns the number of active customers and their average sales for the current month. You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline. Which type of activity should you add?
A. Switch.
B. Copy data.
C. Append variable.
D. Lookup.
Answer: D
Explanation:
Lookup activity reads and returns the content of a configuration file or table. It also returns the result of executing a query or stored procedure. The output can be a singleton value or an array of attributes, which can be consumed in a subsequent copy, transformation, or control flow activities like ForEach activity.
https://learn.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity
NEW QUESTION 109
You have a Fabric tenant that contains two workspaces named Workspace1 and Workspace2. Workspace1 contains a lakehouse named Lakehouse1. Workspace2 contains a lakehouse named Lakehouse2. Lakehouse1 contains a table named dbo.Sales. Lakehouse2 contains a table named dbo.Customers. You need to ensure that you can write queries that reference both dbo.Sales and dbo.Customers in the same SQL query without making additional copies of the tables. What should you use?
A. a shortcut
B. a dataflow
C. a view
D. a managed table
Answer: A
Explanation:
You can not create view directly. you need to create shortcuts first to access table in different workspaces.
NEW QUESTION 110
You have a Fabric tenant that contains a warehouse. You are designing a star schema model that will contain a customer dimension. The customer dimension table will be a Type 2 slowly changing dimension (SCD). You need to recommend which columns to add to the table. The columns must NOT already exist in the source. Which three types of columns should you recommend? (Each correct answer presents part of the solution. Choose three.)
A. a foreign key
B. a natural key
C. an effective end date and time
D. a surrogate key
E. an effective start date and time0
Answer: CDE
Explanation:
To create SCD type 2 one needs to add a surrogate key + start/end date beside the other technical attributes.
https://learn.microsoft.com/en-us/training/modules/populate-slowly-changing-dimensions-azure-synapse-analytics-pipelines/3-choose-between-dimension-types
NEW QUESTION 111
You have a Fabric tenant that contains a semantic model. The model contains 15 tables. You need to programmatically change each column that ends in the word Key to meet the following requirements:
– Hide the column.
– Set Nullable to False.
– Set Summarize By to None.
– Set Available in MDX to False.
– Mark the column as a key column.
What should you use?
A. Microsoft Power BI Desktop
B. ALM Toolkit
C. Tabular Editor
D. DAX Studio
Answer: C
Explanation:
Tabular Editor allows you to use C# scripts to automate these changes. In PBI Desktop you can do this only manually.
NEW QUESTION 112
You have a custom Direct Lake semantic model named Model1 that has one billion rows of data. You use Tabular Editor to connect to Model1 by using the XMLA endpoint. You need to ensure that when users interact with reports based on Model1, their queries always use Direct Lake mode. What should you do?
A. From Model, configure the Default Mode option.
B. From Partitions, configure the Mode option.
C. From Model, configure the Storage Location option.
D. From Model, configure the Direct Lake Behavior option.
Answer: D
Explanation:
Click on Semantic model. In the Properties pane, choose the Direct Lake behavior for your custom Direct Lake semantic model:
– Automatic: this is the default behavior. It allows Direct Lake with fallback to DirectQuery mode if data can’t be efficiently loaded into memory.
– Direct Lake only: this option ensures no fallback to DirectQuery mode.
https://powerbi.microsoft.com/en-au/blog/leveraging-pure-direct-lake-mode-for-maximum-query-performance/
NEW QUESTION 113
You have a Microsoft Power BI semantic model that contains measures. The measures use multiple CALCULATE functions and a FILTER function. You are evaluating the performance of the measures. In which use case will replacing the FILTER function with the KEEPFILTERS function reduce execution time?
A. when the FILTER function uses a nested calculate function
B. when the FILTER function references a measure
C. when the FILTER function references columns from multiple tables
D. when the FILTER function references a column from a single table that uses Import mode
Answer: D
Explanation:
FILTER returns a table whereas KEEPFILTERS returns a Boolean. So, A, B and C are limitations of uses of Boolean expressions.
https://learn.microsoft.com/en-us/dax/best-practices/dax-avoid-avoid-filter-as-filter-argument
NEW QUESTION 114
You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 returns 500 rows of data. You need to identify the min and max values for each column in the query results. Which three Data view options should you select? (Each correct answer presents part of the solution. Choose three.)
A. Show column value distribution.
B. Enable column profile.
C. Show column profile in details pane.
D. Show column quality details.
E. Enable details pane.
Answer: BCE
NEW QUESTION 115
HotSpot
You have an Azure Data Lake Storage Gen2 account named storage1 that contains a Parquet file named sales.parquet. You have a Fabric tenant that contains a workspace named Workspace1. Using a notebook in Workspace1, you need to load the content of the file to the default lakehouse. The solution must ensure that the content will display automatically as a table named Sales in Lakehouse explorer. How should you complete the code? (To answer, select the appropriate options in the answer area.)
Answer:
Explanation:
https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-notebook-load-data
NEW QUESTION 116
HotSpot
You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a lakehouse named Lakehouse1 and a warehouse named Warehouse1. You need to create a new table in Warehouse1 named POSCustomers by querying the customer table in Lakehouse1. How should you complete the T-SQL statement? (To answer, select the appropriate options in the answer area.)
Answer:
Explanation:
https://learn.microsoft.com/en-us/fabric/data-warehouse/clone-table#limitations
NEW QUESTION 117
Drag and Drop
You are building a solution by using a Fabric notebook. You have a Spark DataFrame assigned to a variable named df. The DataFrame returns four columns. You need to change the data type of a string column named Age to integer. The solution must return a DataFrame that includes all the columns. How should you complete the code? (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.)
Answer:
NEW QUESTION 118
Drag and Drop
You create a semantic model by using Microsoft Power BI Desktop. The model contains one security role named SalesRegionManager and the following tables:
– Sales
– SalesRegion
– SalesAddress
You need to modify the model to ensure that users assigned the SalesRegionManager role cannot see a column named Address in SalesAddress. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Answer:
Explanation:
https://learn.microsoft.com/en-us/fabric/security/service-admin-object-level-security?tabs=table
NEW QUESTION 119
……
Get the newest PassLeader DP-600 VCE dumps here: https://www.passleader.com/dp-600.html (119 Q&As Dumps)
And, DOWNLOAD the newest PassLeader DP-600 PDF dumps from Cloud Storage for free: https://drive.google.com/drive/folders/12kg_74jyThTLGL-INHQU_P3Xv50caA6l