DP 600 Exam Free Questions and Answers | Microsoft Fabric Analytics Engineer Associate

DP 600 Microsoft Fabric Analytics Engineer Associate Exam

Welcome to our blog featuring Microsoft Fabric Analytics Engineer Associate DP 600 exam free Dumps questions and answers for aspiring Microsoft Fabric Analytics Engineer Associates!

This certification journey requires a deep understanding of designing, building, and rolling out large-scale data analytics solutions within enterprises. In this role, your primary focus is on leveraging Microsoft Fabric components to convert data into reusable analytics assets effectively. These components encompass lakehouses, data warehouses, notebooks, dataflows, data pipelines, semantic models, and reports.

Your expertise also extends to implementing analytics best practices in Fabric, emphasizing version control and deployment strategies. Collaboration is key in this role, as you’ll frequently engage with solution architects, data engineers, data scientists, AI engineers, database administrators, and Power BI data analysts.

Aside from mastering the Fabric platform, your experience should encompass data modeling, data transformation, Git-based source control, and exploratory analytics. Proficiency in languages like SQL, DAX, and PySpark is also crucial.

Our blog aims to equip you with the knowledge and insights needed to excel in the DP-600 exam. Dive in, explore, and prepare yourself to plan, implement, and manage robust data analytics solutions, serve and prepare data effectively, implement and oversee semantic models, and explore and analyze data proficiently. Let’s embark on this certification journey together!

Case Study

This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.

To start the case study –
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.

Overview –
Contoso, Ltd. is a US-based health supplements company. Contoso has two divisions named Sales and Research. The Sales division contains two departments named Online Sales and Retail Sales. The Research division assigns internally developed product lines to individual teams of researchers and analysts.

Existing Environment –

Identity Environment –
Contoso has a Microsoft Entra tenant named contoso.com. The tenant contains two groups named ResearchReviewersGroup1 and ResearchReviewersGroup2.

Data Environment –
Contoso has the following data environment:
The Sales division uses a Microsoft Power BI Premium capacity.
The semantic model of the Online Sales department includes a fact table named Orders that uses Import made. In the system of origin, the OrderID value represents the sequence in which orders are created.
The Research department uses an on-premises, third-party data warehousing product.
Fabric is enabled for contoso.com.
An Azure Data Lake Storage Gen2 storage account named storage1 contains Research division data for a product line named Productline1. The data is in the delta format.
A Data Lake Storage Gen2 storage account named storage2 contains Research division data for a product line named Productline2. The data is in the CSV format.

Requirements –

Planned Changes –
Contoso plans to make the following changes:
Enable support for Fabric in the Power BI Premium capacity used by the Sales division.
Make all the data for the Sales division and the Research division available in Fabric.
For the Research division, create two Fabric workspaces named Productline1ws and Productine2ws.
In Productline1ws, create a lakehouse named Lakehouse1.
In Lakehouse1, create a shortcut to storage1 named ResearchProduct.

Data Analytics Requirements –
Contoso identifies the following data analytics requirements:
All the workspaces for the Sales division and the Research division must support all Fabric experiences.
The Research division workspaces must use a dedicated, on-demand capacity that has per-minute billing.
The Research division workspaces must be grouped together logically to support OneLake data hub filtering based on the department name.
For the Research division workspaces, the members of ResearchReviewersGroup1 must be able to read lakehouse and warehouse data and shortcuts by using SQL endpoints.
For the Research division workspaces, the members of ResearchReviewersGroup2 must be able to read lakehouse data by using Lakehouse explorer.
All the semantic models and reports for the Research division must use version control that supports branching.

Data Preparation Requirements –
Contoso identifies the following data preparation requirements:
The Research division data for Productline1 must be retrieved from Lakehouse1 by using Fabric notebooks.
All the Research division data in the lakehouses must be presented as managed tables in Lakehouse explorer.

Semantic Model Requirements –
Contoso identifies the following requirements for implementing and managing semantic models:
The number of rows added to the Orders table during refreshes must be minimized.
The semantic models in the Research division workspaces must use Direct Lake mode.

Question 1

General Requirements –
Contoso identifies the following high-level requirements that must be considered for all solutions:
Follow the principle of least privilege when applicable.
Minimize implementation and maintenance effort when possible.
You need to ensure that Contoso can use version control to meet the data analytics requirements and the general requirements.
What should you do?

A. Store at the semantic models and reports in Data Lake Gen2 storage.

B. Modify the settings of the Research workspaces to use a GitHub repository.

C. Modify the settings of the Research division workspaces to use an Azure Repos repository.

D. Store all the semantic models and reports in Microsoft OneDrive.

Question 2

