Non-relational Databases Flashcards
You work for a company that is developing a new massively multiplayer online game, which will be launched in 20 countries next year. The data architects have opted to use Azure Cosmos DB as the games database tier.
What are two characteristics of using Azure DB?
Support for multiple geographic regions
Very low latency for read/write
You plan to reduce storage costs to store older, non-structured data in Azure Blob Storage. The data needs to be accessible occasionally to generate reports that must be available as soon as possible.
You need to choose the most appropriate data tier for this data.
Cool
Which Azure storage service includes support for Hot, Cool and Archive access tiers.
Azure Blob
Which two elements compose a key in a azure table storage
Row key, Partition Key
Azure File storage ______________
Supports direct mounting by windows, macOS and Linux
What Cosmos DB API is used for columnar data?
Cassandra API
What is the most commonly used Cosmos DB APO for graph data
Gremlin API
What Cosmos DB API is most commonly used for JSON documents?
Core API
In Azure Table Storage, data is stored as rows and columns, forming a table in which _________
The number of columns may vary according to each row
Which non-relational data store supports multi-region writes?
Cosmos DB API
Which non-relational data store supports multi-region read replicas?
Cosmos DB API and Azure Table Storage
What should be used to synchronize Azure Files locally shared files with a local cache inside an on-prem network to improve performance around serving files to users
Azure File Synch
You need to store training videos for company users.
What Azure data service should you use?
Azure Blob Storage
What is the most appropriate database tier for a Human Resources system storing employee data on a fixed schema?
Azure SQL Database
Which database tier would you use to store a social network that stores interaction data in a complex structure that changes frequently?
Azure Cosmos DB
