Microsoft AZ-305 Relational Database Design Practice Test

 

Topic 08 focuses on Relational Database Service Selection for the Microsoft Certified: Azure Solutions Architect Expert certification and the AZ-305 exam, using Microsoft Azure solution-architecture scenarios. For broader exam preparation, review the Microsoft Azure Solutions Architect Expert AZ-305 Exam Dumps page. Each question includes a concise explanation of the correct answer and the technical reason the other choices are incorrect.

Question 1

When considering Azure SQL Database serverless compute tier, which requirement supports that choice?

1. To support very large SQL databases that need rapid scaling and high storage capacity.
2. To optimize cost for intermittent single-database workloads.
3. To support general relational workloads without premium low-latency storage requirements.
4. To run cloud-native SQL workloads with minimal infrastructure administration.

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure SQL Database serverless compute tier automatically scales compute within configured limits and can pause during periods of inactivity for supported workloads.

Incorrect Answers

Answer A is incorrect because that outcome is more directly associated with Azure SQL Database Hyperscale, not Azure SQL Database serverless compute tier.

Answer C is incorrect because that outcome is more directly associated with Azure SQL Database General Purpose tier, not Azure SQL Database serverless compute tier.

Answer D is incorrect because that outcome is more directly associated with Azure SQL Database, not Azure SQL Database serverless compute tier.

 

Question 2

For SQL Server on Azure Virtual Machines, which statement is accurate?

1. Runs full SQL Server on IaaS virtual machines and provides operating system and SQL instance control.
2. Provides managed PostgreSQL with configurable compute, storage, backup, networking, and high availability.
3. Shares a pool of compute resources among multiple Azure SQL databases with variable and unpredictable usage.
4. Provides a cloud-native architecture for very large Azure SQL databases with independently scalable compute and storage characteristics.

Correct Answer: A

 

Correct Answer

Answer A is correct because SQL Server on Azure Virtual Machines runs full SQL Server on IaaS virtual machines and provides operating system and SQL instance control.

Incorrect Answers

Answer B is incorrect because that description belongs to Azure Database for PostgreSQL Flexible Server, whose purpose is to host PostgreSQL applications on a managed Azure database service.

Answer C is incorrect because that description belongs to Azure SQL elastic pool, whose purpose is to reduce cost for many databases whose utilization peaks at different times.

Answer D is incorrect because that description belongs to Azure SQL Database Hyperscale, whose purpose is to support very large SQL databases that need rapid scaling and high storage capacity.

 

Question 3

A platform architect needs to support SQL workloads that require full instance, operating system, or legacy feature control. Which Azure service or capability is the best fit?

1. Azure Database for PostgreSQL Flexible Server
2. Azure SQL elastic pool
3. Azure SQL Database Hyperscale
4. SQL Server on Azure Virtual Machines

Correct Answer: D

 

Correct Answer

Answer D is correct because SQL Server on Azure Virtual Machines runs full SQL Server on IaaS virtual machines and provides operating system and SQL instance control. It directly meets the requirement to support SQL workloads that require full instance, operating system, or legacy feature control.

Incorrect Answers

Answer A is incorrect because Azure Database for PostgreSQL Flexible Server is used to host PostgreSQL applications on a managed Azure database service; that does not directly satisfy the requirement in this scenario.

Answer B is incorrect because Azure SQL elastic pool is used to reduce cost for many databases whose utilization peaks at different times; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Azure SQL Database Hyperscale is used to support very large SQL databases that need rapid scaling and high storage capacity; that does not directly satisfy the requirement in this scenario.

 

Question 4

To support latency-sensitive transactional SQL workloads, which Azure design option should be selected?

1. Azure SQL Database General Purpose tier
2. SQL Server on Azure Virtual Machines
3. Azure SQL Database
4. Azure SQL Database Business Critical tier

Correct Answer: D

 

Correct Answer

