Pass the Microsoft Microsoft Certified: Fabric Analytics Engineer Associate DP-600 Questions and answers with CertsForce

The measure should use the AVERAGE function to calculate the average value.

It should reference the Response Value column from the 'Survey' table.

The 'Number of months' should be used to define the period for the average calculation.

To calculate the average overall satisfaction score using DAX, you would need to use the AVERAGE function on the response values related to satisfaction questions. The DATESINPERIOD function will help in calculating the rolling average over the last 12 months.

You should use CREATE VIEW to make the pricing group logic available for T-SQL queries.

The CASE statement should be used to determine the pricing group based on the list price.

The T-SQL statement should create a view that classifies products into pricing groups based on the list price. The CASE statement is the correct conditional logic to assign each product to the appropriate pricing group. This view will standardize the pricing group logic across different databases and semantic models.

For the semantic model design required for the customer satisfaction report, the choices for data source authentication method and mode should be made based on security and performance considerations as per the case study provided.

Authentication method: The data should be accessed securely, and given that row-level security (RLS) is required for users executing T-SQL queries, you should use an authentication method that supports RLS. Service principal authentication is suitable for automated and secure access to the data, especially when the access needs to be controlled programmatically and is not tied to a specific user's credentials.

Mode: The report needs to show data as soon as it is updated in the data store, and it should only contain data from the current and previous year. DirectQuery mode allows for real-time reporting without importing data into the model, thus meeting the need for up-to-date data. It also allows for RLS to be implemented and enforced at the data source level, providing the necessary security measures.

Based on these considerations, the selections should be:

Authentication method: Service principal authentication

Mode: DirectQuery

You need to recommend which type of Fabric capacity SKU meets the data analytics requirements for the Research division.

Requirement: “The Research division workspaces must use a dedicated, on-demand capacity that has per-minute billing.”

Fabric capacity SKUs:

F (Fabric) = dedicated Fabric capacity, available on pay-as-you-go with per-minute billing.

P (Premium) and EM are Power BI capacities (not Fabric-native).

A refers to Azure Analysis Services capacity.

The only correct option is F SKU.

The results will form a hierarchy of folders for each partition key. - Yes

The resulting file partitions can be read in parallel across multiple nodes. - Yes

The resulting file partitions will use file compression. - No

Partitioning data by columns such as year, month, and day, as shown in the DataFrame write operation, organizes the output into a directory hierarchy that reflects the partitioning structure. This organization can improve the performance of read operations, as queries that filter by the partitioned columns can scan only the relevant directories. Moreover, partitioning facilitates parallelism because each partition can be processed independently across different nodes in a distributed system like Spark. However, the code snippet provided does not explicitly specify that file compression should be used, so we cannot assume that the output will be compressed without additional context.

References =

DataFrame write partitionBy

Apache Spark optimization with partitioning

Step 1: Understand the scenario

Workspace1 contains a semantic model and two Power BI reports.

A Microsoft 365 Data Loss Prevention (DLP) policy (DLP1) already exists.

Requirement: Apply DLP1 to the workspace items.

In Microsoft Fabric and Power BI, DLP policies are enforced through Microsoft Purview Information Protection (MIP) sensitivity labels.

Step 2: Evaluate each option

A. Apply a master data endorsement to the semantic model.

Endorsements (promoted, certified) help users find and trust datasets but do not enforce DLP policies.

Not correct.

B. Apply a certified endorsement to the semantic model.

Certification improves discoverability and trust, but again, it does not trigger DLP policy enforcement.

Not correct.

C. Create a workspace identity.

Workspace identity (service principal) is used for connecting to external resources with managed identity.

It does not relate to DLP policy application.

Not correct.

D. Apply sensitivity labels to the semantic model and reports.

Sensitivity labels (from Microsoft Purview) integrate with Microsoft 365 DLP policies.

When sensitivity labels are applied to Power BI datasets, reports, dashboards, and workspaces, DLP1 can enforce protections such as preventing sharing or exporting sensitive data.

This is the correct answer.

Step 3: Correct Action

To apply DLP1 to Workspace1 items, you must:

Configure sensitivity labels in Microsoft Purview.

Apply those sensitivity labels to the semantic model and reports inside Workspace1.

The existing DLP1 policy will then govern data handling for those items.

References

Sensitivity labels in Power BI

Apply sensitivity labels to Power BI items

DLP policies in Microsoft Purview

To identify whether throttling is occurring, you should use the Monitoring hub (B). This provides a centralized place where you can monitor and manage the health, performance, and reliability of your data estate, and see if the compute resources are being throttled. References = The use of the Monitoring hub for performance management and troubleshooting is detailed in the Azure Synapse Analytics documentation.

You should set Repeat for the schedule to Weekly (C). This allows you to specify the pipeline to run on specific days of the week, in this case, every four hours on Mondays and Fridays. References = Scheduling options for data pipelines are available in the Azure Data Factory documentation, which includes details on configuring recurring triggers.

User1 must be able to:

Create a new domain.

Create two subdomains.

Assign Workspace1 to subdomain1.

Assign Workspace2 to subdomain2.

Key Role Definitions in Fabric:

Domain admin: Can manage domain settings, add/remove workspaces, manage contributors.

Domain contributor: Can contribute to an existing domain but cannot create a domain.

Workspace admin: Only controls permissions/settings inside a workspace, not domains.

Fabric admin: Tenant-wide admin, broader than required.

Requirement: Follow least privilege.

To create a new domain → Requires Domain admin.

To assign workspaces to subdomains → Domain admin rights are sufficient.

Fabric admin is excessive and breaks least privilege.

Correct Answer:

A. Domain admin