Azure Data Fundamentals (DP-900) Exam Preparation: Non-relational data on Azure

1. Question 1 of 20

   Which Azure service stores large amounts of unstructured data, such as images and video, as binary large objects?

   • AAzure Database for MySQL
   • BAzure SQL Database
   • CAzure Blob Storage
   • DAzure Table storage
   Show answer

   Answer: C. Azure Blob Storage

   Azure Blob Storage stores unstructured data as blobs, which apps read and write through the blob storage API.

2. Question 2 of 20

   In Azure Blob Storage, what do you use to group related blobs and control who can read and write them?

   • AA container
   • BA partition key
   • CA view
   • DA file share
   Show answer

   Answer: A. A container

   Blobs are stored in containers inside a storage account, and access is controlled at the container level.

3. Question 3 of 20

   Azure uses which type of blob for virtual machine disks, because it supports random reads and writes of 512-byte pages?

   • ABlock blob
   • BPage blob
   • CArchive blob
   • DAppend blob
   Show answer

   Answer: B. Page blob

   Page blobs are made of fixed 512-byte pages and are optimized for random read and write operations, such as VM disks.

4. Question 4 of 20

   An app writes log entries and only ever adds new data to the end of the file. Which blob type is designed for this?

   • ABlock blob in the Archive tier
   • BTable entity
   • CPage blob
   • DAppend blob
   Show answer

   Answer: D. Append blob

   Append blobs only allow new blocks to be added at the end, which suits logging. Existing blocks cannot be updated or deleted.

5. Question 5 of 20

   Which blob access tier is the default and is meant for data that is accessed often?

   • AArchive
   • BCold
   • CCool
   • DHot
   Show answer

   Answer: D. Hot

   The Hot tier is the default. It uses high-performance storage for blobs that are accessed frequently.

6. Question 6 of 20

   Which access tier has the lowest storage cost, but can take up to 15 hours to retrieve a blob?

   • ACool
   • BArchive
   • CHot
   • DCold
   Show answer

   Answer: B. Archive

   Archive stores blobs in an offline state. It is the cheapest tier for storage, but retrieval can take up to 15 hours.

7. Question 7 of 20

   You need to read a blob that is in the Archive tier. What must happen first?

   • ACopy it to an Azure file share by using the SMB protocol
   • BAdd a partition key and a row key to the blob
   • CChange its tier to Hot, Cool or Cold and let it rehydrate
   • DTurn on the hierarchical namespace for the account
   Show answer

   Answer: C. Change its tier to Hot, Cool or Cold and let it rehydrate

   Archived blobs are offline. You change the tier to Hot, Cool or Cold, and you can read the blob only when rehydration is complete.

8. Question 8 of 20

   What can a lifecycle management policy do in Azure Blob Storage?

   • AConvert blobs into relational tables with foreign keys
   • BMove blobs to cheaper tiers as they age and delete old ones
   • CCopy blobs into Azure SQL Database every night
   • DEncrypt each blob with the password of the user who made it
   Show answer

   Answer: B. Move blobs to cheaper tiers as they age and delete old ones

   Lifecycle policies can move blobs from Hot to Cool, Cold and Archive based on days since they were changed, and can delete old blobs.

9. Question 9 of 20

   How do you create an Azure Data Lake Storage Gen2 file system?

   • ATurn on the hierarchical namespace of a storage account
   • BCreate an Azure SQL Database elastic pool for the files
   • CSelect the Archive tier for every blob in a container
   • DChoose the NFS protocol when you create an Azure file share
   Show answer

   Answer: A. Turn on the hierarchical namespace of a storage account

   Data Lake Storage Gen2 is built into Azure Storage. You enable the hierarchical namespace when you create the account, or upgrade an existing one.

10. Question 10 of 20

    What should you know before upgrading an existing storage account to use a hierarchical namespace?

    • AThe upgrade is one-way and can't be reversed
    • BAll blobs in the account are moved to the Archive tier
    • CThe account must first be converted to a SQL database
    • DThe account can then only be used with the NFS protocol
    Show answer

    Answer: A. The upgrade is one-way and can't be reversed

    Upgrading to a hierarchical namespace is a one-way process. After it, you can't go back to a flat namespace.

11. Question 11 of 20

    Which statement about Microsoft OneLake is correct?

    • AIt can store data only as CSV files in an Azure file share
    • BIt comes with every Fabric tenant and is built on ADLS Gen2
    • CEach department in a company must create its own separate OneLake
    • DIt is a relational database built on Azure SQL Managed Instance
    Show answer

    Answer: B. It comes with every Fabric tenant and is built on ADLS Gen2

    OneLake is a single logical data lake for the whole organization. It comes with every Fabric tenant and is built on ADLS Gen2.

12. Question 12 of 20

    An office wants to replace its on-premises network file shares with cloud file shares that Windows, Linux and macOS computers can all use. Which service and protocol fit?

    • AAzure Files with SMB
    • BAzure Files with NFS
    • CAzure Table storage
    • DAzure Blob Storage page blobs
    Show answer

    Answer: A. Azure Files with SMB

    Azure Files provides network file shares. SMB works across Windows, Linux and macOS, while NFS shares are for Linux only.

13. Question 13 of 20

    In Azure Table storage, what makes up the unique key of each row?

    • AA partition key and a row key
    • BA container name and a blob name
    • CA timestamp and a row number
    • DA primary key and a foreign key
    Show answer

    Answer: A. A partition key and a row key

    Every row in an Azure table has a unique key made of a partition key and a row key. A timestamp records when it was last changed.

14. Question 14 of 20

    Why does including the partition key in an Azure Table storage query improve performance?

    • AIt creates a new index on every column in the table
    • BIt moves the matching data to the Hot access tier
    • CIt turns the query into a SQL join across tables
    • DIt narrows the search, so less I/O is needed
    Show answer

    Answer: D. It narrows the search, so less I/O is needed

    Rows with the same partition key are stored together. Searching by partition key reduces the amount of I/O needed to find the data.

15. Question 15 of 20

    Data in Azure Table storage is usually stored in what way?

    • ANormalized into many tables linked by foreign keys
    • BDenormalized, with each row holding a whole entity
    • CAs fixed-width text files in an Azure file share
    • DAs graphs of nodes connected by edges
    Show answer

    Answer: B. Denormalized, with each row holding a whole entity

    Azure tables have no foreign keys or relationships, so each row usually holds the whole entity, and rows can have different fields.

16. Question 16 of 20

    A team is building a brand-new app on Azure Cosmos DB and wants to store JSON documents and query them with a SQL-like language. Which API is recommended?

    • AAzure Cosmos DB for NoSQL
    • BAzure Cosmos DB for Table
    • CAzure Cosmos DB for Apache Cassandra
    • DAzure Cosmos DB for Apache Gremlin
    Show answer

    Answer: A. Azure Cosmos DB for NoSQL

    The NoSQL API (formerly called the SQL API) stores JSON documents with a SQL-like query syntax and is recommended for new apps.

17. Question 17 of 20

    A company is moving an existing MongoDB app to Azure Cosmos DB and wants to keep its drivers and code. Which API should it use?

    • AAzure Cosmos DB for MongoDB
    • BAzure Cosmos DB for NoSQL
    • CAzure Cosmos DB for Table
    • DAzure Cosmos DB for Apache Gremlin
    Show answer

    Answer: A. Azure Cosmos DB for MongoDB

    The MongoDB API stores data as BSON and works with MongoDB drivers, so existing apps connect without major code changes.

18. Question 18 of 20

    Which Azure Cosmos DB API stores data as vertices and edges for scenarios such as recommendation engines and fraud detection?

    • AAzure Cosmos DB for Table
    • BAzure Cosmos DB for Apache Cassandra
    • CAzure Cosmos DB for Apache Gremlin
    • DAzure Cosmos DB for MongoDB
    Show answer

    Answer: C. Azure Cosmos DB for Apache Gremlin

    The Gremlin API works with graphs, where entities are vertices (nodes) and relationships are edges.

19. Question 19 of 20

    A team is migrating an Apache Cassandra workload that uses column-family tables and CQL. Which Azure Cosmos DB API fits best?

    • AAzure Cosmos DB for Apache Cassandra
    • BAzure Cosmos DB for Apache Gremlin
    • CAzure Cosmos DB for NoSQL
    • DAzure Cosmos DB for MongoDB
    Show answer

    Answer: A. Azure Cosmos DB for Apache Cassandra

    The Cassandra API uses column-family tables and the Cassandra Query Language (CQL), so it suits Cassandra migrations.

20. Question 20 of 20

    A gaming company needs player profiles and leaderboards with very low-latency reads and writes for players around the world. Which service fits best?

    • AAzure SQL Managed Instance
    • BAzure Cosmos DB
    • CAzure Files
    • DAzure Blob Storage Archive tier
    Show answer

    Answer: B. Azure Cosmos DB

    Cosmos DB is built for global distribution and fast reads and writes. Gaming leaderboards and player profiles are listed use cases.

Keyboard: 1–4 to answer, Enter for the next question.