Answer D is correct because Azure SQL Database Business Critical tier uses multiple replicas and local SSD-based storage for low latency, high IOPS, and built-in high availability. It directly meets the requirement to support latency-sensitive transactional SQL workloads.

Incorrect Answers

Answer A is incorrect because Azure SQL Database General Purpose tier is used to support general relational workloads without premium low-latency storage requirements; that does not directly satisfy the requirement in this scenario.

Answer B is incorrect because SQL Server on Azure Virtual Machines is used to support SQL workloads that require full instance, operating system, or legacy feature control; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Azure SQL Database is used to run cloud-native SQL workloads with minimal infrastructure administration; that does not directly satisfy the requirement in this scenario.

 

Question 5

To optimize cost for intermittent single-database workloads, which Azure design option should be selected?

1. Azure SQL Database General Purpose tier
2. Azure SQL Database
3. Azure SQL Database serverless compute tier
4. Azure SQL Database Hyperscale

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure SQL Database serverless compute tier is designed to optimize cost for intermittent single-database workloads. Azure SQL Database serverless compute tier automatically scales compute within configured limits and can pause during periods of inactivity for supported workloads.

Incorrect Answers

Answer A is incorrect because Azure SQL Database General Purpose tier can be useful in Azure architectures, but its primary role is to support general relational workloads without premium low-latency storage requirements; it is not the best match for the stated priority.

Answer B is incorrect because Azure SQL Database can be useful in Azure architectures, but its primary role is to run cloud-native SQL workloads with minimal infrastructure administration; it is not the best match for the stated priority.

Answer D is incorrect because Azure SQL Database Hyperscale can be useful in Azure architectures, but its primary role is to support very large SQL databases that need rapid scaling and high storage capacity; it is not the best match for the stated priority.

 

Question 6

When considering Azure SQL Database Premium service tier in the DTU model, which requirement supports that choice?

1. To support SQL workloads that require full instance, operating system, or legacy feature control.
2. To support existing DTU-based Azure SQL workloads that need premium performance.
3. To run cloud-native SQL workloads with minimal infrastructure administration.
4. To host MySQL applications on a managed Azure database service.

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure SQL Database Premium service tier in the DTU model provides higher performance and business-continuity capabilities for DTU-based purchasing.

Incorrect Answers

Answer A is incorrect because that outcome is more directly associated with SQL Server on Azure Virtual Machines, not Azure SQL Database Premium service tier in the DTU model.

Answer C is incorrect because that outcome is more directly associated with Azure SQL Database, not Azure SQL Database Premium service tier in the DTU model.

Answer D is incorrect because that outcome is more directly associated with Azure Database for MySQL Flexible Server, not Azure SQL Database Premium service tier in the DTU model.

 

Question 7

When considering Azure SQL Managed Instance, which requirement supports that choice?

1. To migrate SQL Server applications that require more instance-level compatibility than Azure SQL Database.
2. To support SQL workloads that require full instance, operating system, or legacy feature control.
3. To host MySQL applications on a managed Azure database service.
4. To optimize cost for intermittent single-database workloads.

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure SQL Managed Instance provides a managed SQL Server-compatible instance with broad instance-level feature compatibility and native virtual network integration.

Incorrect Answers

Answer B is incorrect because that outcome is more directly associated with SQL Server on Azure Virtual Machines, not Azure SQL Managed Instance.

Answer C is incorrect because that outcome is more directly associated with Azure Database for MySQL Flexible Server, not Azure SQL Managed Instance.

Answer D is incorrect because that outcome is more directly associated with Azure SQL Database serverless compute tier, not Azure SQL Managed Instance.

 

Question 8

For Azure SQL elastic pool, which statement is accurate?

1. Automatically scales compute within configured limits and can pause during periods of inactivity for supported workloads.
2. Shares a pool of compute resources among multiple Azure SQL databases with variable and unpredictable usage.
3. Uses multiple replicas and local SSD-based storage for low latency, high IOPS, and built-in high availability.
4. Provides higher performance and business-continuity capabilities for DTU-based purchasing.

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure SQL elastic pool shares a pool of compute resources among multiple Azure SQL databases with variable and unpredictable usage.

