You have a Fabric warehouse named Warehouse1 that contains a table named Table1. Table1 contains the following columns that store string values:
* FirstName
* Phone
* Email
You have two Microsoft Entra security groups named Group1 and Group2. The members of both groups can query Table1 and see full values for FirstName, Phone, and Email.
You need to configure Table1 to meet the following requirements:

Correct Answer:

Explanation:

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace that contains a warehouse named Warehouse1.
You have an on-premises Microsoft SQL Server database named Database1 that is accessed by using an on-premises data gateway.
You need to copy data from Database1 to Warehouse1.
Which item should you use?

• A.a Dataflow Gen1 dataflow
• B.a data pipeline
• C.a KQL queryset
• D.a notebook

Comment: *

Name: *

Email: *

Verification: *

Your company has three newly created data engineering teams named Team1, Team2, and Team3 that plan to use Fabric. The teams have the following personas:
* Team1 consists of members who currently use Microsoft Power BI. The team wants to transform data by using by a low-code approach.
* Team2 consists of members that have a background in Python programming. The team wants to use PySpark code to transform data.
* Team3 consists of members who currently use Azure Data Factory. The team wants to move data between source and sink environments by using the least amount of effort.
You need to recommend tools for the teams based on their current personas.
What should you recommend for each team? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric warehouse named DW1 that loads data by using a data pipeline named Pipeline1. Pipeline1 uses a Copy data activity with a dynamic SQL source. Pipeline1 is scheduled to run every 15 minutes.
You discover that Pipeline1 keeps failing.
You need to identify which SQL query was executed when the pipeline failed.
What should you do?

• A.From Monitoring hub, select the latest failed run of Pipeline1, and then view the output JSON.
• B.From Monitoring hub, select the latest failed run of Pipeline1, and then view the input JSON.
• C.From Real-time hub, select Fabric events, and then review the details of Microsoft.Fabric.
  ItemReadFailed.
• D.From Real-time hub, select Fabric events, and then review the details of Microsoft. Fabric.ItemUpdateFailed.

Comment: *

Name: *

Email: *

Verification: *

You need to create the product dimension.
How should you complete the Apache Spark SQL code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
A screenshot of a computer Description automatically generated

Join between Products and ProductSubCategories:
Use an INNER JOIN.
The goal is to include only products that are assigned to a subcategory. An INNER JOIN ensures that only matching records (i.e., products with a valid subcategory) are included.
Join between ProductSubCategories and ProductCategories:
Use an INNER JOIN.
Similar to the above logic, we want to include only subcategories assigned to a valid product category. An INNER JOIN ensures this condition is met.
WHERE Clause
Condition: IsActive = 1
Only active products (where IsActive equals 1) should be included in the gold layer. This filters out inactive products.

Comment: *

Name: *

Email: *

Verification: *