In this article i am gone to share Operational Analytics with Microsoft Azure Synapse Analytics All Weeks Quiz Answers with you..

Enrol Link:  Operational Analytics with Microsoft Azure Synapse Analytics

Operational Analytics with Microsoft Azure Synapse Analytics Coursera Quiz Answers

 

---

 

WEEK 1 QUIZ ANSWERS

Knowledge check

Question 1)
Azure Synapse Link for Azure Cosmos DB provides the capability that enables you to run near real-time analytics over operational data stored in Azure Cosmos DB. This capability is referred to as cloud-native:

• OLTP
• HTAP
• OLAP

Question 2)
True or false?
Azure Cosmos DB provides a transactional store and an analytical store with a fully managed autosync process that keeps the data within these stores in sync.

• True
• False

Question 3)
The benefits of enabling the analytical store on an Azure Cosmos DB container include which of the following? Select all options that apply.

• Run near real-time analytics with no-ETL required
• All transactional data is automatically stored in a fully isolated Table store
• All transactional data is automatically stored in a fully isolated Column store
• Provides full performance isolation from transactional workloads.

Question 4)
When using Azure Cosmos DB analytical store, the autosync process transparently maintains the schema in the analytical store based on items added or updated in the transactional store. There are two modes of schema representation for data stored in the analytical store.
Which of the following schema representations creates a simple tabular representation of the schema-agnostic data in the transactional store as it copies it to the analytical store?

• Well-defined schema representation
• Full fidelity schema representation
• Best effort schema representation

Question 5)
Within Azure Synapse Link for Azure Cosmos DB, which of the following is a Column-oriented store optimized for analytical queries?

• Cosmos DB store
• Analytical store
• Transactional store

 

 

---

 

WEEK 2 QUIZ ANSWERS

Knowledge check

Question 1)
Synapse Link is not enabled by default. When will Synapse Link begin to incur billing charges once it has been enabled?

• As soon as the Analytical store is enabled
• As soon as containers are created
• As soon as the Analytical store is enabled, and containers are created
• As soon as Synapse Link is initially enabled

Question 2)
To verify that the Azure Synapse Link feature is enabled on an Azure Cosmos DB SQL (Core) API account, which of the following steps would you complete?

• Navigate to the Azure Cosmos DB SQL (Core) API account – > Select Connection string – > select Features – > Verify the Synapse Link feature shows a Status of on
• Navigate to the Azure Cosmos DB SQL (Core) API account -> select Features – > Verify the Synapse Link feature shows a Status of ON
• Navigate to the Azure Cosmos DB SQL (Core) API account – > Select Data Explorer – > select Features – Verify the Synapse Link feature shows a Status of onON

Question 3)
In Azure Cosmos DB enabling an analytical store is available only at the time of creating a container. How can you effectively disable an analytical store? Choose all that apply.

• Delete the container
• Set the default TTL to 0 (Null)
• From within the API disable the analytical store feature

Question 4)
From where do you enable Azure Synapse Link for Azure Cosmos DB?

• In Azure Cosmos DB
• In Azure Synapse Link
• Azure Synapse Analytics

Question 5)
With Synapse Link, you can directly connect to your Azure Cosmos DB containers from Azure Synapse Analytics. Azure Synapse Analytics currently supports Synapse Link with which of the following Choose all that apply

• Synapse Apache Spark
• Serverless SQL pool
• Dedicated SQL Pool

 

Visit this link:  Operational Analytics with Microsoft Azure Synapse Analytics Week 2 | Test prep Quiz Answers

 

---

 

WEEK 3 QUIZ ANSWERS

Knowledge check

Question 1)
By default, the OPENJSON table-valued function returns three columns. These are? Select all that apply.

• Type
• Key
• Value
• Schema Name
• Name

Question 2)
By default, the OPENJSON table-valued function returns three columns. As an alternative, you can explicitly specify the schema of the result set that OPENJSON returns by providing which of the following clauses? Select all that apply.

• Insert
• Include
• With
• Explicit

Question 3)
Once Azure Synapse Link is configured on Cosmos DB, what is the first step to perform to use Azure Synapse Analytics serverless SQL pools to query the Azure Cosmos DB data?

• Use the OPENROWSET function
• Create a database
• Use a SELECT clause.

Question 4)
What function provides a rowset view over a JSON document?

• OPENJSON
• WITH
• OPENROWSET

 

Visit this link:  Operational Analytics with Microsoft Azure Synapse Analytics Week 3 | Test prep Quiz Answers

 

---

 

WEEK 4 QUIZ ANSWERS

 

Visit this link:  Operational Analytics with Microsoft Azure Synapse Analytics Week 4 | Course practice exam Quiz Answers