QuestionQ1
Implement and manage an analytics solutionHOTSPOT –
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, each with 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 every item from Workspace1_DEV to Workspace1_TEST.
For each statement, select Yes if it is true. Otherwise, select No.
| Statements | Yes | No |
|---|---|---|
| Data from the semantic models will be deployed to the target stage. | ||
| The Dataflow Gen1 dataflows will be deployed to the target stage. | ||
| The scheduled refresh policies will be deployed to the target stage. |
QuestionQ2
Ingest and transform dataYou have an Azure SQL database named DB1.
In a Fabric workspace, you deploy an eventstream named EventStreamDB1 to stream record changes from DB1 to a lakehouse.
You discover that events are not being propagated to EventStreamDB1.
You need to ensure that events are propagated to EventStreamDB1.
What should you do?
- A Create a read-only replica of DB1.
- B Create an Azure Stream Analytics job.
- C Enable Extended Events for DB1.
- D Enable change data capture (CDC) for DB1.
Community Discussion
QuestionQ3
Ingest and transform dataYou have a Fabric workspace containing a lakehouse named Lakehouse1.
An external data source contains data files that are 500 GB each, and a new file is added every day.
You need to ingest the data into Lakehouse1 without applying transformations. The solution must meet these requirements:
- Trigger the process when a new file is added.
- Provide the highest throughput.
Which type of item should you use to ingest the data?
- A Data pipeline
- B Environment
- C KQL queryset
- D Dataflow Gen2
Community Discussion
QuestionQ4
Ingest and transform dataYou have an Azure subscription that contains a blob storage account named sa1. sa1 contains two files named File1.csv 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 File1.csv and load the file into flh1.
• At 5 PM each day, process File2.csv and load the file into flh1.
The solution must minimize development effort.
What should you use?
- A a data pipeline trigger
- B a data pipeline schedule
- C a job definition
- D an activator
Community Discussion
QuestionQ5
Implement and manage an analytics solutionYou have a Fabric workspace containing a warehouse named Warehouse1. Warehouse1 has a table named Customer, which contains the following data.
You have an internal Microsoft Entra user named User1 whose email address is [email protected].
You need to grant User1 access to the Customer table while preventing access to the CreditCard column.
How should you complete the statement?
GRANT ON Customers(CustomerID, FirstName, LastName, Phone) TO
Community Discussion