- All Exams Instant Download
How should you complete the Apache Spark SQL code?
HOTSPOT You need to create the product dimension. How should you complete the Apache Spark SQL code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Join between Products and ProductSubCategories: - Use an INNER JOIN. - The...
What should you use?
You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse1. You plan to deploy Warehouse1 to a new workspace named Workspace2. As part of the deployment process, you need to verify whether Warehouse1 contains invalid references. The solution must minimize development effort. What should you use?A ....
What should you use to store the data?
You have a Fabric workspace. You have semi-structured data. You need to read the data by using T-SQL, KQL, and Apache Spark. The data will only be written by using Spark. What should you use to store the data?A . a lakehouseB . an eventhouseC . a datamartD . a...
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...
