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

Enrol Link: Introduction to Microsoft Azure Synapse Analytics

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

Test prep Quiz Answers

Question 1)
Which three of the following Azure Data Lake file types can be explored and analyzed directly with Synapse Analytics SQL and Spark?

• JSON
• CSV
• Parquet
• XML

Question 2)
You are creating a new Azure Data Lake Storage Generation 2 workspace. In which instance do you need to ensure that the name of the workspace is unique?

• Within the selected Resource Group only.
• Globally within Microsoft Azure.
• Within the selected Subscription only.

Question 3)
A data warehouse provides which one of the following features?

• A central repository of data stored in relational tables.
• A repository of data distributed across multiple instances of Azure SQL.
• A central repository of data stored in a nonrelational database.

Question 4)
The ability to interact with data without the need to understand its type, format, or structure is referred to as…

• Data Virtualization
• Data Visualization
• Data Ingestion
• Data Warehousing

Question 5)
What method can you use to populate permanent tables with data in a data warehouse?

• Extract, Load and Transform (ELT)
• Extract, Transform and Load (ETL)

Question 6)
Which of these actions does a driver node perform when working with Spark pool clusters?

• The Driver node sends work to the Worker nodes and instructs them to pull data from a specified data source.
• The Driver node pulls data from a specified data source and sends the work to the Worker nodes.

Question 7)
Which three of the following features in Azure Synapse Analytics can you use to create a new Spark pool?

• JSON
• Azure Portal
• Azure PowerShell
• Synapse Analytics .Net SDK

Question 8)
Which one of the following components of Azure Synapse Analytics can the different engines use to share the databases and tables between Spark pools and SQL on-demand engine?

• Azure Synapse Spark pools
• Azure Synapse shared metadata
• Azure Synapse Link

Question 9)
Which one of the following Azure Synapse Analytics components can you use to perform Hybrid Transaction and Analytical processing?

• Azure Synapse Pipeline
• Azure Synapse Studio
• Azure Synapse Link

Question 10)
Where in Azure Synapse Analytics can you develop TSQL scripts and notebooks?

• Azure Data Lake
• Azure Synapse Studio
• Azure portal