You need to develop an orchestration solution in fabric that will load each item one after the other. The solution must be scheduled to run every 15 minutes. Which type of item should you use?
You have a Fabric lakehouse that contains the resources shown in the following table.
You need to use a notebook to query for customers in the United States and load the filtered data into USCustomers. The solution must minimize the number of scripts used.
Which statement should you use?
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 implement RLS?
You have a Fabric workspace named Workspace1. Your company acquires GitHub licenses.
You need to configure source control for Workpace1 to use GitHub. The solution must follow the principle of least privilege. Which permissions do you require to ensure that you can commit code to GitHub?
You have an Azure SQL database named DB1.
In a Fabric workspace, you deploy an eventstream named EventStreamDBI to stream record changes from DB1 into a lakehouse.
You discover that events are NOT being propagated to EventStreamDBI.
You need to ensure that the events are propagated to EventStreamDBI.
What should you do?
You have a Fabric warehouse named Warehouse1 that contains a table named Table1. Table1 contains the following columns that store string values:
FirstName
Phone
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:
. The members of Group1 must see masked values for Phone, showing only the last three characters of each phone number.
. The Group1 members must see unmasked values for FirstName.
. The members of Group2 must see unmasked values for all the columns.
. The solution must use Fabric warehouse-supported permissions and T-SQL.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a Fabric workspace named WS1 that is connected to the main branch of an Azure DevOps Git repository. WS1 contains a lakehouse a notebook and a pipeline.
Two data engineer must update the notebook and people concurrently for separate features.
You need to configure version control to support isolated feature development and controlled integration into the main branch.
The solution must meet the following requirements:
Prevent one engineer’s reviewed workspace changes from affecting the other engineer workspace.
Support a review before changes are integrated into the main branch.
Track changes to the Fabric items in Git.
How should you configure the development workflow? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a Fabric capacity that contains a workspace named Workspace1. Workspace1 contains a lakehouse named Lakehouse1, a data pipeline, a notebook, and several Microsoft Power BI reports.
A user named User1 wants to use SQL to analyze the data in Lakehouse1.
You need to configure access for User1. The solution must meet the following requirements:
Provide User1 with read access to the table data in Lakehouse1.
Prevent User1 from using Apache Spark to query the underlying files in Lakehouse1.
Prevent User1 from accessing other items in Workspace1.
What should you do?