Incorrect Answers

Answer A is incorrect because that description belongs to Azure SQL Database serverless compute tier, whose purpose is to optimize cost for intermittent single-database workloads.

Answer C is incorrect because that description belongs to Azure SQL Database Business Critical tier, whose purpose is to support latency-sensitive transactional SQL workloads.

Answer D is incorrect because that description belongs to Azure SQL Database Premium service tier in the DTU model, whose purpose is to support existing DTU-based Azure SQL workloads that need premium performance.

 

Question 9

To reduce cost for many databases whose utilization peaks at different times, which Azure design option should be selected?

1. Azure SQL elastic pool
2. Azure SQL Database Business Critical tier
3. Azure SQL Database Premium service tier in the DTU model
4. Azure SQL Database serverless compute tier

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure SQL elastic pool is designed to reduce cost for many databases whose utilization peaks at different times. Azure SQL elastic pool shares a pool of compute resources among multiple Azure SQL databases with variable and unpredictable usage.

Incorrect Answers

Answer B is incorrect because Azure SQL Database Business Critical tier can be useful in Azure architectures, but its primary role is to support latency-sensitive transactional SQL workloads; it is not the best match for the stated priority.

Answer C is incorrect because Azure SQL Database Premium service tier in the DTU model can be useful in Azure architectures, but its primary role is to support existing DTU-based Azure SQL workloads that need premium performance; it is not the best match for the stated priority.

Answer D is incorrect because Azure SQL Database serverless compute tier can be useful in Azure architectures, but its primary role is to optimize cost for intermittent single-database workloads; it is not the best match for the stated priority.

 

Question 10

For Azure Database for MySQL Flexible Server, which statement is accurate?

1. Provides managed MySQL with configurable compute, storage, backup, networking, and high availability.
2. Provides a cloud-native architecture for very large Azure SQL databases with independently scalable compute and storage characteristics.
3. Shares a pool of compute resources among multiple Azure SQL databases with variable and unpredictable usage.
4. Provides balanced compute and remote storage for common business workloads at lower cost than Business Critical.

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure Database for MySQL Flexible Server provides managed MySQL with configurable compute, storage, backup, networking, and high availability.

Incorrect Answers

Answer B is incorrect because that description belongs to Azure SQL Database Hyperscale, whose purpose is to support very large SQL databases that need rapid scaling and high storage capacity.

Answer C is incorrect because that description belongs to Azure SQL elastic pool, whose purpose is to reduce cost for many databases whose utilization peaks at different times.

Answer D is incorrect because that description belongs to Azure SQL Database General Purpose tier, whose purpose is to support general relational workloads without premium low-latency storage requirements.

 

Question 11

Which Azure capability provides a cloud-native architecture for very large Azure SQL databases with independently scalable compute and storage characteristics?

1. Azure SQL Database Hyperscale
2. Azure SQL Database Business Critical tier
3. Azure SQL Database Premium service tier in the DTU model
4. Azure SQL Managed Instance

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure SQL Database Hyperscale matches the described capability and is intended to support very large SQL databases that need rapid scaling and high storage capacity.

Incorrect Answers

Answer B is incorrect because Azure SQL Database Business Critical tier is intended to support latency-sensitive transactional SQL workloads, which is a different architectural function.

Answer C is incorrect because Azure SQL Database Premium service tier in the DTU model is intended to support existing DTU-based Azure SQL workloads that need premium performance, which is a different architectural function.

Answer D is incorrect because Azure SQL Managed Instance is intended to migrate SQL Server applications that require more instance-level compatibility than Azure SQL Database, which is a different architectural function.

 

Question 12

When considering Azure SQL elastic pool, which requirement supports that choice?

1. To support existing DTU-based Azure SQL workloads that need premium performance.
2. To support latency-sensitive transactional SQL workloads.
3. To optimize cost for intermittent single-database workloads.
4. To reduce cost for many databases whose utilization peaks at different times.

