DP-900 Azure Storage: Blob, Data Lake, Files and Tables Practice Questions
Azure Storage is the main non-relational topic outside Cosmos DB. Know the blob types, how blobs are organized in containers, and the hot, cool, cold and archive access tiers. Azure Data Lake Storage Gen2 adds a hierarchical namespace on top of Blob storage for analytics.
Azure Files provides SMB and NFS file shares in the cloud, and Azure Table storage is a simple key-value store where rows are grouped by partition key. Questions often ask which of these fits a given scenario.
Below are 10 free questions on this topic. Try each one before you open the answer.
Question 1
A company stores large video files that are accessed frequently for the first 30 days, rarely for the next 90 days, and almost never after that. Which Azure Blob Storage access tier strategy should they use?
A.Store all files in the Hot tier permanently
B.Store all files in the Archive tier from the start
C.Use Hot tier initially, then transition to Cool, then Archive using lifecycle management
D.Use the Cold tier for all files regardless of age
chevron_rightShow answer and explanation
Correct answer: C. Use Hot tier initially, then transition to Cool, then Archive using lifecycle management
Azure Blob Storage lifecycle management policies can automatically move blobs between tiers based on age. Hot tier is optimized for frequent access, Cool for infrequent access (30–90 days), and Archive for data rarely or never accessed. This tiered approach minimizes storage costs while meeting access requirements.
Question 2
Which protocol does Azure Files use to allow Linux-based systems to mount file shares?
A.SMB only
B.HTTP/HTTPS only
C.NFS (Network File System)
D.iSCSI
chevron_rightShow answer and explanation
Correct answer: C. NFS (Network File System)
Azure Files supports both SMB (Server Message Block) for Windows clients and NFS (Network File System) for Linux and macOS clients. NFS shares are available on Premium Azure Files accounts and allow Linux workloads to mount Azure file shares natively without requiring any additional drivers.
Question 3
A company needs cloud storage that multiple on-premises servers can mount simultaneously as a shared network drive using standard protocols, without modifying application code. Which Azure service meets this requirement?
A.Azure Blob Storage
B.Azure Data Lake Storage Gen2
C.Azure Files
D.Azure Managed Disks
chevron_rightShow answer and explanation
Correct answer: C. Azure Files
Azure Files provides fully managed cloud file shares accessible via SMB and NFS protocols — the same protocols used by on-premises file servers. Multiple servers can mount the same Azure file share concurrently, making it ideal for shared application data, configuration files, and lift-and-shift file server migrations. Azure Managed Disks attach to a single VM (not shared), Blob Storage is not mountable as a drive by default, and ADLS Gen2 is optimized for analytics workloads.
Question 4
A developer needs to grant a partner company temporary read access to a specific blob in a private Azure Storage container without sharing the storage account key or creating an Azure AD account for them. Which feature enables this?
A.Container-level public access
B.Shared Access Signature (SAS) token
C.Azure AD role assignment
D.Cross-origin resource sharing (CORS) rule
chevron_rightShow answer and explanation
Correct answer: B. Shared Access Signature (SAS) token
A Shared Access Signature (SAS) is a URI that grants restricted, time-limited access to Azure Storage resources without exposing the storage account key. A SAS token can specify: which resources are accessible, which operations are permitted (read, write, delete, list), the start and expiry time, and optionally allowed IP addresses. This is the correct way to grant temporary, scoped access to external parties. Container-level public access makes blobs anonymous to anyone — it cannot be scoped to a specific partner or time window. Azure AD role assignments require the partner to have an Azure AD identity. CORS rules control browser cross-origin requests, not partner access.
Question 5
A blob stored in the Archive tier in Azure Blob Storage needs to be read. What must happen before the blob data can be accessed?
A.The blob must be copied to a new storage account
B.The blob must be rehydrated to the Hot or Cool tier
C.The blob access tier must be changed to Premium
D.A SAS token with archive-read permission must be generated
chevron_rightShow answer and explanation
Correct answer: B. The blob must be rehydrated to the Hot or Cool tier
Blobs in the Archive tier are stored offline and cannot be read directly. To access them, they must first be rehydrated — either by changing the blob's access tier to Hot or Cool, or by copying the blob to a Hot or Cool tier destination. Standard rehydration can take up to 15 hours. High-priority rehydration (for blobs under 10 GB) is faster but more expensive. This offline nature is what allows Archive to offer very low storage costs. Creating a SAS token does not bypass the offline storage constraint.
Question 6
A company uses GRS (Geo-Redundant Storage) for their Azure Storage account. A primary region outage occurs. Which statement correctly describes read access to the secondary region during this outage?
A.GRS automatically allows reads from the secondary region during any outage
B.With standard GRS, reads from the secondary region are only available after Microsoft initiates a failover; RA-GRS allows reads from the secondary at any time
C.GRS and RA-GRS both require manual failover before reads from the secondary are possible
D.GRS replicates data synchronously to the secondary region, so reads are always available with zero lag
chevron_rightShow answer and explanation
Correct answer: B. With standard GRS, reads from the secondary region are only available after Microsoft initiates a failover; RA-GRS allows reads from the secondary at any time
Standard GRS replicates data asynchronously to a secondary region but does not expose the secondary for reads during normal operation. Read access to the secondary is only available after a failover is initiated (by Microsoft or by the customer in account failover). Read-Access GRS (RA-GRS) adds a read-only secondary endpoint that is always available — applications can read from it even when the primary is healthy, enabling higher read availability. Note that GRS replication is asynchronous, so a small amount of data (RPO) may not have reached the secondary at the moment of a primary failure.
Question 7
A developer accidentally deletes a blob from Azure Blob Storage. The storage account has soft delete enabled with a 14-day retention period. What can the developer do to recover the blob?
A.The blob is permanently gone and cannot be recovered
B.Restore the blob from the geo-redundant secondary region
C.Undelete the blob within the 14-day soft-delete retention window
D.Re-upload the blob from the local machine where it was originally stored
chevron_rightShow answer and explanation
Correct answer: C. Undelete the blob within the 14-day soft-delete retention window
When blob soft delete is enabled, deleted blobs are not immediately removed from storage. Instead, they are marked as soft-deleted and retained for the configured number of days (in this case 14 days). During this period, a developer can use the Undelete Blob operation (via the portal, CLI, SDK, or REST API) to restore the blob to its previous state. After the retention period expires, the blob is permanently purged. Soft delete also protects against overwrite operations when blob versioning is not enabled. This is a simple and effective safeguard against accidental deletion.
Question 8
A company stores application log files in Azure Blob Storage. A data analyst wants to query these logs using SQL without loading them into a database or creating any infrastructure. The logs are in Parquet format. Which Azure service allows this?
A.Azure SQL Database external tables
B.Azure Synapse Analytics serverless SQL pool
C.Azure Synapse Analytics dedicated SQL pool
D.Azure Data Factory data flow
chevron_rightShow answer and explanation
Correct answer: B. Azure Synapse Analytics serverless SQL pool
Azure Synapse Analytics serverless SQL pool allows you to query files (Parquet, CSV, JSON, Delta) stored in Azure Data Lake Storage or Blob Storage directly using T-SQL with the OPENROWSET function or external tables — no data loading or dedicated compute required. You pay only per TB of data scanned. Dedicated SQL pools require data to be loaded into their internal columnar store first. Azure SQL Database external tables can point to Azure Blob but have limited format support and require a database instance. Azure Data Factory data flows are used for ETL transformation pipelines, not ad hoc SQL querying.
Question 9
Determine whether each statement about Azure Table Storage is correct.
1.Azure Table Storage supports foreign keys, stored procedures, and views just like a relational database.
2.Each row in an Azure Table Storage table must have a unique key composed of a partition key and a row key.
3.Data in Azure Table Storage is usually denormalized, with each row holding the entire data for a logical entity.
chevron_rightShow answer and explanation
Statement 1: No
Statement 2: Yes
Statement 3: Yes
Statement 1 is false: Azure Table Storage has no concept of foreign keys, relationships, stored procedures, views, or other relational database objects — it is a NoSQL key-value store. Statement 2 is true: every row requires a composite unique key made up of a partition key and a row key. Statement 3 is true: because there are no joins, data is typically denormalized so one row contains all data for a logical entity.
Question 10
Azure Blob Storage organizes blobs within a storage account inside ___, which provide a way to group related blobs and control access permissions at that level.
A.containers
B.partitions
C.file shares
D.databases
chevron_rightShow answer and explanation
Correct answer: A. containers
Blobs in Azure Blob Storage are stored in containers. A container groups related blobs and is the level at which read/write permissions are controlled. Partitions (B) are used in Azure Table Storage to group rows. File shares (C) are the organizational unit in Azure Files, not Blob Storage. Databases (D) are used in relational and some NoSQL services such as Cosmos DB.
These are 10 of 44 Azure Storage: Blob, Data Lake, Files and Tables questions in the full bank
Practice all 400 DP-900 questions in exam format, including drag-and-drop and multi-select questions, with a mock exam and progress tracking.