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

1. Pergunta 1 de 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
   Mostrar resposta

   Resposta: C. Azure Blob Storage

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

2. Pergunta 2 de 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
   Mostrar resposta

   Resposta: A. A container

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

3. Pergunta 3 de 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
   Mostrar resposta

   Resposta: 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. Pergunta 4 de 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
   Mostrar resposta

   Resposta: 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. Pergunta 5 de 20

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

   • AArchive
   • BCold
   • CCool
   • DHot
   Mostrar resposta

   Resposta: D. Hot

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

6. Pergunta 6 de 20

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

   • ACool
   • BArchive
   • CHot
   • DCold
   Mostrar resposta

   Resposta: 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. Pergunta 7 de 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
   Mostrar resposta

   Resposta: 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. Pergunta 8 de 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
   Mostrar resposta

   Resposta: 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. Pergunta 9 de 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
   Mostrar resposta

   Resposta: 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. Pergunta 10 de 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
    Mostrar resposta

    Resposta: 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. Pergunta 11 de 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
    Mostrar resposta

    Resposta: 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. Pergunta 12 de 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
    Mostrar resposta

    Resposta: 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. Pergunta 13 de 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
    Mostrar resposta

    Resposta: 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. Pergunta 14 de 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
    Mostrar resposta

    Resposta: 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. Pergunta 15 de 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
    Mostrar resposta

    Resposta: 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. Pergunta 16 de 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
    Mostrar resposta

    Resposta: 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. Pergunta 17 de 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
    Mostrar resposta

    Resposta: 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. Pergunta 18 de 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
    Mostrar resposta

    Resposta: C. Azure Cosmos DB for Apache Gremlin

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

19. Pergunta 19 de 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
    Mostrar resposta

    Resposta: 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. Pergunta 20 de 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
    Mostrar resposta

    Resposta: 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.

Teclado: 1–4 para responder, Enter para a pergunta seguinte.