Tag: Azure Data Services

azure, DP-900, Microsoft Certification

Practice Questions: Describe Azure Blob storage (DP-900 Exam Prep)

Practice Questions

Question 1

What type of data is best suited for Azure Blob Storage?

A. Highly structured relational data
B. Unstructured data such as images and videos
C. Data requiring complex joins
D. Transactional financial records

✅ Answer: B

Explanation:
Blob Storage is optimized for unstructured data like media files, documents, and logs.

Question 2

What is the correct hierarchy in Azure Blob Storage?

A. Blob → Container → Storage Account
B. Container → Blob → Storage Account
C. Storage Account → Container → Blob
D. Storage Account → Blob → Container

✅ Answer: C

Explanation:
The hierarchy is Storage Account → Container → Blob.

Question 3

Which type of blob is BEST suited for storing log files that are continuously appended?

A. Block blob
B. Page blob
C. Append blob
D. Archive blob

✅ Answer: C

Explanation:
Append blobs are optimized for append operations, such as logging.

Question 4

Which access tier is MOST cost-effective for data that is rarely accessed?

A. Hot
B. Cool
C. Archive
D. Premium

✅ Answer: C

Explanation:
The Archive tier is designed for rarely accessed data at the lowest cost.

Question 5

Which Blob Storage feature ensures data is replicated to improve durability?

A. Indexing
B. Data redundancy options
C. Query optimization
D. Schema enforcement

✅ Answer: B

Explanation:
Blob Storage uses redundancy options (e.g., LRS, GRS) to ensure durability.

Question 6

Which blob type is typically used for storing virtual machine disks?

A. Block blob
B. Append blob
C. Page blob
D. Archive blob

✅ Answer: C

Explanation:
Page blobs support random read/write operations and are used for VM disks.

Question 7

Which scenario is BEST suited for Azure Blob Storage?

A. Running complex SQL queries
B. Storing large volumes of images for a website
C. Managing transactional order data
D. Performing real-time analytics

✅ Answer: B

Explanation:
Blob Storage is ideal for storing large volumes of unstructured data like images.

Question 8

What is a container in Azure Blob Storage?

A. A type of blob
B. A virtual machine
C. A logical grouping of blobs
D. A database schema

✅ Answer: C

Explanation:
Containers are used to organize blobs, similar to folders.

Question 9

Which feature allows secure, temporary access to Blob Storage resources?

A. SQL authentication
B. Shared Access Signature (SAS)
C. Primary key constraint
D. Indexing

✅ Answer: B

Explanation:
SAS tokens provide secure, time-limited access to storage resources.

Question 10

Which statement best describes Azure Blob Storage?

A. It requires a predefined schema
B. It is used only for relational data
C. It is an object storage solution for unstructured data
D. It is a transactional database system

✅ Answer: C

Explanation:
Blob Storage is an object storage service designed for unstructured data.

✅ Quick Exam Takeaways

✔ Blob Storage = unstructured/object storage
✔ Structure:

  • Storage Account → Container → Blob

✔ Blob types:

  • Block → general files
  • Append → logs
  • Page → VM disks

✔ Access tiers:

  • Hot (frequent access)
  • Cool (infrequent)
  • Archive (rare)

✔ Key features:

  • Scalable
  • Durable (replication)
  • Secure (SAS, RBAC)
  • Cost-optimized

Go to the DP-900 Exam Prep Hub main page.

azure, Databases, DP-900, Microsoft Certification

Identify Azure Database Services for open-source database systems (DP-900 Exam Prep)

 
This post is a part of the DP-900: Microsoft Azure Data Fundamentals Exam Prep Hub. 
This topic falls under these sections:
Identify considerations for relational data on Azure (20–25%)
   --> Describe relational Azure data services
      --> Identify Azure database services for open-source database systems

Note that there are 10 practice questions (with answers and explanations) for each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available on the hub below the exam topics section.

In addition to the Azure SQL family, Microsoft Azure provides fully managed database services for popular open-source relational database systems. These services allow organizations to run familiar technologies like PostgreSQL and MySQL in the cloud without managing infrastructure.

For the DP-900 exam, you should understand which services are available, what they support, and when to use them.

What Are Open-Source Database Systems?

Open-source database systems are relational databases whose source code is publicly available and widely used across industries.

Common examples include:

  • PostgreSQL
  • MySQL
  • MariaDB

These systems are known for flexibility, cost-effectiveness, and strong community support.

Azure Services for Open-Source Databases

Azure offers managed services for these databases, allowing you to run them in a Platform as a Service (PaaS) model.

1. Azure Database for PostgreSQL

Azure Database for PostgreSQL

A fully managed PostgreSQL database service.

