CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. AZ-305

Free AZ-305 Exam Braindumps (page: 23)

Page 22 of 67
PDF with 319 Questions

You are designing a SQL database solution. The solution will include 20 databases that will be 20 GB each and have varying usage patterns.
You need to recommend a database platform to host the databases. The solution must meet the following requirements:
-The solution must meet a Service Level Agreement (SLA) of 99.99% uptime.
-The compute resources allocated to the databases must scale dynamically.
-The solution must have reserved capacity.
-Compute charges must be minimizeD.

What should you include in the recommendation?

  1. an elastic pool that contains 20 Azure SQL databases
  2. 20 databases on a Microsoft SQL server that runs on an Azure virtual machine in an availability set
  3. 20 databases on a Microsoft SQL server that runs on an Azure virtual machine
  4. 20 instances of Azure SQL Database serverless

Answer(s): A

Explanation:

The compute and storage redundancy is built in for business critical databases and elastic pools, with a SLA of 99.99%.
Reserved capacity provides you with the flexibility to temporarily move your hot databases in and out of elastic pools (within the same region and performance tier) as part of your normal operations without losing the reserved capacity benefit.


Reference:

https://azure.microsoft.com/en-us/blog/understanding-and-leveraging-azure-sql-database-sla/



HOTSPOT (Drag and Drop is not supported)
You have an on-premises database that you plan to migrate to Azure.
You need to design the database architecture to meet the following requirements:
-Support scaling up and down.
-Support geo-redundant backups.
-Support a database of up to 75 TB.
-Be optimized for online transaction processing (OLTP).

What should you include in the design? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Azure SQL Database
Azure SQL Database:
Database size always depends on the underlying service tiers (e.g. Basic, Business Critical, Hyperscale). It supports databases of up to 100 TB with Hyperscale service tier model.
Active geo-replication is a feature that lets you to create a continuously synchronized readable secondary database for a primary database. The readable secondary database may be in the same Azure region as the primary, or, more commonly, in a different region. This kind of readable secondary databases are also known as geo-secondaries, or geo-replicas.
Azure SQL Database and SQL Managed Instance enable you to dynamically add more resources to your database with minimal downtime.
Box 2: Hyperscale

Incorrect Answers:
SQL Server on Azure VM: geo-replication not supported.
Azure Synapse Analytics is not optimized for online transaction processing (OLTP).
Azure SQL Managed Instance max database size is up to currently available instance size (depending on the number of vCores).

Max instance storage size (reserved)
- 2 TB for 4 vCores
-8 TB for 8 vCores
-16 TB for other sizes


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview https://medium.com/awesome-azure/azure-difference-between-azure-sql-database-and-sql-server-on- vmcomparison-azure-sql-vs-sql-server-vm-cf02578a1188



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.

  1. Azure Table Storage
  2. Azure Event Grid
  3. Azure Cosmos DB SQL API
  4. Azure Time Series Insights

Answer(s): C,D

Explanation:

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.


Reference:

https://docs.microsoft.com/en-us/azure/architecture/data-guide/scenarios/time-series



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?

  1. Azure Cosmos DB SQL API
  2. Azure SQL Database that uses active geo-replication
  3. Azure SQL Database Hyperscale
  4. Azure Database for PostgreSQL

Answer(s): A

Explanation:

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.


Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/distribute-data-globally






Post your Comments and Discuss Microsoft AZ-305 exam with other Community members:

AZ-305 Discussions & Posts