You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse! contains a table named Customer. Customer contains the following data.

You have an internal Microsoft Entra user named User1 that has an email address of [email protected].
You need to provide User1 with access to the Customer table. The solution must prevent User1 from accessing the CreditCard column.
How should you complete the statement? 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 are building a Fabric notebook named MasterNotebookl in a workspace. MasterNotebookl contains the following code.

You need to ensure that the notebooks are executed in the following sequence:
1. Notebook_03
2. Notebook.Ol
3. Notebook_02
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A.Change the concurrency to 3.
• B.Add dependencies to the execution of Note boo k_02.
• C.Move the declaration of Notebook_02 to the bottom of the Directed Acyclic Graph (DAG) definition.
• D.Move the declaration of Notebook_03 to the top of the Directed Acyclic Graph (DAG) definition.
• E.Split the Directed Acyclic Graph (DAG) definition into three separate definitions.
• F.Add dependencies to the execution of Notebook_03.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric warehouse named DW1 that contains four staging tables named ProductCategory, ProductSubcategory, Product, and SalesOrder. ProductCategory, ProductSubcategory, and Product are used often in analytical queries.
You need to implement a star schema for DW1. The solution must minimize development effort.
Which design approach should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

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: *

You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse named DW1 that is modelled by using MD5 hash surrogate keys.
DW1 contains a single fact table that has grown from 200 million rows to 500 million rows during the past year.
You have Microsoft Power BI reports that are based on Direct Lake. The reports show year-over-year values.
Users report that the performance of some of the reports has degraded over time and some visuals show errors.
You need to resolve the performance issues. The solution must meet the following requirements:
Provide the best query performance.
Minimize operational costs.
Which should you do?

• A.Change the MD5 hash to SHA256.
• B.Increase the capacity.C Enable V-Order
• C.Modify the surrogate keys to use a different data type.
• D.Create views.

Comment: *

Name: *

Email: *

Verification: *