General Requirements –
Contoso identifies the following high-level requirements that must be considered for all solutions:
Follow the principle of least privilege when applicable.
Minimize implementation and maintenance effort when possible.
You need to recommend a solution to group the Research division workspaces.
What should you include in the recommendation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Grouping method: Capacity | Domain | Tenant

Tool: OneLake data hub | The Fabric Admin portal | The Microsoft Entra admin center

Question 3

General Requirements –
Contoso identifies the following high-level requirements that must be considered for all solutions:
Follow the principle of least privilege when applicable.
Minimize implementation and maintenance effort when possible.
You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements.
What should you include in the solution?

A. an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the maximum value of the OrderID column in the destination lakehouse

B. an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the minimum value of the OrderID column in the destination lakehouse

C. an Azure Data Factory pipeline that executes a dataflow to retrieve the minimum value of the OrderID column in the destination lakehouse

D. an Azure Data Factory pipeline that executes a dataflow to retrieve the maximum value of the OrderID column in the destination lakehouse

Question 4

General Requirements –
Contoso identifies the following high-level requirements that must be considered for all solutions:
Follow the principle of least privilege when applicable.
Minimize implementation and maintenance effort when possible.
Which syntax should you use in a notebook to access the Research division data for Productline1?

A. spark.read.format(“delta”).load(“Tables/productline1/ResearchProduct”)

B. spark.sql(“SELECT * FROM Lakehouse1.ResearchProduct ”)

C. external_table(‘Tables/ResearchProduct)

D. external_table(ResearchProduct)

Question 5

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?

PBIDS
PBIP
PBIX
PBIT

Question 6

You have a Fabric tenant that contains a workspace named Workspace 1. Workspace 1 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 Capacity settings, set XMLA Endpoint to Read Write.
From the Tenant settings, set Allow Azure Active Directory guest users to access Microsoft Fabric to Enabled.
From the Tenant settings, set Users can create Fabric items to Enabled.
From the Tenant settings, set Allow XMLA Endpoints and Analyze in Excel with on- premises datasets to Enabled.
From the Tenant settings, enable Publish to Web.
From the Tenant settings, select Users can edit data models in the Power Bl service

Question 7

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?

when the FILTER function uses a nested CALCULATE function
when the FILTER function references columns from multiple tables
when the FILTER function references a measure
when the FILTER function references a column from a single table that uses Import mode

Question 8

You have a Microsoft Power BI semantic model.

You need to identify any surrogate key columns in the model that have the Summarize By property set to a value other than to None. The solution must minimize effort.

What should you use?

Model view in Microsoft Power BI Desktop
Model explorer in Microsoft Power BI Desktop
DAX Formatter in DAX Studio
Best Practice Analyzer in Tabular Editor

Question 9

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?

Microsoft Power BI Desktop
Tabular Editor
ALM Toolkit
DAX Studio

Question 10

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?

Microsoft Power BI Desktop
Tabular Editor
ALM Toolkit
DAX Studio

Question 11

You have a semantic model named Model1. Modell contains five tables that all use Import mode. Modell contains a dynamic row-level security (RLS) role named HR. The HR role filters employee data so that HR managers only see the data of the department to which they are assigned.

You publish Modell to a Fabric tenant and configure RLS role membership. You shake the model and related reports to users.

An HR manager reports that the data they see in a report is incomplete.

What should you do to validate the data seen by the HR Manager?

Filter the data in the report to match the intended logic of the filter for the HR department.
Select Test as role to view the report as the HR manager.
Ask the HR manager to open the report in Microsoft Power BI Desktop.
Select Test as role to view the data as the HR role.

Question 11

You have a Fabric tenant that contains a Microsoft Power BI report named Report1.

Report1 is slow to render. You suspect that an inefficient DAX query is being executed.

You need to identify the slowest DAX query, and then review how long the query spends in the formula engine as compared to the storage engine.

Which five 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.

Actions

Sort the Duration (ms) column in descending order.

View the Server Timings tab.

Answer Area

Copy the first query to DAX Studio
From Performance analyzer, capture a recording.
Enable Query Timings and Server Timings. Run the query.
View the Query Timings tab.
Sort the Duration (ms) column in descending order by DAX query time.

Question 12

You create a semantic model by using Microsoft Power BI Desktop. The model contains one security role named Sales RegionManager and the following tables:

Sales

SalesRegion
SalesAddress

You need to modify the model to ensure that users assigned the Sales RegionManager role cannot se 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.

Actions

Open the model in Tabular Editor.

Set Object Level Security to None for Sales Region Manager.

Set Object Level Security to Default for Sales Region Manager.

Answer Area

1.Open the model in Power BI Desktop.

