AZ-900 Assessment 2 — Questions and Answers
Question 1: Which Azure service provides a fully managed relational database based on the Microsoft SQL Server engine?
- Azure SQL Database (Correct answer)
- Azure Cosmos DB
- Azure Table Storage
- Azure Cache for Redis
Correct answer: Azure SQL Database
Azure SQL Database is a fully managed PaaS relational database built on the SQL Server engine.
Question 2: What is the primary benefit of an Azure Availability Zone?
- Protection from datacenter-level failures within a region (Correct answer)
- Lower data transfer costs
- Automatic code deployment
- Free virtual machines
Correct answer: Protection from datacenter-level failures within a region
Availability Zones are physically separate datacenters in a region that protect against datacenter failures.
Question 3: Which pricing model lets you reserve VM capacity for one or three years to reduce cost?
- Reserved Instances (Correct answer)
- Pay-as-you-go
- Spot pricing
- Free tier
Correct answer: Reserved Instances
Reserved Instances offer discounts in exchange for a one- or three-year commitment.
Question 4: What does Azure Resource Manager (ARM) primarily provide?
- A deployment and management layer for Azure resources (Correct answer)
- A virtual machine operating system
- A content delivery network
- A SQL query engine
Correct answer: A deployment and management layer for Azure resources
ARM is the management layer used to create, update, and delete resources in Azure.
Question 5: Which tool gives you a personalized view of best practices for cost, security, reliability, and performance?
- Azure Advisor (Correct answer)
- Azure Monitor
- Azure Policy
- Azure Blueprints
Correct answer: Azure Advisor
Azure Advisor analyzes resource usage and provides personalized optimization recommendations.
Question 6: What is the smallest deployable unit you can purchase for serverless code execution that bills per execution?
- Azure Functions (Correct answer)
- Azure Virtual Machines
- Azure Kubernetes Service
- Azure Batch
Correct answer: Azure Functions
Azure Functions is a serverless compute option that bills based on executions and resource consumption.
Question 7: Which Azure service stores unstructured data such as images, videos, and backups?
- Azure Blob Storage (Correct answer)
- Azure SQL Database
- Azure Files
- Azure Cosmos DB
Correct answer: Azure Blob Storage
Azure Blob Storage is optimized for storing massive amounts of unstructured object data.
AZ-900 Assessment 2
Which Azure service provides a fully managed relational database based on the Microsoft SQL Server engine?