Key Features

  • Automated backups and patching
  • Built-in high availability
  • Scaling options for compute and storage
  • Security features (encryption, network isolation)
  • Support for PostgreSQL extensions

Deployment Options

  • Flexible Server (most commonly used)

Use Cases

  • Web and mobile applications
  • Analytics workloads
  • Applications already using PostgreSQL

✔ Best for: PostgreSQL-based applications moving to Azure

2. Azure Database for MySQL

Azure Database for MySQL

A fully managed MySQL database service.

Key Features

  • Automated backups and patching
  • High availability options
  • Scaling for performance
  • Built-in security features
  • Compatible with popular MySQL tools

Use Cases

  • Web applications (e.g., LAMP stack)
  • E-commerce platforms
  • Content management systems

✔ Best for: Applications built on MySQL

3. Azure Database for MariaDB (Legacy Note)

Azure Database for MariaDB

  • Previously offered as a managed service
  • Now being retired (important exam awareness point)

💡 DP-900 Tip:
Know that MariaDB exists, but focus primarily on PostgreSQL and MySQL.

Key Characteristics of Azure Open-Source Database Services

These services share common benefits:

Platform as a Service (PaaS)

  • No infrastructure management
  • Azure handles patching, backups, and updates

High Availability

  • Built-in redundancy
  • Automatic failover options

Scalability

  • Scale compute and storage independently

Security

  • Encryption at rest and in transit
  • Network security (firewalls, private endpoints)

When to Use Open-Source Database Services in Azure

Choose these services when:

  • You are already using PostgreSQL or MySQL
  • You want to migrate existing applications with minimal changes
  • You prefer open-source technologies
  • You want a managed service without infrastructure overhead

Comparison with Azure SQL Family

FeatureAzure SQL ServicesOpen-Source Azure Services
Database EngineSQL ServerPostgreSQL / MySQL
LanguageT-SQLPostgreSQL SQL / MySQL SQL
Use CaseMicrosoft ecosystemOpen-source ecosystem
ManagementPaaS / IaaS optionsPrimarily PaaS

Why This Matters for DP-900

On the exam, you may be asked to:

  • Identify Azure services for PostgreSQL or MySQL
  • Choose the correct service for an open-source workload
  • Understand the benefits of managed database services
  • Compare Azure SQL vs open-source options

Summary — Exam-Relevant Takeaways

✔ Azure supports open-source relational databases:

  • Azure Database for PostgreSQL
  • Azure Database for MySQL

✔ These are PaaS services:

  • Azure manages infrastructure, backups, and patching

✔ Key benefits:

  • High availability
  • Scalability
  • Security

✔ Use them when:

  • Migrating existing open-source applications
  • Building apps using PostgreSQL or MySQL

✔ Be aware:

  • MariaDB support exists but is being phased out

Go to the Practice Exam Questions for this topic.

Go to the DP-900 Exam Prep Hub main page.

azure, Databases, DP-900, Microsoft Certification

Practice Questions: Identify Azure Database Services for open-source database systems (DP-900 Exam Prep)

Practice Questions

Question 1

Which Azure service is used to host a managed PostgreSQL database?

A. Azure SQL Database
B. Azure Database for PostgreSQL
C. Azure Cosmos DB
D. Azure Synapse Analytics

✅ Answer: B

Explanation:
Azure Database for PostgreSQL is the managed service for PostgreSQL workloads.

Question 2

Which Azure service is BEST suited for hosting a MySQL-based web application?

A. Azure SQL Managed Instance
B. Azure Database for MySQL
C. Azure Data Lake Storage
D. Azure Blob Storage

✅ Answer: B

Explanation:
Azure Database for MySQL is designed for MySQL workloads, commonly used in web apps.

Question 3

What type of service are Azure Database for PostgreSQL and Azure Database for MySQL?

A. Infrastructure as a Service (IaaS)
B. Platform as a Service (PaaS)
C. Software as a Service (SaaS)
D. On-premises solutions

✅ Answer: B

Explanation:
These services are PaaS offerings, meaning Azure manages infrastructure and maintenance.

Question 4

Which task is handled by Azure in open-source database PaaS services?

A. Writing SQL queries
B. Managing application code
C. Performing backups and patching
D. Designing database schema

✅ Answer: C

Explanation:
Azure handles operational tasks like backups, patching, and updates.

Question 5

Which scenario is BEST suited for Azure Database for PostgreSQL?

A. Running a NoSQL database
B. Migrating an existing PostgreSQL application to Azure
C. Storing unstructured files
D. Running machine learning models

✅ Answer: B

Explanation:
This service is ideal for migrating or running PostgreSQL workloads in Azure.

Question 6

Which of the following is an open-source relational database supported by Azure?

A. Microsoft SQL Server
B. Oracle Database
C. PostgreSQL
D. Azure Cosmos DB

