Microsoft Certification — Questions and Answers

Question 1: What is the role of Power Pages in the Power Platform?

Generating automated financial reports
Building external-facing websites with secure data access (Correct answer)
Managing cloud infrastructure
Creating internal employee chatbots

Correct answer: Building external-facing websites with secure data access

Power Pages is a low-code platform for building secure, external-facing business websites connected to Dataverse data.

Question 2: Your scale set can automatically scale in all of the following ways when an autoscale rule is triggered, except for which one?

Increase percent to (Correct answer)
Increase count to
Increase percent by
Increase count by

Correct answer: Increase percent to

Azure Autoscale rules for scaling in (reducing instances) typically offer options like 'Decrease count by' (reduce by a fixed number), 'Decrease percent by' (reduce by a percentage of current instances), or 'Decrease count to' (reduce to a specific number of instances). 'Increase percent to' is an action for scaling *out* (adding instances), not scaling in.

Question 3: What is the SLA (Service Level Agreement) uptime guarantee Microsoft provides for Microsoft 365?

95%
98%
100%
99.9% (Correct answer)

Correct answer: 99.9%

Microsoft guarantees 99.9% uptime for Microsoft 365 services, backed by a financially supported SLA.

Question 4: What is the difference between Recovery Time Objective (RTO) and Recovery Point Objective (RPO)?

RTO applies to databases; RPO applies to virtual machines only
They are the same concept with different names
RTO measures data loss; RPO measures downtime duration
RTO is the maximum acceptable downtime to restore service; RPO is the maximum acceptable data loss measured in time (Correct answer)

Correct answer: RTO is the maximum acceptable downtime to restore service; RPO is the maximum acceptable data loss measured in time

RTO defines how quickly a system must be restored after a failure (downtime tolerance), while RPO defines how much data loss is acceptable (last backup age tolerance).

Question 5: What is the primary function of Azure Databricks?

Managing Azure AD identities and access
Relational database management and SQL optimization
Big data processing and machine learning using Apache Spark (Correct answer)
Network traffic analysis and DDoS protection

Correct answer: Big data processing and machine learning using Apache Spark

Azure Databricks is an Apache Spark-based analytics platform optimized for big data processing, collaborative data science, and machine learning workloads.

Question 6: When designing a multi-region active-active architecture, which Azure database service supports automatic multi-region write capabilities?

Azure SQL Database
Azure Table Storage
Azure Database for MySQL
Azure Cosmos DB with multi-region writes enabled (Correct answer)

Correct answer: Azure Cosmos DB with multi-region writes enabled

Azure Cosmos DB supports multi-region writes, allowing applications to write data to any configured region with automatic conflict resolution.

Question 7: What does the unified client interface (UCI) provide in Dynamics 365?

A batch processing tool
A responsive, consistent user experience across all devices and form factors (Correct answer)
A legacy desktop interface for older browsers
A command-line interface for developers

Correct answer: A responsive, consistent user experience across all devices and form factors

The Unified Client Interface provides a modern, responsive design that works consistently across desktops, tablets, and phones in Dynamics 365.

Question 8: Which Azure storage option provides the highest throughput for high-performance computing (HPC) workloads?

Azure Queue Storage
Azure Table Storage
Azure NetApp Files or Azure Managed Lustre (Correct answer)
Azure Blob Storage (LRS)

Correct answer: Azure NetApp Files or Azure Managed Lustre

Azure NetApp Files and Azure Managed Lustre provide high-performance NFS/SMB file storage optimized for HPC, AI training, and media rendering workloads requiring ultra-low latency.

Question 9: What does Azure Blob Storage's 'lifecycle management' policy do?

Replicates blobs across subscriptions
Automatically transitions or deletes blobs based on rules and age (Correct answer)
Automatically backs up blobs to another region
Encrypts blobs at rest

Correct answer: Automatically transitions or deletes blobs based on rules and age

Lifecycle management policies in Azure Blob Storage automatically move data to cooler tiers or delete it based on time-based rules.

Question 10: Which Azure storage service is best suited for storing large amounts of unstructured data such as images, videos, and log files?

Azure Blob Storage (Correct answer)
Azure Table Storage
Azure Queue Storage
Azure SQL Database

Correct answer: Azure Blob Storage

Azure Blob Storage is designed for storing massive amounts of unstructured object data, including images, videos, documents, and backups.

Question 11: Which Azure feature allows you to scale apps automatically based on usage patterns and resource utilization?

EC2
Autoscale (Correct answer)
AutoElastic
Elastic Cloud