Correct Answer: D

 

Correct Answer

Answer D is correct because Azure SQL elastic pool shares a pool of compute resources among multiple Azure SQL databases with variable and unpredictable usage.

Incorrect Answers

Answer A is incorrect because that outcome is more directly associated with Azure SQL Database Premium service tier in the DTU model, not Azure SQL elastic pool.

Answer B is incorrect because that outcome is more directly associated with Azure SQL Database Business Critical tier, not Azure SQL elastic pool.

Answer C is incorrect because that outcome is more directly associated with Azure SQL Database serverless compute tier, not Azure SQL elastic pool.

 

Question 13

A new cloud-native application needs SQL Server engine capabilities without operating system or SQL instance administration. Which description correctly characterizes Azure SQL Database?

1. Shares a pool of compute resources among multiple Azure SQL databases with variable and unpredictable usage.
2. Provides managed PostgreSQL with configurable compute, storage, backup, networking, and high availability.
3. Provides a managed SQL Server-compatible instance with broad instance-level feature compatibility and native virtual network integration.
4. Is a fully managed relational database platform service for modern applications that need SQL Server engine capabilities without managing an operating system.

Correct Answer: D

 

Correct Answer

Answer D is correct because Azure SQL Database is a fully managed relational database platform service for modern applications that need SQL Server engine capabilities without managing an operating system.

Incorrect Answers

Answer A is incorrect because that description belongs to Azure SQL elastic pool, whose purpose is to reduce cost for many databases whose utilization peaks at different times.

Answer B is incorrect because that description belongs to Azure Database for PostgreSQL Flexible Server, whose purpose is to host PostgreSQL applications on a managed Azure database service.

Answer C is incorrect because that description belongs to Azure SQL Managed Instance, whose purpose is to migrate SQL Server applications that require more instance-level compatibility than Azure SQL Database.

 

Question 14

A security architect needs to support very large SQL databases that need rapid scaling and high storage capacity. Which Azure service or capability is the best fit?

1. Azure SQL Database Business Critical tier
2. Azure SQL Database Premium service tier in the DTU model
3. Azure SQL Database Hyperscale
4. Azure SQL Managed Instance

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure SQL Database Hyperscale provides a cloud-native architecture for very large Azure SQL databases with independently scalable compute and storage characteristics. It directly meets the requirement to support very large SQL databases that need rapid scaling and high storage capacity.

Incorrect Answers

Answer A is incorrect because Azure SQL Database Business Critical tier is used to support latency-sensitive transactional SQL workloads; that does not directly satisfy the requirement in this scenario.

Answer B is incorrect because Azure SQL Database Premium service tier in the DTU model is used to support existing DTU-based Azure SQL workloads that need premium performance; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because Azure SQL Managed Instance is used to migrate SQL Server applications that require more instance-level compatibility than Azure SQL Database; that does not directly satisfy the requirement in this scenario.

 

Question 15

For Azure SQL Database Hyperscale, which statement is accurate?

1. Provides a cloud-native architecture for very large Azure SQL databases with independently scalable compute and storage characteristics.
2. Uses multiple replicas and local SSD-based storage for low latency, high IOPS, and built-in high availability.
3. Provides a managed SQL Server-compatible instance with broad instance-level feature compatibility and native virtual network integration.
4. Provides higher performance and business-continuity capabilities for DTU-based purchasing.

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure SQL Database Hyperscale provides a cloud-native architecture for very large Azure SQL databases with independently scalable compute and storage characteristics.

Incorrect Answers

Answer B is incorrect because that description belongs to Azure SQL Database Business Critical tier, whose purpose is to support latency-sensitive transactional SQL workloads.

Answer C is incorrect because that description belongs to Azure SQL Managed Instance, whose purpose is to migrate SQL Server applications that require more instance-level compatibility than Azure SQL Database.

