Question 1
You have an Azure subscription that contains a blob storage account named sa1. Sa1 contains two files named Filelxsv and File2.csv.
You have a Fabric tenant that contains the items shown in the following table.
You need to configure Pipeline1 to perform the following actions:
* At 2 PM each day, process Filel.csv and load the file into flhl.
* At 5 PM each day. process File2.csv and load the file into flhl.
The solution must minimize development effort. What should you use?
Question 2
You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Table 1. You need to ensure that a user named User 1 can view only specific rows in Table1. What should you do first?
Question 3
You have a Fabric workspace that contains a warehouse named Warehouse1 Warehousel contains a table named DimCustomers. DimCustomers contains the following columns:
* CustomerName
* CustomerlD
* Birth Date
* Email
You need to configure security to meet the following requirements:
* Birth Date in DimCustomer must be masked and display 1960-01-01
* Email in DimCustomer must be masked and display only the first leading character and the last five characters.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 4
HOTSPOT
You have a Fabric workspace that contains two lakehouses named Lakehouse1 and Lakehouse2. Lakehouse1 contains staging data in a Delta table named Orderlines. Lakehouse2 contains a Type 2 slowly changing dimension (SCD) dimension table named Dim_Customer.
You need to build a query that will combine data from Orderlines and Dim_Customer to create a new fact table named Fact_Orders. The new table must meet the following requirements:
Enable the analysis of customer orders based on historical attributes.
Enable the analysis of customer orders based on the current attributes.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 5
You have Fabric workspace that contains eventhouse named Eventhouse1.
In Eventhouse1, you plan to create a table named EventStreamData in a KQL database. The table will contain data based on the following sample.







