Coursera Answers

Introduction to Microsoft Azure Synapse Analytics Coursera Quiz Answers

In this article i am gone to share Introduction to Microsoft Azure Synapse Analytics Coursera Quiz Answers with you..

Enrol Link:ย  Introduction to Microsoft Azure Synapse Analytics

Introduction to Microsoft Azure Synapse Analytics Coursera Quiz Answers


 

WEEK 1 QUIZ ANSWERS

Knowledge check

Question 1)
Which one of the following Azure solutions provides an integrated analytics platform that combines data warehousing, big data analytics, data integration, and visualization into a single environment?

  • Azure Databricks
  • Azure Data Lake Storage Gen2
  • Azure Synapse Analytics
  • Azure Data Factory

Question 2)
You have unplanned or ad-hoc workloads to process within Azure Synapse Analytics. Which of the following offers is best suited to assist with this task?

  • Azure Synapse dedicated SQL pools
  • Azure Synapse Pipelines
  • Azure Synapse serverless SQL pools

Question 3)
You need to process large volumes of data for data exploration and analysis. Which resource model in Azure Synapse Analytics is best suited to help you complete this task?

  • Dedicated SQL Pools
  • Serverless SQL pools.
  • Pipelines

Question 4)
You need to train AI models using AzureML. Which one of the following components of Azure Synapse Analytics can assist you?

  • Azure Synapse Studio
  • Azure Synapse Spark
  • Azure Synapse Pipelines

Question 5)
You need to use your data to answer questions about what will happen in the future. Which one of the following forms of analytics should you deploy?

  • Diagnostic analytics
  • Predictive analytics
  • Descriptive analytics

 

Visit this link:ย  Introduction to Microsoft Azure Synapse Analytics Week 1 | Test prep Quiz Answers

 


 

WEEK 2 QUIZ ANSWERS

Knowledge check

Question 1)
An Azure Synapse Analytics workspace stores data in which of the following?

  • Apache Spark Tables
  • Azure SQL Database
  • Azure Data Lake Storage Gen2
  • Cosmos DB Tables

Question 2)
You need to create and enable SQL or Spark pools. Can you perform these tasks within the Azure Synapse Analytics workspace?

  • No
  • Yes

Question 3)
Do you need to create a Data Lake Gen2 storage account before creating an Azure Synapse Analytics workspace?

  • Yes
  • No

Question 4)
In a data warehouse data is retrieved, cleansed, and transformed from a range of source data system, and is then served in a structured relational format. What is this format commonly referred to as?

  • Dimension Table
  • Snowflake Schema
  • Star Schema
  • Fact table

Question 5)
You create a dedicated SQL pool to ensure predictable performance and cost by reserving processing power for data permanently stored in SQL tables. Which of the following services are you making use of through this process?

  • Data virtualization
  • Data warehousing

 

Knowledge check

Question 1)
You are working in Azure Synapse Analytics, and you have a requirement to ingest data from a data source in readiness to prepare the data for transformation and analysis. Which feature should you implement to enable the ingestion of the data from a data source?

  • Linked Service
  • Spark pool
  • SQL Pool
  • Datasets

Question 2)
You need to create a pipeline in Azure Synapse Studio. Which hub should you navigate to?

  • Data hub
  • Develop hub
  • Integrate hub
  • Manage hub

Question 3)
You need to access the Power BI Workspace from within Azure Synapse Studio. Which hub should you navigate to?

  • Develop Hub
  • Data Hub
  • Manage Hub
  • Integrate Hub

Question 4)
You perform analytics over a database system that is seen to provide transactional capabilities without impacting the performance of the system. What is this process referred to as?

  • Data Visualisation
  • Data Virtualisation
  • Hybrid Transactional and Analytical processing (HTAP)
  • Data Warehousing

Question 5)
You need to run near real-time analytics over operational data in Azure Cosmos DB without impacting the performance of transactional workloads on Azure Cosmos DB. Can you perform this task using Azure Synapse Link for Cosmos DB?

  • Yes
  • No

Question 6)
Which Azure Service is Azure Synapse Pipelines based on?

  • Azure Stream Analytics
  • Azure Data Factory
  • Azure Data Explorer

 

Visit this link:ย  Introduction to Microsoft Azure Synapse Analytics Week 2 | Test prep Quiz Answers

 


 

WEEK 3 QUIZ ANSWERS

Knowledge check

Question 1)
Which hub in Azure Synapse Studio is used to view the status of the various integration runtimes that are running, or Apache Spark jobs and data flow debug activities?

  • Develop Hub
  • Manage Hub
  • Monitor Hub
  • Integrate Hub

Question 2)
You are executing a notebook. Which of the following should you select as its compute target?

  • SQL Pool
  • Spark Pool
  • Serverless Pool
  • Dedicated Pool

Question 3)
Which of the following would you use to author data flows in Azure Synapse Studio Develop hub?

  • Scala
  • PySpark
  • Parquet
  • Code-free GUI

Question 4)
You are tasked with creating a Notebook. Which Azure Synapse Studio hub should you access?

  • Data hub
  • Manage hub
  • Integrate hub
  • Develop hub

Question 5)
You want to view the contents of the primary data lake store. Where can you access this content within Azure Synapse Studio?

  • In the linked tab of the Data hub.
  • In the Integration section of the Monitor hub.
  • In the workspace tab of the Data hub.

Question 6
You need to ingest data code-free within Azure Synapse Analytics. Which of the following tools can you use to perform this?

  • Azure Data Factory
  • Azure Databricks
  • Power BI

 

Visit this link:ย  Introduction to Microsoft Azure Synapse Analytics Week 3 | Test prep Quiz Answers

 


 

WEEK 4 QUIZ ANSWERS

Knowledge check

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)
Which of the following features does Power BI support? Select all options that apply.

  • Support for multiple data sources
  • Rich visualizations
  • Notebooks
  • Natural Language Query

Question 3)
Which of the following data formats are natively supported by Azure Synapse Analytics?

  • Scala
  • ORC
  • JSON
  • CSV
  • Parquet

Question 4)
Messages can be collected and processed from streaming services using which of the following features?

  • Azure IOT Central
  • Azure Databricks
  • Azure Functions
  • Azure Stream Analytics

Question 5)
Which of the following is a Big Data Solution that stores data in a relational table format with columnar storage?

  • Azure Synapse SQL pool
  • Azure Synapse Spark pools

 

Knowledge check

Question 1)
Which component enables you to perform code free transformations in Azure Synapse Analytics?

  • Synapse Mapping data flow
  • Synapse Studio
  • Synapse Copy activity

Question 2)
Which transformation in the Mapping Data Flow is used to routes data rows to different streams based on matching conditions?

  • Conditional Split
  • Lookup
  • GetMetadata activity

Question 3)
Which transformation is used to load data into a destination data store or compute resource?

  • Source
  • Sink
  • Window

Question 4)
Can the file size, number of files, and folder structure of data stored in Data Lake Storage Gen2 impact on performance?

  • Yes
  • No

Question 5)
What is the recommended file size for Data Lake Storage Gen 2?

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

Question 6)
Enabling Debug mode while building data flows in Azure Synapse turns on which of the following?

  • Spark cluster
  • Dedicated SQL Pool
  • Serverless cluster

 

Visit this link:ย  Introduction to Microsoft Azure Synapse Analytics Week 4 | Test prep Quiz Answers

 


 

WEEK 5 QUIZ ANSWERS

Visit this link: Introduction to Microsoft Azure Synapse Analytics Week 5 | Course practice exam Quiz Answers