✅ Answer: C

Explanation:
PostgreSQL is a widely used open-source relational database supported by Azure.

Question 7

Which Azure database service for open-source systems is being retired?

A. Azure Database for PostgreSQL
B. Azure Database for MySQL
C. Azure Database for MariaDB
D. Azure SQL Database

✅ Answer: C

Explanation:
Azure Database for MariaDB is being phased out.

Question 8

Which feature is commonly provided by Azure open-source database services?

A. Manual scaling only
B. No security features
C. Built-in high availability
D. No backup support

✅ Answer: C

Explanation:
These services include built-in high availability and redundancy.

Question 9

Which is a key benefit of using Azure Database for MySQL instead of installing MySQL on a VM?

A. Full OS control
B. Reduced management overhead
C. No support for scaling
D. Limited security features

✅ Answer: B

Explanation:
PaaS reduces administrative tasks like maintenance and patching.

Question 10

Which factor is MOST important when choosing Azure Database for PostgreSQL or MySQL?

A. Whether the data is unstructured
B. The need for OS-level access
C. The existing database engine used by the application
D. The need for NoSQL capabilities

✅ Answer: C

Explanation:
Choice is typically driven by the database engine already used (PostgreSQL vs MySQL).

✅ Quick Exam Takeaways

✔ Azure Database for PostgreSQL → PostgreSQL workloads
✔ Azure Database for MySQL → MySQL workloads
✔ Both are PaaS services (Azure manages infrastructure)

✔ Key benefits:

  • Automated backups
  • Patching and updates
  • High availability
  • Scalability

✔ Use when:

  • Migrating open-source databases
  • Building apps on PostgreSQL or MySQL

✔ Be aware:

  • MariaDB is being retired

Go to the DP-900 Exam Prep Hub main page.

azure, DP-900, Microsoft Certification

Describe the Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines (DP-900 Exam Prep)

 
This post is a part of the DP-900: Microsoft Azure Data Fundamentals Exam Prep Hub. 
This topic falls under these sections:
Identify considerations for relational data on Azure (20–25%)
   --> Describe relational Azure data services
      --> Describe the Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines

Note that there are 10 practice questions (with answers and explanations) for each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available on the hub below the exam topics section.

Microsoft Azure provides a family of relational database services collectively known as the Azure SQL family. These services are based on the Microsoft SQL Server engine and are designed to support a wide range of workloads—from fully managed cloud databases to lift-and-shift migrations.

For the DP-900 exam, you should understand the differences, use cases, and key features of:

  • Azure SQL Database
  • Azure SQL Managed Instance
  • SQL Server on Azure Virtual Machines

Overview of the Azure SQL Family

All Azure SQL offerings:

  • Use the Microsoft SQL Server engine
  • Support Structured Query Language (SQL)
  • Are designed for relational data workloads
  • Provide varying levels of management control vs automation

💡 The key difference is how much control you have vs how much Azure manages for you.

1. Azure SQL Database

Azure SQL Database is a fully managed Platform as a Service (PaaS) offering.

Key Features

  • Fully managed by Azure (patching, backups, updates)
  • Built-in high availability
  • Automatic scaling options
  • Intelligent performance tuning
  • Minimal administrative overhead

Deployment Options

  • Single database (isolated)
  • Elastic pool (shared resources across multiple databases)

Use Cases

  • Cloud-native applications
  • Modern web and mobile apps
  • Applications that do not require full SQL Server feature compatibility

✔ Best for: Simplicity, scalability, and minimal management

2. Azure SQL Managed Instance

Azure SQL Managed Instance is a Platform as a Service (PaaS) offering with near 100% compatibility with SQL Server.

Key Features

  • Managed service with automated patching and backups
  • Supports most SQL Server features (e.g., SQL Agent, linked servers)
  • Instance-level features (unlike Azure SQL Database)
  • Runs inside a virtual network (VNet)

Use Cases

  • Migration of on-premises SQL Server applications
  • Applications requiring instance-level features
  • Lift-and-shift scenarios with minimal changes

✔ Best for: Compatibility with existing SQL Server environments

3. SQL Server on Azure Virtual Machines

SQL Server on Azure Virtual Machines is an Infrastructure as a Service (IaaS) offering.

Key Features

  • Full control over the operating system and SQL Server
  • You manage patching, backups, and maintenance
  • Supports all SQL Server features
  • Easy lift-and-shift migration

Use Cases

  • Legacy applications requiring full control
  • Custom configurations or unsupported features in PaaS
  • Scenarios requiring OS-level access

✔ Best for: Maximum control and full SQL Server compatibility

Key Differences at a Glance