2.Select the Address column in Sales Address.

3.Set the Hidden property to True.

Question 13

You have a custom Direct Lake semantic model named Modell 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 Modell, their queries always use Direct Lake mode.

What should you do?

From Model, configure the Default Mode option,
From Model, configure the Storage Location option.
From Partitions, configure the Mode option.
From Model, configure the Direct Lake Behavior option.

Question 14

You have a Microsoft Power BI report named Report1 that uses a Fabric semantic model.

Users discover that Report1 renders slowly.

You open Performance analyzer and identify that a visual named Orders By Date is the slowest to render. The duration breakdown for Orders By Date is shown in the following table.

Name | Duration (ms)

DAX query | 27

Visual display | 39

Other | 1047

What will provide the greatest reduction in the rendering duration of Report1?

Optimize the DAX query of Orders By Date by using DAX Studio.
Reduce the number of visuals in Report1.
Enable automatic page refresh.
Change the visual type of Orders By Date.

Question 15

You have a Fabric workspace that contains a Direct Query semantic model. The model queries a data source that has 500 million rows.

You have a Microsoft Power BI report named Report1 that uses the model. Report1 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
OneLake integration
query caching

Question 16

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 Table 1. 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 Source tab, add additional columns.
From the Settings tab, select Enable staging.
From the Source tab, select Enable partition discovery.
From the Source tab, select Recursively.
From the Destination tab, set Table action to Overwrite

Question 17

You have a Fabric tenant that contains a warehouse named Warehouse 1. Warehouse1 contains two schemas name schema1 and schema2 and a table named schema1.city.

You need to make a copy of schema1.city in schema2. The solution must minimize the copying of data.

Which T-SQL statement should you run?.

CREATE TABLE schema2.city AS CLONE OF schemal.city;
INSERT INTO schema2.city SELECT FROM schema1.city;
SELECT * INTO schema2.city FROM schema1.city;
CREATE TABLE schema2.city AS SELECT FROM schemal.city;

Question 18

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 Lakehouse 1. The activity must support Power Query M formula language expressions.

Which type of activity should you add?

Dataflow
Copy data
Notebook
Script

Question 19

You have a Fabric tenant that contains a lakehouse named Lakehouse1.

You need to prevent new tables added to Lakehouse1 from being added automatically to the defa semantic model of the lakehouse.

What should you configure?

the semantic model settings
the SQL analytics endpoint settings
the workspace settings
the Lakehouse1 settings

Question 20

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?

Merge the queries by using a lookup table.
Append the queries by using fuzzy matching.
Append the queries by using a lookup table.
Merge the queries by using fuzzy matching.

Question 21

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.

NOTE: Each correct selection is worth one point

Answer Area

df.spark.read.parquet(“abfss://fs1@storage1.dfs.core.windows.net/files/sales.parquet

df.write.mode(“overwrite”).format(“parquet”).saveAsTable(“sales”)

Question 22

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?

inner
left outer
right outer
full outer
right anti
left anti

Question 23

You are implementing two dimension tables named Customers and Products in a Fabric warehouse.

You need to use slowly changing dimension (SCD) to manage the versioning of data. The solution must meet the requirements shown in the following table.

Table | Change action

Customers | Create a new version of the row,

Products | Overwrite the existing value in the latest row.

Which type of SCD should you use for each table? To answer, drag the appropriate SCD types to correct tables. Each SCD type may be used once, more than once, or not at all. You may need to d the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

SCD Types

Type 0

Type 1

Type 2

Type 3

Answer Area

Customers: Type 2

Products: Type 1

Question 23

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 lakehouse named Lakehouse1 and a warehouse named Warehouse 1.

You need to create a new table in Warehouse1 named POSCustomers by querying the in Lakehouse1.

How should you complete the T-SQL statement? To answer, select the appropriate opt answer area.

NOTE: Each correct selection is worth one point.

Answer Area

CREATE TABLE dbo.POSCustomers AS SELECT

DISTINCT customerid,

customer,

postalcode,

Career Hunger

DP 600 Exam Free Questions and Answers | Microsoft Fabric Analytics Engineer Associate

DP 600 Microsoft Fabric Analytics Engineer Associate Exam

Leave a Comment Cancel reply

Company

Quick Links

Connect us at

Email us

Career Hunger

DP 600 Exam Free Questions and Answers | Microsoft Fabric Analytics Engineer Associate

DP 600 Microsoft Fabric Analytics Engineer Associate Exam

Share this post

Leave a Comment Cancel reply

Recent News Articles

Expert System In AI

150 Happy Marriage Anniversary Wishes

Company

Quick Links

Connect us at

Email us