Answer D is incorrect because that description belongs to Azure SQL Database Premium service tier in the DTU model, whose purpose is to support existing DTU-based Azure SQL workloads that need premium performance.

 

Question 16

An organization wants to run cloud-native SQL workloads with minimal infrastructure administration. Which design choice most directly meets the requirement?

1. Azure Database for PostgreSQL Flexible Server
2. Azure SQL Database
3. Azure SQL elastic pool
4. Azure SQL Managed Instance

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure SQL Database is a fully managed relational database platform service for modern applications that need SQL Server engine capabilities without managing an operating system. It directly meets the requirement to run cloud-native SQL workloads with minimal infrastructure administration.

Incorrect Answers

Answer A is incorrect because Azure Database for PostgreSQL Flexible Server is used to host PostgreSQL applications on a managed Azure database service; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Azure SQL elastic pool is used to reduce cost for many databases whose utilization peaks at different times; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because Azure SQL Managed Instance is used to migrate SQL Server applications that require more instance-level compatibility than Azure SQL Database; that does not directly satisfy the requirement in this scenario.

 

Question 17

To host MySQL applications on a managed Azure database service, which Azure design option should be selected?

1. Azure SQL Database Hyperscale
2. Azure SQL Database General Purpose tier
3. Azure Database for MySQL Flexible Server
4. Azure SQL elastic pool

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure Database for MySQL Flexible Server is designed to host MySQL applications on a managed Azure database service. Azure Database for MySQL Flexible Server provides managed MySQL with configurable compute, storage, backup, networking, and high availability.

Incorrect Answers

Answer A is incorrect because Azure SQL Database Hyperscale can be useful in Azure architectures, but its primary role is to support very large SQL databases that need rapid scaling and high storage capacity; it is not the best match for the stated priority.

Answer B is incorrect because Azure SQL Database General Purpose tier can be useful in Azure architectures, but its primary role is to support general relational workloads without premium low-latency storage requirements; it is not the best match for the stated priority.

Answer D is incorrect because Azure SQL elastic pool can be useful in Azure architectures, but its primary role is to reduce cost for many databases whose utilization peaks at different times; it is not the best match for the stated priority.

 

Question 18

To host PostgreSQL applications on a managed Azure database service, which Azure design option should be selected?

1. Azure SQL Database Business Critical tier
2. Azure SQL Database serverless compute tier
3. Azure Database for PostgreSQL Flexible Server
4. Azure Database for MySQL Flexible Server

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure Database for PostgreSQL Flexible Server provides managed PostgreSQL with configurable compute, storage, backup, networking, and high availability. It directly meets the requirement to host PostgreSQL applications on a managed Azure database service.

Incorrect Answers

Answer A is incorrect because Azure SQL Database Business Critical tier is used to support latency-sensitive transactional SQL workloads; that does not directly satisfy the requirement in this scenario.

Answer B is incorrect because Azure SQL Database serverless compute tier is used to optimize cost for intermittent single-database workloads; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because Azure Database for MySQL Flexible Server is used to host MySQL applications on a managed Azure database service; that does not directly satisfy the requirement in this scenario.

 

Question 19

An organization wants to support existing DTU-based Azure SQL workloads that need premium performance. Which design choice most directly meets the requirement?

1. Azure Database for MySQL Flexible Server
2. Azure SQL Database Premium service tier in the DTU model
3. Azure SQL Database
4. SQL Server on Azure Virtual Machines

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure SQL Database Premium service tier in the DTU model provides higher performance and business-continuity capabilities for DTU-based purchasing. It directly meets the requirement to support existing DTU-based Azure SQL workloads that need premium performance.

Incorrect Answers

Answer A is incorrect because Azure Database for MySQL Flexible Server is used to host MySQL applications on a managed Azure database service; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Azure SQL Database is used to run cloud-native SQL workloads with minimal infrastructure administration; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because SQL Server on Azure Virtual Machines is used to support SQL workloads that require full instance, operating system, or legacy feature control; that does not directly satisfy the requirement in this scenario.

 

Question 20

To support existing DTU-based Azure SQL workloads that need premium performance, which Azure design option should be selected?

1. SQL Server on Azure Virtual Machines
2. Azure SQL Database
3. Azure Database for MySQL Flexible Server
4. Azure SQL Database Premium service tier in the DTU model

Correct Answer: D

 

Correct Answer

Answer D is correct because Azure SQL Database Premium service tier in the DTU model is designed to support existing DTU-based Azure SQL workloads that need premium performance. Azure SQL Database Premium service tier in the DTU model provides higher performance and business-continuity capabilities for DTU-based purchasing.

Incorrect Answers

Answer A is incorrect because SQL Server on Azure Virtual Machines can be useful in Azure architectures, but its primary role is to support SQL workloads that require full instance, operating system, or legacy feature control; it is not the best match for the stated priority.

Answer B is incorrect because Azure SQL Database can be useful in Azure architectures, but its primary role is to run cloud-native SQL workloads with minimal infrastructure administration; it is not the best match for the stated priority.

Answer C is incorrect because Azure Database for MySQL Flexible Server can be useful in Azure architectures, but its primary role is to host MySQL applications on a managed Azure database service; it is not the best match for the stated priority.

 

Question 21

To support SQL workloads that require full instance, operating system, or legacy feature control, which Azure design option should be selected?

1. Azure SQL Database Hyperscale
2. Azure SQL elastic pool
3. SQL Server on Azure Virtual Machines
4. Azure Database for PostgreSQL Flexible Server

Correct Answer: C

 

Correct Answer

Answer C is correct because SQL Server on Azure Virtual Machines is designed to support SQL workloads that require full instance, operating system, or legacy feature control. SQL Server on Azure Virtual Machines runs full SQL Server on IaaS virtual machines and provides operating system and SQL instance control.

Incorrect Answers

Answer A is incorrect because Azure SQL Database Hyperscale can be useful in Azure architectures, but its primary role is to support very large SQL databases that need rapid scaling and high storage capacity; it is not the best match for the stated priority.

Answer B is incorrect because Azure SQL elastic pool can be useful in Azure architectures, but its primary role is to reduce cost for many databases whose utilization peaks at different times; it is not the best match for the stated priority.

Answer D is incorrect because Azure Database for PostgreSQL Flexible Server can be useful in Azure architectures, but its primary role is to host PostgreSQL applications on a managed Azure database service; it is not the best match for the stated priority.

 

Question 22

For Azure SQL Database General Purpose tier, which statement is accurate?

1. Provides balanced compute and remote storage for common business workloads at lower cost than Business Critical.
2. Provides a managed SQL Server-compatible instance with broad instance-level feature compatibility and native virtual network integration.
3. Provides higher performance and business-continuity capabilities for DTU-based purchasing.
4. Provides managed PostgreSQL with configurable compute, storage, backup, networking, and high availability.

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure SQL Database General Purpose tier provides balanced compute and remote storage for common business workloads at lower cost than Business Critical.

Incorrect Answers

Answer B is incorrect because that description belongs to Azure SQL Managed Instance, whose purpose is to migrate SQL Server applications that require more instance-level compatibility than Azure SQL Database.

Answer C is incorrect because that description belongs to Azure SQL Database Premium service tier in the DTU model, whose purpose is to support existing DTU-based Azure SQL workloads that need premium performance.

Answer D is incorrect because that description belongs to Azure Database for PostgreSQL Flexible Server, whose purpose is to host PostgreSQL applications on a managed Azure database service.

 

Question 23

To migrate SQL Server applications that require more instance-level compatibility than Azure SQL Database, which Azure design option should be selected?

1. Azure SQL Managed Instance
2. SQL Server on Azure Virtual Machines
3. Azure Database for MySQL Flexible Server
4. Azure SQL Database serverless compute tier

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure SQL Managed Instance is designed to migrate SQL Server applications that require more instance-level compatibility than Azure SQL Database. Azure SQL Managed Instance provides a managed SQL Server-compatible instance with broad instance-level feature compatibility and native virtual network integration.

Incorrect Answers

Answer B is incorrect because SQL Server on Azure Virtual Machines can be useful in Azure architectures, but its primary role is to support SQL workloads that require full instance, operating system, or legacy feature control; it is not the best match for the stated priority.

Answer C is incorrect because Azure Database for MySQL Flexible Server can be useful in Azure architectures, but its primary role is to host MySQL applications on a managed Azure database service; it is not the best match for the stated priority.

Answer D is incorrect because Azure SQL Database serverless compute tier can be useful in Azure architectures, but its primary role is to optimize cost for intermittent single-database workloads; it is not the best match for the stated priority.

 

Question 24

Which Azure capability provides managed MySQL with configurable compute, storage, backup, networking, and high availability?

1. Azure SQL Database General Purpose tier
2. Azure SQL elastic pool
3. Azure SQL Database Hyperscale
4. Azure Database for MySQL Flexible Server

Correct Answer: D

 

Correct Answer

Answer D is correct because Azure Database for MySQL Flexible Server matches the described capability and is intended to host MySQL applications on a managed Azure database service.

Incorrect Answers

Answer A is incorrect because Azure SQL Database General Purpose tier is intended to support general relational workloads without premium low-latency storage requirements, which is a different architectural function.

Answer B is incorrect because Azure SQL elastic pool is intended to reduce cost for many databases whose utilization peaks at different times, which is a different architectural function.

Answer C is incorrect because Azure SQL Database Hyperscale is intended to support very large SQL databases that need rapid scaling and high storage capacity, which is a different architectural function.

 

Question 25

An organization wants to reduce cost for many databases whose utilization peaks at different times. Which design choice most directly meets the requirement?

1. Azure SQL Database serverless compute tier
2. Azure SQL Database Business Critical tier
3. Azure SQL Database Premium service tier in the DTU model
4. Azure SQL elastic pool

Correct Answer: D

 

Correct Answer

Answer D is correct because Azure SQL elastic pool shares a pool of compute resources among multiple Azure SQL databases with variable and unpredictable usage. It directly meets the requirement to reduce cost for many databases whose utilization peaks at different times.

Incorrect Answers

Answer A is incorrect because Azure SQL Database serverless compute tier is used to optimize cost for intermittent single-database workloads; that does not directly satisfy the requirement in this scenario.

Answer B is incorrect because Azure SQL Database Business Critical tier is used to support latency-sensitive transactional SQL workloads; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Azure SQL Database Premium service tier in the DTU model is used to support existing DTU-based Azure SQL workloads that need premium performance; that does not directly satisfy the requirement in this scenario.

 

Question 26

When considering Azure SQL Database Business Critical tier, which requirement supports that choice?

1. To support SQL workloads that require full instance, operating system, or legacy feature control.
2. To run cloud-native SQL workloads with minimal infrastructure administration.
3. To support latency-sensitive transactional SQL workloads.
4. To support general relational workloads without premium low-latency storage requirements.

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure SQL Database Business Critical tier uses multiple replicas and local SSD-based storage for low latency, high IOPS, and built-in high availability.

Incorrect Answers

Answer A is incorrect because that outcome is more directly associated with SQL Server on Azure Virtual Machines, not Azure SQL Database Business Critical tier.

Answer B is incorrect because that outcome is more directly associated with Azure SQL Database, not Azure SQL Database Business Critical tier.

Answer D is incorrect because that outcome is more directly associated with Azure SQL Database General Purpose tier, not Azure SQL Database Business Critical tier.

 

Question 27

A transactional Azure SQL workload has a stringent low-latency requirement. Which listed database tier is designed for this performance profile?

1. SQL Server on Azure Virtual Machines
2. Azure SQL Database Business Critical tier
3. Azure SQL Database
4. Azure SQL Database General Purpose tier

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure SQL Database Business Critical tier is designed to support latency-sensitive transactional SQL workloads. Azure SQL Database Business Critical tier uses multiple replicas and local SSD-based storage for low latency, high IOPS, and built-in high availability.

Incorrect Answers

Answer A is incorrect because SQL Server on Azure Virtual Machines can be useful in Azure architectures, but its primary role is to support SQL workloads that require full instance, operating system, or legacy feature control; it is not the best match for the stated priority.

Answer C is incorrect because Azure SQL Database can be useful in Azure architectures, but its primary role is to run cloud-native SQL workloads with minimal infrastructure administration; it is not the best match for the stated priority.

Answer D is incorrect because Azure SQL Database General Purpose tier can be useful in Azure architectures, but its primary role is to support general relational workloads without premium low-latency storage requirements; it is not the best match for the stated priority.

 

Question 28

For Azure SQL Managed Instance, which statement is accurate?

1. Automatically scales compute within configured limits and can pause during periods of inactivity for supported workloads.
2. Provides a managed SQL Server-compatible instance with broad instance-level feature compatibility and native virtual network integration.
3. Runs full SQL Server on IaaS virtual machines and provides operating system and SQL instance control.
4. Provides managed MySQL with configurable compute, storage, backup, networking, and high availability.

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure SQL Managed Instance provides a managed SQL Server-compatible instance with broad instance-level feature compatibility and native virtual network integration.

Incorrect Answers

Answer A is incorrect because that description belongs to Azure SQL Database serverless compute tier, whose purpose is to optimize cost for intermittent single-database workloads.

Answer C is incorrect because that description belongs to SQL Server on Azure Virtual Machines, whose purpose is to support SQL workloads that require full instance, operating system, or legacy feature control.

Answer D is incorrect because that description belongs to Azure Database for MySQL Flexible Server, whose purpose is to host MySQL applications on a managed Azure database service.

 

Question 29

Which Azure capability provides higher performance and business-continuity capabilities for DTU-based purchasing?

1. SQL Server on Azure Virtual Machines
2. Azure SQL Database Premium service tier in the DTU model
3. Azure SQL Database
4. Azure Database for MySQL Flexible Server

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure SQL Database Premium service tier in the DTU model matches the described capability and is intended to support existing DTU-based Azure SQL workloads that need premium performance.

Incorrect Answers

Answer A is incorrect because SQL Server on Azure Virtual Machines is intended to support SQL workloads that require full instance, operating system, or legacy feature control, which is a different architectural function.

Answer C is incorrect because Azure SQL Database is intended to run cloud-native SQL workloads with minimal infrastructure administration, which is a different architectural function.

Answer D is incorrect because Azure Database for MySQL Flexible Server is intended to host MySQL applications on a managed Azure database service, which is a different architectural function.

 

Question 30

An application must keep using PostgreSQL while the database infrastructure is managed by Azure. Which database service should the architect evaluate?

1. Azure SQL Database Business Critical tier
2. Azure SQL Database serverless compute tier
3. Azure Database for PostgreSQL Flexible Server
4. Azure Database for MySQL Flexible Server

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure Database for PostgreSQL Flexible Server is designed to host PostgreSQL applications on a managed Azure database service. Azure Database for PostgreSQL Flexible Server provides managed PostgreSQL with configurable compute, storage, backup, networking, and high availability.

Incorrect Answers

Answer A is incorrect because Azure SQL Database Business Critical tier can be useful in Azure architectures, but its primary role is to support latency-sensitive transactional SQL workloads; it is not the best match for the stated priority.

Answer B is incorrect because Azure SQL Database serverless compute tier can be useful in Azure architectures, but its primary role is to optimize cost for intermittent single-database workloads; it is not the best match for the stated priority.

Answer D is incorrect because Azure Database for MySQL Flexible Server can be useful in Azure architectures, but its primary role is to host MySQL applications on a managed Azure database service; it is not the best match for the stated priority.