You are planning an Azure IoT Hub solution that will include 50,000 IoT devices.Each device will stream data, including temperature, device ID, and time data. Approximately 50,000 records will be written every second. The data will be visualized in near real time.You need to recommend a service to store and query the data.Which two services can you recommend? Each correct answer presents a complete solution.Note: Each correct selection is worth one point.
Answer(s): C,D
D: Time Series Insights is a fully managed service for time series data. In this architecture, Time Series Insights performs the roles of stream processing, data store, and analytics and reporting. It accepts streaming data from either IoT Hub or Event Hubs and stores, processes, analyzes, and displays the data in near real time.C: The processed data is stored in an analytical data store, such as Azure Data Explorer, Hbase, Azure Cosmos DB, Azure Data Lake, or Blob Storage.
You are designing an application that will aggregate content for users.You need to recommend a database solution for the application. The solution must meet the following requirements:Support SQL commands.Support multi-master writes.Guarantee low latency read operations.What should you include in the recommendation?
Answer(s): A
With Cosmos DB’s novel multi-region (multi-master) writes replication protocol, every region supports both writes and reads. The multi-region writes capability also enables:Unlimited elastic write and read scalability.99.999% read and write availability all around the world.Guaranteed reads and writes served in less than 10 milliseconds at the 99th percentile.Note: APIs in Azure Cosmos DBAzure Cosmos DB offers multiple database APIs, which include NoSQL, MongoDB, PostgreSQL Cassandra, Gremlin, and Table. By using these APIs, you can model real world data using documents, key-value, graph, and column-family data models.
HOTSPOT (Drag and Drop is not supported)You have an Azure subscription that contains the logical SQL servers in Azure shown in the following table.The subscription contains the storage accounts shown in the following table.You create the Azure SQL databases shown in the following table.For each of the following statements, select Yes if the statement is true. Otherwise, select No.Note: Each correct selection is worth one point.Hot Area:
Box 1: YesAuditing works fine for a Standard account.Box 2: NoAuditing limitations: Premium storage is currently not supported.Box 3: NoAuditing limitations: Premium storage is currently not supported.
https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview#auditing-limitations
HOTSPOT (Drag and Drop is not supported)You have an Azure subscription that contains multiple Azure SQL databases and multiple instances of SQL Server on Azure Virtual Machines.You need to scan all the Azure SQL resources in the subscription by using Microsoft Purview. The solution must minimize administrative effort and maximize security.What should you use? To answer, select the appropriate options in the answer area.Note: Each correct selection is worth one point.Hot Area:
To scan the Azure SQL databases, use – Azure integration runtime Azure SQL databases are a fully managed service within Azure. The Azure integration runtime is natively integrated with Azure and offers the easiest and most secure way to scan Azure SQL databases. It handles the data movement and scanning within the Azure environment without the need for extra configuration or on- premises components.To scan the SQL Server on Azure Virtual Machines instances, use – Self-hosted integration runtime SQL Server on Azure Virtual Machines (VMs) requires access through the underlying infrastructure, which is not fully managed like Azure SQL Database. The self-hosted integration runtime is deployed on the virtual machine or a network that can access the VM, allowing it to scan SQL Server instances running there. It is necessary because these VMs might not be accessible directly through Azure services, and the self-hosted integration runtime can bridge that gap.
You store web access logs data in Azure Blob Storage.You plan to generate monthly reports from the access logs.You need to recommend an automated process to upload the data to Azure SQL Database every month.What should you include in the recommendation?
Answer(s): D
You can create Data Factory pipelines that copies data from Azure Blob Storage to Azure SQL Database. The configuration pattern applies to copying from a file-based data store to a relational data store.Required steps:Create a data factory.Create Azure Storage and Azure SQL Database linked services.Create Azure Blob and Azure SQL Database datasets.Create a pipeline contains a Copy activity.Start a pipeline run.Monitor the pipeline and activity runs.
Post your Comments and Discuss Microsoft AZ-305 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the AZ-305 content, but please register or login to continue.