exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 115 discussion

Actual exam question from Microsoft's AZ-305
Question #: 115
Topic #: 4
[All AZ-305 Questions]

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1 and an Azure Synapse Analytics workspace named Workspace1. The account1 account contains a container named Contained that has the analytical store enabled.

You need to recommend a solution that will process the data stored in Contained in near-real-time (NRT) and output the results to a data warehouse in Workspace1 by using a runtime engine in the workspace. The solution must minimize data movement.

Which pool in Workspace1 should you use?

  • A. Apache Spark
  • B. serverless SQL
  • C. dedicated SQL
  • D. Data Explorer
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
SeMo0o0o0o
2 weeks, 6 days ago
Selected Answer: A
A is correct
upvoted 2 times
...
KarimaMaf
3 months, 1 week ago
who wants to use Synapse Spark to find a feature to improve their model and train that model without doing complex data engineering. They can also write the results of the model post inference into Azure Cosmos DB for real-time scoring on the data through Spark Synapse. https://learn.microsoft.com/en-us/azure/cosmos-db/synapse-link
upvoted 1 times
KarimaMaf
3 months, 1 week ago
it's A
upvoted 1 times
...
...
moadabdou
4 months, 3 weeks ago
Selected Answer: A
For processing data stored in the 'Contained' container of Cosmos DB in near-real-time (NRT) and outputting results to a data warehouse in Workspace1, leveraging an Apache Spark pool within Azure Synapse Analytics is highly recommended. This approach is particularly effective due to Apache Spark's robust in-memory processing capabilities, which can handle large volumes of data swiftly. Additionally, by utilizing Azure Synapse Link for seamless integration with Cosmos DB's analytical store, this solution ensures minimal data movement. This not only enhances performance by enabling direct real-time data access but also optimizes resource utilization and reduces latency, making it an ideal setup for real-time data analytics.
upvoted 1 times
...
23169fd
5 months, 1 week ago
Selected Answer: A
Apache Spark: Spark pools in Azure Synapse Analytics provide a distributed data processing framework capable of processing large volumes of data in near-real-time. Spark is highly efficient in handling streaming data and can directly read from Azure Cosmos DB's analytical store with minimal data movement, making it an ideal choice for near-real-time processing. Serverless SQL and Dedicated SQL: While these can be used for querying and processing data, they are not as optimized for near-real-time processing as Apache Spark. Additionally, they typically involve more data movement compared to Spark's direct processing capabilities. Data Explorer: This is typically used for fast ad-hoc data exploration and querying, particularly for log and telemetry data, rather than for continuous near-real-time data processing and transformation.
upvoted 4 times
...
TarasSheva
6 months, 3 weeks ago
Selected Answer: A
A. Apache Spark Near-Real-Time (NRT) Processing: Apache Spark provides capabilities for real-time stream processing, which aligns with the requirement for near-real-time processing. Integration with Azure Cosmos DB: Apache Spark has built-in connectors and libraries for integrating with Azure Cosmos DB, allowing for seamless data ingestion and processing without significant data movement. Output to Data Warehouse: Apache Spark can easily output processed data to various destinations, including data warehouses like Azure Synapse Analytics. It can write directly into dedicated SQL pools or serverless SQL pools within the Synapse workspace. Minimizing Data Movement: Since Apache Spark can directly access data in Azure Cosmos DB and write results to the data warehouse within the same Azure environment, it minimizes data movement, thus optimizing performance and reducing costs.
upvoted 4 times
...
varinder82
8 months ago
Final Answer : D
upvoted 1 times
...
LGWJ12
8 months ago
Selected Answer: A
A: Apache Spark,it's in Azure Synapse Analytics is an analytics engine that facilitates large-scale data processing. It can read data from Cosmos DB in near-real-time, process it, and then output the results to a data warehouse in the same Azure Synapse Analytics workspace. This minimizes data movement as the data processing and storage are happening within the same service (Azure Synapse Analytics).
upvoted 2 times
...
masetromain
8 months, 1 week ago
Selected Answer: A
Apache Spark is a distributed processing framework that can handle near-real-time processing and is well-integrated with Azure Synapse Analytics. It can directly access data stored in Azure Cosmos DB analytical store without needing to move the data around. This minimizes data movement and provides efficient processing capabilities. So, the correct answer is: A. Apache Spark
upvoted 4 times
...
azureworm
8 months, 2 weeks ago
A is the correct answer https://learn.microsoft.com/en-us/azure/cosmos-db/synapse-link-use-cases
upvoted 3 times
...
MohsenSic
8 months, 2 weeks ago
I go with A: Two reasons: Synapse had Apache Spark, Dat explore is mainly for logs, refer to the bottom flowchart of the below link https://learn.microsoft.com/en-us/azure/data-explorer/data-explorer-overview
upvoted 3 times
...
varinder82
8 months, 3 weeks ago
Final Answer : D
upvoted 1 times
...
Frank_2022
8 months, 3 weeks ago
Selected Answer: C
Dedicated SQL pools are specifically designed for low-latency analytical workloads, making them ideal for processing data in near-real-time.
upvoted 1 times
...
rumino
9 months ago
Selected Answer: D
Azure Data Explorer is a fully managed, high-performance, big data analytics platform that makes it easy to analyze high volumes of data in near real time. The Azure Data Explorer toolbox gives you an end-to-end solution for data ingestion, query, visualization, and management. https://learn.microsoft.com/en-us/azure/data-explorer/data-explorer-overview https://learn.microsoft.com/en-us/azure/synapse-analytics/data-explorer/data-explorer-overview
upvoted 1 times
Frank_2022
8 months, 4 weeks ago
Data Explorer is a powerful tool for querying data in Synapse Workspace, it's not designed for real-time data processing. I believe.
upvoted 1 times
Felas
8 months, 2 weeks ago
Azure Data Explorer is a fast, fully managed data analytics service for analyzing large volumes of streaming data from applications, websites, IoT devices, etc. in real time. https://azure.microsoft.com/es-es/products/data-explorer
upvoted 1 times
...
...
...
Frank_2022
9 months ago
I recommend using a dedicated SQL pool Near-real-time processing: Dedicated SQL pools are specifically designed for low-latency analytical workloads, making them ideal for processing data in near-real-time. Data minimization: Dedicated SQL pools are integrated with Workspace1, allowing for seamless data movement between the Cosmos DB analytical store and the data warehouse within the same workspace. This minimizes data movement and avoids the need for external data transfer processes. Runtime engine: Dedicated SQL pools provide a T-SQL compatible query engine that can be used to interact with data stored in the data warehouse. This allows you to leverage familiar SQL syntax for data transformation and analysis.
upvoted 1 times
...
Appon
9 months, 2 weeks ago
Selected Answer: D
because of "near-real-time"
upvoted 2 times
...
KeyMan
11 months ago
B. Serverless SQL pool Reasoning: Serverless SQL pool in Azure Synapse Analytics is designed to handle on-demand queries against large datasets, which is suitable for the NRT processing requirement stated. Minimal Data Movement: Using serverless SQL pool allows querying data in place without the need to move data into the pool, which aligns with the need to minimize data movement. It can directly query the Cosmos DB analytical store. Integration with Cosmos DB Analytical Store: Serverless SQL pool has built-in integration with Azure Cosmos DB's analytical store, allowing efficient and performant processing of the data. Apache Spark could also process the data, but it would involve more data movement compared to serverless SQL. Dedicated SQL pool requires pre-provisioned resources and wouldn't be as cost-effective for NRT scenarios. Data Explorer is not a compute pool within Azure Synapse Analytics.
upvoted 4 times
deegadaze1
10 months, 3 weeks ago
NO! When to use Azure Synapse Data Explorer? Use Data Explorer as a data platform for building near real-time log analytics and IoT analytics solutions to: Consolidate and correlate your logs and events data across on-premises, cloud, and third-party data sources. Accelerate your AI Ops journey (pattern recognition, anomaly detection, forecasting, and more). Replace infrastructure-based log search solutions to save cost and increase productivity. Build IoT analytics solutions for your IoT data. Build analytics SaaS solutions to offer services to your internal and external customers. Azure Data Explorer is a fully managed, high-performance, big data analytics platform that makes it easy to analyze high volumes of data in near real time. The Azure Data Explorer toolbox gives you an end-to-end solution for data ingestion, query, visualization, and management.
upvoted 7 times
deegadaze1
10 months, 3 weeks ago
https://learn.microsoft.com/en-us/azure/data-explorer/data-explorer-overview https://learn.microsoft.com/en-us/azure/synapse-analytics/data-explorer/data-explorer-overview
upvoted 6 times
...
...
Fidel_104
9 months ago
Further supporting B - serverless SQL pool, the Azure Synapse Link guide for Cosmos DB also recommends serverless pools for the real-time operational reporting use-cases: Source: https://learn.microsoft.com/en-us/azure/cosmos-db/synapse-link-use-cases
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago