In this article i am gone to share Introduction to Microsoft Azure Synapse Analytics Week 4 | Test prep Quiz Answers with you..

Enrol Link: Introduction to Microsoft Azure Synapse Analytics

Introduction to Microsoft Azure Synapse Analytics Week 4 | Test prep Quiz Answers

Test prep Quiz Answers

Question 1)
You have recently deployed Azure Synapse Analytics and need to ingest data code-free. Which of the following tools can be used to perform this task?

• Azure Data Factory
• Power BI
• Azure Databricks

Question 2)
Identify three reasons as to why you might need to add a staging area into the architecture of a modern data warehouse.

• To reduce contention on source systems.
• To join data from different source systems.
• Enable the ingestion of source systems based on different schedules.
• To make data analytical available directly from the staging area.

Question 3)
You are implementing a modern data warehouse which requires a staging area. Which one of the following technologies would be most suited to creating this staging area?

• Azure Synapse SQL Pools
• Azure Data Lake
• Azure Synapse Spark Pools.

Question 4)
You are creating a new Mapping Data Flow transformation and need to route data rows to different streams based on matching conditions. Which one of the following data flow activities will give you the ability to route data to multiple streams?

• GetMetadata activity
• Lookup
• Conditional Split

Question 5)
You are working with Data Lake Storage Generation 2 and need to ensure that its performance is not negatively affected by your data’s file size. What is the recommended file size that you should store your data in?

• 1GB to 10GB
• 256MB to 1GB
• 256MB to 100GB
• 10GB to 100GB

Question 6)
You enable Debug mode while building Data Flows in Azure Synapse Analytics. Which one of the following features does this automatically create?

• A small Spark cluster.
• A serverless cluster.
• A dedicated SQL Pool.