In this article i am gone to share Coursera Course: Operational Analytics with Microsoft Azure Synapse Analytics Week 4 | Course practice exam Quiz Answers with you..

Enrol Link: Operational Analytics with Microsoft Azure Synapse Analytics

Operational Analytics with Microsoft Azure Synapse Analytics Week 4 | Course practice exam Quiz Answers

Course practice exam Quiz Answers

Question 1)
HTAP (Hybrid Transactional/Analytical processing) enables business to run advanced analytics in near-real-time on data stored and processed in which of the following?

• OLTP
• OLAP
• ELT
• ETL

Question 2)
Which of the following are common use cases for using Azure Synapse Link for Azure Cosmos DB? Choose all that apply.

• Supply chain analytics, forecasting and reporting
• Real-time personalization
• IOT predictive maintenance
• Integration with API’s such as Gremlin API, Cassandra API, and Table API

Question 3)
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
• Dedicated SQL Pool
• Serverless SQL pool

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?

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

Question 5)
How can you manage the lifecycle of data and define how long it will be retained for in an analytical store?

• Configure the purge duration in a container
• Configure the deletion duration for records in the transactional store.
• Configure the default Time to Live (TTL) property for records stored.

Question 6)
To enable Synapse Link on Azure Cosmos DB SQL (Core) API account you carry out which of the following series of steps?

• Navigate to your Azure Cosmos DB SQL (Core) API account – Select Features in the left-hand menu – click on the Azure Synapse Link entry in the features table – click the Enable button on the dialog box on the right
• Navigate to your Azure Cosmos DB SQL (Core) API account – Select Data Explorer – click Enable Azure Synapse Link on the pop-up dialog box

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

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

Question 8)
While interacting with Azure Cosmos DB using Apache Spark in Azure Synapse Link which of the following capabilities are supported? Choose all that apply.

• Analyse data in Azure Cosmos DB containers that are enabled with Azure Synapse Link in near real-time without impacting the performance of the transactional workloads
• Load to a Spark DataFrame
• The first 1500 properties from the transactional schema are available in the analytical schema
• Create a Spark table

Question 9)
When you want to switch to SparkSQL in a notebook, what is the first command to type?

• %%sparksql
• %%sql
• %%spark

Question 10)
By default, the OPENJSON table-valued function returns three columns. These are?

• Key
• Value
• Name
• Schema Name
• Type