Question 26
You have a Fabric tenant.
You are creating a Fabric Data Factory pipeline.
You have a stored procedure that returns the number of active customers and their average sales for the current month.
You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline.
Which type of activity should you add?
You are creating a Fabric Data Factory pipeline.
You have a stored procedure that returns the number of active customers and their average sales for the current month.
You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline.
Which type of activity should you add?
Question 27
In your data cleansing project, you need to identify and remove duplicate entries from a dataset using the Aggregate transformation. Which function should you use within the Aggregate transformation to aid in identifying duplicate entries?
Question 28
You need to design a semantic model for the customer satisfaction report.
Which data source authentication method and mode should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Which data source authentication method and mode should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 29
You have a Fabric workspace named Workspace1 that is assigned to a newly created Fabric capacity named Capacity1.
You create a semantic model named Model1 and deploy Model1 to Workspace1.
You need to publish changes to Model1 directly from Tabular Editor.
What should you do?
You create a semantic model named Model1 and deploy Model1 to Workspace1.
You need to publish changes to Model1 directly from Tabular Editor.
What should you do?
Question 30
Hotspot Question
You have a Fabric workspace that contains a large warehouse.
You plan to create a lakehouse named Lakehouse1 for a sales dataset. Lakehouse1 will contain the following tables:
- Sales: Contains sales transactions
- Stores: Contains a unique list of store names and locations
- Loyalty: Contains a list of customers and their preferred stores
- Customers: Contains a unique list of customer names and addresses
- Products: Contains a unique list of available products and their
descriptions
You need to configure a star schema for Lakehouse1.
Which table should you define as the fact table, and which type of relationship should you configure from the Sales table to the Customers table? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a Fabric workspace that contains a large warehouse.
You plan to create a lakehouse named Lakehouse1 for a sales dataset. Lakehouse1 will contain the following tables:
- Sales: Contains sales transactions
- Stores: Contains a unique list of store names and locations
- Loyalty: Contains a list of customers and their preferred stores
- Customers: Contains a unique list of customer names and addresses
- Products: Contains a unique list of available products and their
descriptions
You need to configure a star schema for Lakehouse1.
Which table should you define as the fact table, and which type of relationship should you configure from the Sales table to the Customers table? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
