- All Exams Instant Download
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...
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...
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...
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...
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...
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 ....
What should you do?
Topic 1, Contoso, Ltd Case Study Overview This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time...
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 . an Apache Spark job definitionB...
How should you complete the statement?
HOTSPOT You need to troubleshoot the ad-hoc query issue. How should you complete the statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: SELECT last_run_start_time, last_run_command: These fields will help identify the execution details of the long-running...
What should you do?
You need to ensure that usage of the data in the Amazon S3 bucket meets the technical requirements. What should you do?A . Create a workspace identity and enable high concurrency for the notebooks.B . Create a shortcut and ensure that caching is disabled for the workspace.C . Create a...
