How should you complete the code?
HOTSPOT You have a Fabric workspace that contains a warehouse named DW1. DW1 contains the following tables and columns. You need to create an output that presents the summarized values of all the order quantities by year and product. The results must include a summary of the order quantities at...
Which type of authentication should you use?
You have a Fabric workspace named Workspace1. You plan to integrate Workspace1 with Azure DevOps. You will use a Fabric deployment pipeline named deployPipeline1 to deploy items from Workspace1 to higher environment workspaces as part of a medallion architecture. You will run deployPipeline1 by using an API call from an...
What will be copied to OneLake?
You have a Fabric workspace that contains a Real-Time Intelligence solution and an eventhouse. Users report that from OneLake file explorer, they cannot see the data from the eventhouse. You enable OneLake availability for the eventhouse. What will be copied to OneLake?A . only data added to new databases that...
What should you recommend for each layer?
HOTSPOT You need to recommend a method to populate the POS1 data to the lakehouse medallion layers. What should you recommend for each layer? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Bronze Layer: A pipeline Copy...
The data from which shortcuts will be retrieved from the cache?
You have an Azure Data Lake Storage Gen2 account named storage1 and an Amazon S3 bucket named storage2. You have the Delta Parquet 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...
What should you use to add the eventhouse to the deployment process?
You have a Fabric deployment pipeline that uses three workspaces named Dev, Test, and Prod. You need to deploy an eventhouse as part of the deployment process. What should you use to add the eventhouse to the deployment process?A . GitHub ActionsB . a deployment pipelineC . an Azure DevOps...
What should you create?
You have a Fabric workspace named Workspace1 that contains an Apache Spark job definition named Job1. You have an Azure SQL database named Source1 that has public internet access disabled. You need to ensure that Job1 can access the data in Source1. What should you create?A . an on-premises data...
Which should you do?
Topic 2, Litware, Inc 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 warehouse object do you require to implement RLS?
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...
What should you do?
You have a Fabric workspace named Workspace1 that contains a notebook named Notebook1. In Workspace1, you create a new notebook named Notebook2. You need to ensure that you can attach Notebook2 to the same Apache Spark session as Notebook1. What should you do?A . Enable high concurrency for notebooks.B ....