Which warehouse object do you require to implement RLS?

You have a Fabric warehouse named DW1. DW1 contains a table that stores sales data and is used by multiple sales representatives. You plan to implement row-level security (RLS). You need to ensure that the sales representatives can see only their respective data. Which warehouse object do you require to...

March 24, 2025 No Comments READ MORE +

What should you do?

You have a Fabric workspace named Workspace1 that contains a notebook named Notebook1. In Workspace1, you create a new notebook named Notebook2. You need to ensure that you can attach Notebook2 to the same Apache Spark session as Notebook1. What should you do?A . Enable high concurrency for notebooks.B ....

March 19, 2025 No Comments READ MORE +

You create a deployment pipeline named Pipeline1 to move items from Workspace1_DEV to a new workspace named Workspace1_TEST

HOTSPOT You have a Fabric workspace named Workspace1_DEV that contains the following items: - 10 reports - 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...

March 3, 2025 No Comments READ MORE +

What should you do?

You need to resolve the sales data issue. The solution must minimize the amount of data transferred. What should you do?A . Spilt the dataflow into two dataflows.B . Configure scheduled refresh for the dataflow.C . Configure incremental refresh for the dataflow. Set Store rows from the past to 1...

February 26, 2025 No Comments READ MORE +

Which shortcuts will retrieve data from the cache?

You have a Google Cloud Storage (GCS) container named storage1 that contains the files shown in the following table. 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...

February 25, 2025 No Comments READ MORE +

Which should you do?

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

February 23, 2025 No Comments READ MORE +

Which two types of activities should you include in the pipeline?

You need to populate the MAR1 data in the bronze layer. Which two types of activities should you include in the pipeline? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . ForEachB . Copy dataC . WebHookD . Stored procedureView AnswerAnswer: AB...

February 19, 2025 No Comments READ MORE +

Which three columns should you include in the DimProduct table?

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Data is ingested into Lakehouse1 as one flat table. The table contains the following columns. You plan to load the data into a dimensional model and implement a star schema. From the original flat table, you create two tables...

February 19, 2025 No Comments READ MORE +

Which three actions should you perform?

You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables: - 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...

February 13, 2025 No Comments READ MORE +

Which item should you use?

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 dataflowB ....

February 9, 2025 No Comments READ MORE +