Correct answer: Autoscale

Azure Autoscale is a feature that allows applications to automatically scale their resources (like VM instances in a scale set or App Service plans) based on demand or a schedule. It monitors metrics such as CPU usage, memory, or queue length and automatically adds or removes instances to match the workload. This ensures optimal performance and cost efficiency by dynamically adjusting resources.

Question 12: Which feature in Microsoft Teams allows users to host webinars for external attendees?

Channels
Teams Live Events / Webinars (Correct answer)
Connectors
Apps

Correct answer: Teams Live Events / Webinars

Teams Webinars and Live Events allow organizations to broadcast presentations and training sessions to large external audiences.

Question 13: What does OneDrive provide in the Microsoft 365 ecosystem?

Video conferencing
Identity management
Personal cloud storage and file synchronization (Correct answer)
Email hosting

Correct answer: Personal cloud storage and file synchronization

OneDrive is Microsoft's personal cloud storage service that syncs files across devices and integrates with Microsoft 365 apps.

Question 14: Which Azure service provides a fully managed relational database based on the SQL Server engine?

Azure SQL Database (Correct answer)
Azure Table Storage
Azure Cosmos DB
Azure Blob Storage

Correct answer: Azure SQL Database

Azure SQL Database is a fully managed, Platform-as-a-Service relational database built on the SQL Server engine.

Question 15: What is the role of Microsoft Entra ID (formerly Azure Active Directory) in Microsoft 365?

Identity and access management for users and services (Correct answer)
Cloud storage management
Email filtering
Document co-authoring

Correct answer: Identity and access management for users and services

Microsoft Entra ID is the identity platform that handles authentication and authorization for Microsoft 365 and connected services.

Question 16: Which Microsoft 365 service replaces traditional on-premises Exchange server for email hosting?

Teams
SharePoint Online
Exchange Online (Correct answer)
Outlook.com

Correct answer: Exchange Online

Exchange Online is the cloud-hosted version of Microsoft Exchange that provides email, calendar, and contacts without on-premises servers.

Question 17: What architectural benefit does deploying across Azure Availability Zones provide?

Unlimited throughput for storage accounts
Reduced per-VM cost
Automatic cross-region failover
Protection against an entire datacenter failure within a region, providing 99.99% SLA (Correct answer)

Correct answer: Protection against an entire datacenter failure within a region, providing 99.99% SLA

Deploying resources across Availability Zones protects against entire datacenter failures since zones are physically separate facilities within a region, achieving a 99.99% SLA.

Question 18: What does Microsoft Defender for Endpoint protect?

Email inboxes from phishing
Windows and other OS devices against advanced threats using behavioral analysis and threat intelligence (Correct answer)
Network perimeter firewalls
Azure databases

Correct answer: Windows and other OS devices against advanced threats using behavioral analysis and threat intelligence

Microsoft Defender for Endpoint is an enterprise endpoint detection and response (EDR) platform that protects devices against malware, ransomware, and advanced persistent threats.

Question 19: Which Microsoft 365 plan is best suited for small businesses needing basic Office apps plus email?

Microsoft 365 F3
Microsoft 365 E5
Microsoft 365 Business Basic (Correct answer)
Microsoft 365 E3

Correct answer: Microsoft 365 Business Basic

Microsoft 365 Business Basic provides cloud-based Office apps, Exchange email, and Teams at an entry-level price for small businesses.

Question 20: Which type of data does Azure Storage Service Encryption (SSE) assist secure by automatically encrypting?

data in motion
data at rest (Correct answer)
data in transit
data in use

Correct answer: data at rest

Azure Storage Service Encryption (SSE) is designed to protect data that is 'at rest' in Azure storage accounts. This means it automatically encrypts data when it is persisted to storage media, such as blobs, files, queues, and tables. While Azure also offers encryption for data in transit (e.g., via TLS), SSE specifically addresses the security of stored data.

Question 21: Which of the following is open-source orchestration software for deploying, managing, and scaling containers across a cluster when working with widely used Azure applications?

Swarm
Bristle
Kubernetes (Correct answer)
Decker

Correct answer: Kubernetes

Kubernetes is an open-source container orchestration platform that automates the deployment, scaling, and management of containerized applications across a cluster. It is widely used in Azure (as Azure Kubernetes Service, AKS) to manage complex, distributed applications. Kubernetes provides features like self-healing, load balancing, and automated rollouts, making it ideal for modern cloud-native development.

Question 22: Which design pattern decouples services by placing a queue between a producer and consumer to handle load spikes?

