You have semi-structured data.

You need to read the data by using T-SQL, KQL, and Apache Spark. The data will only be written by using Spark. What Should you use to store the data?

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?

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?

You have a Fabric workspace that contains a

Warehouse named DW1. DW1 contains the following tables and columns.

（含图）

You need to create an output that presents

The summarized values of all the order quantities by year and product. The

Results must include a summary of the order quantities at the year level for

All the products.

How should you complete the code? To

Answer, select the appropriate options in the answer area. NOTE: Each correct

Selection is worth one point.

（含图）

选项1和选项2分别是

（含图）

You plan to load the data into a dimensional model and implement a star schema. From the original flat table,

You create two tables named FactSales and DimProduct. You will track Changes in DimProduct. 

You need to prepare the data.

Which three columns should you include in The DimProduct table? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one Point.

Orders -

Customer -

Employee The Employee table contains Personally Identifiable Information (PII).

A data engineer is building a workflow that requires writing data to the Customer table, however, the user does NOT have the elevated permissions required to view the contents of the Employee table.

You need to ensure that the data engineer can write data to the Customer table without reading data from the Employee table.

Which three actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You need to ensure that the sales representatives can see only their respective data.

Which warehouse object do you require to implement RLS?

Four notebooks -

Three lakehouses -

Two data pipelines -

Two Dataflow Gen1 dataflows -

Three Dataflow Gen2 dataflows Five semantic models that each has a scheduled refresh policy You create a deployment pipeline named Pipeline1 to move items from Workspace1_DEV to a new workspace named Workspace1_TEST. You deploy all the items from Workspace1_DEV to Workspace1_TEST.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

（含图）

判断题填写Yes或者No

Data from the semantic modelswillbe deployed to the target stage.

TheDataflowGen1 dataflowswillbe deployed to the target stage.

The scheduled refresh policies will be deployed to the target stage.

Eventhouse. Users report that from OneLake file explorer, they cannot see the data from the eventhouse.You enable OneLake availability for the eventhouse.

What will be Copied to OneLake?

You plan to integrate Workspace1 with Azure DevOps.

You will use a Fabric deployment pipeline named deployPipeline1 to deploy items from Workspace1 to higher environment workspaces as part of a medallion architecture. You will run deployPipeline1 by using an API call from an Azure DevOps pipeline.

You need to configure API authentication between Azure DevOps and Fabric.

Which type of authentication should you use?

（含图）

You have a Fabric workspace named

Workspace1 that has the cache for shortcuts enabled. Workspace1 contains a Lakehouse named Lakehouse1. Lakehouse1 has the shortcuts Shown in the following table.

（含图）

You need to read data from all the Shortcuts.

Which shortcuts will retrieve data from the Cache?

（含图）

You have a Fabric workspace named Workspace1 that has the cache for shortcuts enabled. Workspace1 contains a lakehouse named Lakehouse1. Lakehouse1 has the following shortcuts:

A shortcut to ProductFile aliased as Products A shortcut to StoreFile aliased as Stores A shortcut to TripsFile aliased as Trips The data from which shortcuts will be retrieved from the cache?

（含图）

For Model1, the Keep your Direct Lake data up to date option is disabled.

You need to configure the execution of the items to meet the following requirements:

Notebook1 must execute every weekday at 8:00 AM.

Notebook2 must execute when a file is saved to an Azure Blob Storage container.

Model1 must refresh when Notebook1 has executed successfully.

How should you orchestrate each item? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Notebook1——选项1

Notebook2——选项2

（含图）

（含图）

For Model1, the Keep your Direct Lake data up to date option is disabled.

You need to configure the execution of the items to meet the following requirements:

Notebook1 must execute every weekday at 8:00 AM.

Notebook2 must execute when a file is saved to an Azure Blob Storage container.

Model1 must refresh when Notebook1 has executed successfully.

How should you orchestrate each item? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

（含图）

Pipeline1: 选项1  

Model1:选项2

You need to ensure that a user can perform the following tasks:

Create a new domain for the sales department.

Create two subdomains: one for the east region and one for the west region.

Assign Workspace1 to the east region subdomain.

Assign Workspace2 to the west region subdomain.

The solution must follow the principle of least privilege.

Which role should you assign to the user?