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

a pipeline that contains a KQL activity

You need to recommend a solution to prepare the tenant for the PoC.Which two actions should you recommend performing from the Fabric Admin portal? Each correct answer presents part of the solution.NOTE: Each correct answer is worth one point.

Enable the Users can try Microsoft Fabric paid features option for specific security groups.

Enable the Users can create Fabric items option for specific security groups.

Enable the Users can try Microsoft Fabric paid features option for specific security groups.

Enable the Allow Azure Active Directory guest users to access Microsoft Fabric option for specific security groups.

Enable the Users can create Fabric items option and exclude specific security groups.

Enable the Users can try Microsoft Fabric paid features option for the entire organization.

Enable the Users can create Fabric items option for specific security groups.

You need to ensure the data loading activities in the AnalyticsPOC workspace are executed in the appropriate sequence. The solution must meet the technical requirements.What should you do?

Create a pipeline that has dependencies between activities and schedule the pipeline.

Create and schedule a Spark job definition.

Create a dataflow that has multiple steps and schedule the dataflow.

Create and schedule a Spark notebook.

You need to implement the date dimension in the data store. The solution must meet the technical requirements.What are two ways to achieve the goal? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

Populate the date dimension table by using a dataflow.

Populate the date dimension table by using a Stored procedure activity in a pipeline.

Populate the date dimension table by using a dataflow.

Populate the date dimension table by using a Stored procedure activity in a pipeline.

Populate the date dimension view by using T-SQL.

Populate the date dimension table by using a Copy activity in a pipeline.

You have a Fabric tenant that contains a Microsoft Power Bl report named Report 1. Report1 includes a Python visual. Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed. You need all rows to appear in the visual. What should you do?

Add a unique field to each row.

Reference the columns in the Python code by index.

Modify the Sort Column By property for all columns.

Add a unique field to each row.

Modify the Summarize By property for all columns.

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?

All the table rows are profiled.

The column has duplicate values.

All the table rows are profiled.

There are 935 values that occur only once.

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.

From the Tenant settings, set Allow XMLA Endpoints and Analyze in Excel with on-premises datasets to Enabled

From the Tenant settings, select Users can edit data models in the Power Bl service.

From the Capacity settings, set XMLA Endpoint to Read Write

From the Tenant settings, set Allow XMLA Endpoints and Analyze in Excel with on-premises datasets to Enabled

From the Tenant settings, set Allow Azure Active Directory guest users to access Microsoft Fabric to Enabled

From the Tenant settings, select Users can edit data models in the Power Bl service.

From the Capacity settings, set XMLA Endpoint to Read Write

From the Tenant settings, set Users can create Fabric items to Enabled

From the Tenant settings, enable Publish to Web

You need to provide Power Bl developers with access to the pipeline. The solution must meet the following requirements:* Ensure that the developers can deploy items to the workspaces for Development and Test.* Prevent the developers from deploying items to the workspace for Production.* Follow the principle of least privilege.Which three levels of access should you assign to the developers? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

Admin access to the deployment pipeline

Viewer access to the Production workspace

Contributor access to the Development and Test workspaces

Build permission to the production semantic models

Admin access to the deployment pipeline

Viewer access to the Development and Test workspaces

Viewer access to the Production workspace

Contributor access to the Development and Test workspaces

Contributor access to the Production workspace

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?

The data type of the column used to partition the data has changed.

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 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 On.

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 semantic model. The model uses Direct Lake mode.You suspect that some DAX queries load unnecessary columns into memory.You need to identify the frequently used columns that are loaded into memory.What are two ways to achieve the goal? Each correct answer presents a complete solution.NOTE: Each correct answer is worth one point.

Use the Vertipaq Analyzer tool.

Query the $system.discovered_STORAGE_TABLE_COLUMN-iN_SEGMeNTS dynamic management view (DMV).

Use the Analyze in Excel feature.

Use the Vertipaq Analyzer tool.

Query the $system.discovered_STORAGE_TABLE_COLUMN-iN_SEGMeNTS dynamic management view (DMV).

Query the discover_hehory6Rant dynamic management view (DMV).

You have a Fabric tenant that contains a semantic model named Model1. Model1 uses Import mode. Model1 contains a table named Orders. Orders has 100 million rows and the following fields. You need to reduce the memory used by Model! and the time it takes to refresh the model. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

Split OrderDateTime into separate date and time columns.

Replace TotalSalesAmount with a measure.

Split OrderDateTime into separate date and time columns.

Replace TotalQuantity with a calculated column.

Convert Quantity into the Text data type.

Replace TotalSalesAmount with a measure.

You have a Fabric tenant that contains a semantic model.You need to prevent report creators from populating visuals by using implicit measures.What are two tools that you can use to achieve the goal? Each correct answer presents a complete solution.NOTE: Each correct answer is worth one point.

Microsoft SQL Server Management Studio (SSMS)

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 Destination tab, set Table action to Overwrite.

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

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 Tables section.

Create a shortcut in the Files section.

Create a shortcut in the Tables section.

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?

Use the Load to Tables feature.

Create a new shortcut in the Files section.

Create a new shortcut in the Tables section.

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?

From the Destination tab, select the partition column,

From the Destination tab, set Mode to Append.

From the Destination tab, select the partition column,

From the Source tab, select Enable partition discovery

From the Destination tab, set Mode to Overwrite.

Microsoft DP-600 Practice Test 1 - Free Online Exam Prep & Questions

HOTSPOT

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.

Microsoft DP-600 image Question 1 5217689 10022024015944000

Correct answer:

Microsoft DP-600 image answer Question 1 5217689 10022024015944000

Comment (0)

asked 02/10/2024

Ricardson Albuquerque

38 questions

Microsoft DP-600 Practice Test 1

Question

Microsoft DP-600 Practice Tests

Practice Tests