FeatureAzure SQL DatabaseAzure SQL Managed InstanceSQL Server on Azure VM
Service TypePaaSPaaSIaaS
ManagementFully managedMostly managedCustomer-managed
SQL Server CompatibilityPartialNear 100%100%
OS AccessNoNoYes
Use CaseCloud-native appsMigration with minimal changesFull control / legacy apps

Choosing the Right Option

Think of the Azure SQL family as a spectrum:

  • Most managed → Azure SQL Database
  • Balanced → Azure SQL Managed Instance
  • Most control → SQL Server on Azure VM

💡 DP-900 Tip:
Questions often test your ability to match a scenario with the correct service based on:

  • Level of control required
  • Compatibility needs
  • Migration vs cloud-native design

Why This Matters for DP-900

On the exam, you may be asked to:

  • Identify differences between Azure SQL offerings
  • Choose the appropriate service for a scenario
  • Understand PaaS vs IaaS trade-offs
  • Recognize management responsibilities

Summary — Exam-Relevant Takeaways

✔ All Azure SQL services are based on SQL Server
✔ Use SQL for querying and management

✔ Azure SQL Database

  • Fully managed
  • Best for modern cloud apps

✔ Azure SQL Managed Instance

  • High compatibility with SQL Server
  • Best for migrations

✔ SQL Server on Azure VM

  • Full control (IaaS)
  • Best for legacy or highly customized environments

✔ Key decision factor = control vs management

Go to the Practice Exam Questions for this topic.

Go to the DP-900 Exam Prep Hub main page.

azure, Databases, DP-900, Microsoft Certification

Practice Questions: Describe the Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines (DP-900 Exam Prep)

Practice Questions

Question 1

Which Azure SQL offering is fully managed and requires the least administrative effort?

A. SQL Server on Azure Virtual Machines
B. Azure SQL Managed Instance
C. Azure SQL Database
D. Azure Synapse Analytics

✅ Answer: C

Explanation:
Azure SQL Database is a fully managed PaaS service with minimal administration.

Question 2

Which Azure SQL service provides the highest level of compatibility with on-premises SQL Server while still being a PaaS solution?

A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure Cosmos DB

✅ Answer: B

Explanation:
Azure SQL Managed Instance offers near 100% compatibility with SQL Server.

Question 3

Which Azure SQL option allows full control over the operating system?

A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure SQL Elastic Pool

✅ Answer: C

Explanation:
SQL Server on Azure VM is an IaaS offering, giving full OS-level control.

Question 4

Which service is BEST suited for a cloud-native application with minimal management overhead?

A. SQL Server on Azure Virtual Machines
B. Azure SQL Managed Instance
C. Azure SQL Database
D. Azure Data Lake

✅ Answer: C

Explanation:
Azure SQL Database is optimized for modern cloud applications.

Question 5

Which Azure SQL service supports instance-level features such as SQL Agent?

A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure Blob Storage

✅ Answer: B

Explanation:
Managed Instance supports many instance-level features not available in Azure SQL Database.

Question 6

A company wants to migrate an existing SQL Server database with minimal changes. Which service should they choose?

A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure Synapse Analytics

✅ Answer: B

Explanation:
Managed Instance is designed for lift-and-shift migrations with high compatibility.

Question 7

Which Azure SQL option requires you to manage backups, updates, and patching?

A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure SQL Elastic Pool

✅ Answer: C

Explanation:
In IaaS (Azure VM), the customer is responsible for management tasks.

Question 8

Which of the following best describes Platform as a Service (PaaS) in the Azure SQL family?

A. Full control over hardware and OS
B. No database management required at all
C. Azure manages infrastructure and database maintenance
D. Only supports non-relational data

✅ Answer: C

Explanation:
PaaS handles infrastructure, patching, backups, and high availability.

Question 9

Which Azure SQL service is MOST appropriate when you need maximum control and customization?

A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure SQL Elastic Pool

✅ Answer: C

Explanation:
SQL Server on Azure VM provides full control over configuration and environment.

Question 10

Which statement best describes the relationship between the Azure SQL family products?

A. They use completely different database engines
B. They all use the SQL Server engine with different management levels
C. Only Azure SQL Database supports SQL
D. Only SQL Server on Azure VM supports relational data

✅ Answer: B

Explanation:
All Azure SQL offerings are based on the SQL Server engine, differing mainly in management and control.

✅ Quick Exam Takeaways

✔ Azure SQL Database

  • Fully managed (PaaS)
  • Best for cloud-native apps

✔ Azure SQL Managed Instance

  • Near full SQL Server compatibility
  • Best for migrations

✔ SQL Server on Azure VM

  • Full control (IaaS)
  • You manage everything

✔ Key concept:
👉 More control = more responsibility
👉 More automation = less control

Go to the DP-900 Exam Prep Hub main page.