Practice Test
True or False: In deciding a database service tier, one of the factors to consider is the amount of redundancy required.
- True
- False
Answer: True
Explanation: The required level of redundancy is one of the key factors for choosing a database service tier. Higher levels of redundancy typically cost more, but also provide greater data safety.
Which of the below options are valid service tiers for Azure SQL Database?
- A. Basic
- B. Standard
- C. Premium
- D. Zonal
Answer: A, B, C
Explanation: Azure SQL Database offers three service tiers: Basic, Standard, and Premium. Each tier provides a different level of performance and capabilities. ‘Zonal’ is not a valid service tier.
Azure Cosmos DB provides a ______ model to scale resources depending on the workload.
- A. Scale-out
- B. Scale-up
- C. Regional
- D. None of the above
Answer: A
Explanation: Azure Cosmos DB offers a scale-out model, which allows you to add or remove resources to match the workload requirements better.
The Business Critical service tier is the best option for which of the following scenarios?
- A. High availability required
- B. Consistently low activity
- C. Budgetary constraints are a key factor
- D. Database size is less than 2GB
Answer: A
Explanation: The Business Critical tier is best suited for high-availability scenarios due to high redundancy and failover capabilities. It may not be the most cost-effective option for scenarios with consistently low activity or smaller databases.
True or False: The compute tier in Azure refers to the amount of computational resources allocated for a particular service.
- True
- False
Answer: True
Explanation: The compute tier refers to the amount and type of computational resources – CPU, memory – assigned to a specific service in Azure.
The vCore-based purchasing model allows customers to independently scale which two resources in SQL Database and SQL Managed Instance?
- A. Compute and Storage
- B. Storage and Redundancy
- C. Redundancy and Network
- D. Network and Compute
Answer: A
Explanation: The vCore-based purchasing model in Azure allows customers to independently scale both compute and storage resources.
In Azure, service tiers are always related to cost.
- A. True
- B. False
Answer: A
Explanation: Each service tier in Azure typically comes with different costs, capacities and features. Higher service tiers generally result in higher costs.
The DTU-based purchasing model allows customers the ability to scale storage and compute separately.
- A. True
- B. False
Answer: B
Explanation: The DTU-based purchasing model offers a bundle of compute, storage and IO resources. They are not scalable independently.
Which Azure compute tier is suitable for running high-performance computing (HPC) and AI applications?
- A. Azure B-Series
- B. Azure Dv3-Series
- C. Azure F-Series
- D. Azure N-Series
Answer: D
Explanation: The Azure N-Series is designed for running high-performance computing (HPC) and AI applications, as they provide GPU capabilities.
The _____ tier in Azure Cosmos DB is ideal for applications requiring a low-cost database solution.
- A. Standard
- B. Premium
- C. Business Critical
- D. Basic
Answer: D
Explanation: The Basic tier in Azure Cosmos DB provides a less expensive option that is ideal for applications that do not require high performance or large storage.
Interview Questions
Q: What is Azure SQL Database service tier?
A: Azure SQL Database service tier is a model that provides different service capabilities that can accommodate various workloads of a database, ranging from light to heavy.
Name the three main service tiers in Azure SQL Database?
The three main service tiers in Azure SQL Database are Basic, Standard, and Premium.
Q: What is the compute tier in Azure?
A: The compute tier in Azure refers to the range of computing power options that your applications and workloads can utilize on the cloud. These tiers, like the D-series, E-series, F-series, etc. include different resource types like CPU, memory, and storage.
Q: What is the purpose of the Basic service tier in Azure SQL Database?
A: The Basic service tier is meant for applications with a light workload, offering a cost-effective option for development or testing environments and for applications with low concurrent operations.
Q: What does the Standard service tier in Azure SQL Database offer?
A: The Standard service tier provides a balance of computing resources and is designed for applications with medium volume of transactions.
Q: In what scenarios would you recommend the Premium service tier in Azure SQL Database?
A: The Premium service tier is recommended for high-volume, mission-critical production databases with high concurrent operations and the requirement for low-latency responses.
Q: Define the term ‘Elastic pool’ in context of Azure SQL Database?
A: Elastic pool in Azure SQL Database is a cost-effective solution that allows multiple databases to share resources within the same pool, providing flexibility and efficiency in resource utilization.
Q: How do you choose the best compute tier in Azure?
A: Choosing the best compute tier in Azure depends on several factors like the complexity of the application, its traffic demands, budget constraints, and specific requirements such as disk throughput, CPU power, or memory capacity.
Q: How are the price and performance levels differentiated in Azure SQL Database Service tiers?
A: The price and performance levels in Azure SQL Database Service tiers are differentiated based on the Database Transaction Units (DTUs) or vCore model, where higher DTUs or vCores mean more compute resources and higher cost.
Q: What is a vCore in the context of Azure SQL Database?
A: vCore, or Virtual Core, is a logical CPU provided with a choice of generations of hardware. It is part of vCore-based purchasing model used to choose compute and storage resources in Azure SQL Database.
Q: What are the main factors to consider when selecting a service tier in Azure SQL Database?
A: The main factors to consider when selecting a service tier in Azure SQL Database are the workload’s expected CPU, memory, and IO requirements, cost constraints, and required performance levels.
Q: Name the Azure SQL Database compute tier that is best suited for mission-critical applications requiring high throughput and low response time?
A: The Premium compute tier would be best suited for mission-critical applications requiring high throughput and low response time.
Q: How can I shift from one service tier to another in Azure SQL Database?
A: You can shift from one service tier to another in Azure SQL Database by scaling up or down, which can be done via the Azure portal, PowerShell, Transact-SQL, or ARM templates.
Q: What is the purpose of the ‘Compute tier’ in Azure Web App service plan?
A: Compute tier in Azure Web App service plan refers to a set of compute resources that your web app can use. Different tiers offer different features and capacities to accommodate varying needs of applications.
Q: What is Azure Cosmos DB service tier?
A: Azure Cosmos DB service tier refers to throughput level, or number of Request Units per second (RU/s), that determines the cost and performance of the Cosmos DB account.
extutorials.com