Saga pattern
Circuit Breaker pattern
Strangler Fig pattern
Queue-based Load Leveling pattern (Correct answer)

Correct answer: Queue-based Load Leveling pattern

The Queue-based Load Leveling pattern uses a message queue as a buffer between a producer and consumer, smoothing out spikes in traffic without dropping requests.

Question 23: Which type of analytics answers the question 'What happened in the past?'

Predictive analytics
Cognitive analytics
Prescriptive analytics
Descriptive analytics (Correct answer)

Correct answer: Descriptive analytics

Descriptive analytics analyzes historical data to describe past events and trends, forming the foundation for other types of analytics.

Question 24: Which type of analytics uses statistical algorithms and machine learning to forecast future outcomes?

Diagnostic analytics
Predictive analytics (Correct answer)
Prescriptive analytics
Descriptive analytics

Correct answer: Predictive analytics

Predictive analytics uses historical data, statistical models, and machine learning to forecast future outcomes and identify trends.

Question 25: What is the primary difference between Microsoft 365 Business and Enterprise plans?

Enterprise plans are for non-profits only
Enterprise plans support more than 300 users and include advanced compliance tools (Correct answer)
Enterprise plans support Mac, Business plans do not
Business plans include Dynamics 365, Enterprise plans do not

Correct answer: Enterprise plans support more than 300 users and include advanced compliance tools

Microsoft 365 Enterprise plans are designed for organizations with more than 300 users and include advanced security, compliance, and analytics features.

Question 26: When should an architect choose Azure Service Bus over Azure Event Hubs?

When building real-time IoT pipelines
When enterprise messaging semantics like message ordering, dead-lettering, and transactions are required (Correct answer)
When storing events for long-term replay and historical analysis
When ingesting millions of telemetry events per second for streaming analytics

Correct answer: When enterprise messaging semantics like message ordering, dead-lettering, and transactions are required

Azure Service Bus is appropriate when you need enterprise messaging guarantees like ordering, dead-letter queues, and transactions, while Event Hubs is designed for high-volume event streaming.

Question 27: What is the role of Azure Cognitive Services in data and AI solutions?

Managing data storage costs and lifecycle policies
Providing pre-built AI capabilities like vision, speech, and language processing via APIs (Correct answer)
Replicating data across Azure regions for high availability
Optimizing SQL query execution plans

Correct answer: Providing pre-built AI capabilities like vision, speech, and language processing via APIs

Azure Cognitive Services offers pre-built AI APIs for computer vision, speech recognition, natural language processing, and decision-making without requiring custom model training.

Question 28: What is the maximum file size that can be uploaded to SharePoint Online in Microsoft 365?

15 GB (Correct answer)
1 GB
4 TB
250 GB

Correct answer: 15 GB

SharePoint Online supports file uploads up to 250 GB, making it suitable for large media files and documents.

Question 29: Which Azure service provides managed DNS hosting?

Azure CDN
Azure Traffic Manager
Azure DNS (Correct answer)
Azure Load Balancer

Correct answer: Azure DNS

Azure DNS is a hosting service for DNS domains that provides name resolution using Microsoft Azure's global infrastructure.

Question 30: What is the purpose of Azure Cost Management + Billing in architecture planning?

Managing Microsoft 365 license assignments
Configuring network routing policies
Optimizing CPU performance of virtual machines
Monitoring, analyzing, and optimizing Azure spending through budgets, alerts, and cost allocation (Correct answer)

Correct answer: Monitoring, analyzing, and optimizing Azure spending through budgets, alerts, and cost allocation

Azure Cost Management + Billing provides visibility into Azure spending, allows budget creation with alerts, and provides cost optimization recommendations to control cloud costs.

Question 31: What is the purpose of Azure Blueprints?

Designing network topology diagrams
Defining repeatable sets of Azure resources, policies, and role assignments to deploy compliant environments consistently (Correct answer)
Generating cost reports for Azure subscriptions
Creating virtual machine images for deployment

Correct answer: Defining repeatable sets of Azure resources, policies, and role assignments to deploy compliant environments consistently

Azure Blueprints package ARM templates, policies, and RBAC assignments into a single artifact that can be deployed to subscriptions to enforce consistent, compliant environments.

Microsoft Certification

Microsoft Certification exams validate technical skills across Azure, Microsoft 365, security, data, and other Microsoft technologies. Each exam tests role-based competencies for cloud architects, administrators, developers, and data professionals, with a scaled passing score of 700 out of 1000.

Questions

35 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds