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

1. Question 1 sur 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
   Voir la réponse

   Réponse: 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 sur 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
   Voir la réponse

   Réponse: A. A container

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

3. Question 3 sur 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
   Voir la réponse

   Réponse: 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 sur 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
   Voir la réponse

   Réponse: 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 sur 20

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

   • AArchive
   • BCold
   • CCool
   • DHot
   Voir la réponse

   Réponse: D. Hot

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

6. Question 6 sur 20

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

   • ACool
   • BArchive
   • CHot
   • DCold
   Voir la réponse

   Réponse: 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 sur 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
   Voir la réponse

   Réponse: 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 sur 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
   Voir la réponse

   Réponse: 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 sur 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
   Voir la réponse

   Réponse: 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 sur 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
    Voir la réponse

    Réponse: 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 sur 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
    Voir la réponse

    Réponse: 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 sur 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
    Voir la réponse

    Réponse: 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 sur 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
    Voir la réponse

    Réponse: 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 sur 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
    Voir la réponse

    Réponse: 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 sur 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
    Voir la réponse

    Réponse: 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 sur 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
    Voir la réponse

    Réponse: 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 sur 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
    Voir la réponse

    Réponse: 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 sur 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
    Voir la réponse

    Réponse: 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 sur 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
    Voir la réponse

    Réponse: 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 sur 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
    Voir la réponse

    Réponse: 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.

Clavier : 1–4 pour répondre, Entrée pour la question suivante.