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

1. 第1题，共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
   显示答案

   答案: C. Azure Blob Storage

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

2. 第2题，共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
   显示答案

   答案: A. A container

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

3. 第3题，共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
   显示答案

   答案: 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. 第4题，共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
   显示答案

   答案: 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. 第5题，共20题

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

   • AArchive
   • BCold
   • CCool
   • DHot
   显示答案

   答案: D. Hot

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

6. 第6题，共20题

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

   • ACool
   • BArchive
   • CHot
   • DCold
   显示答案

   答案: 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. 第7题，共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
   显示答案

   答案: 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. 第8题，共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
   显示答案

   答案: 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. 第9题，共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
   显示答案

   答案: 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. 第10题，共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
    显示答案

    答案: 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. 第11题，共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
    显示答案

    答案: 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. 第12题，共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
    显示答案

    答案: 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. 第13题，共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
    显示答案

    答案: 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. 第14题，共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
    显示答案

    答案: 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. 第15题，共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
    显示答案

    答案: 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. 第16题，共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
    显示答案

    答案: 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. 第17题，共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
    显示答案

    答案: 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. 第18题，共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
    显示答案

    答案: C. Azure Cosmos DB for Apache Gremlin

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

19. 第19题，共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
    显示答案

    答案: 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. 第20题，共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
    显示答案

    答案: 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.

键盘：按1–4作答，按 Enter 进入下一题。