Exam AI-100 All Questions

View all questions & answers for the AI-100 exam

Exam AI-100 topic 1 question 5 discussion

Actual exam question from Microsoft's AI-100

Question #: 5
Topic #: 1

You are configuring data persistence for a Microsoft Bot Framework application. The application requires a structured NoSQL cloud data store.
You need to identify a storage solution for the application. The solution must minimize costs.
What should you identify?

A. Azure Blob storage
B. Azure Cosmos DB
C. Azure HDInsight
D. Azure Table storage

Show Suggested Answer

Suggested Answer: D 🗳️
Table Storage is a NoSQL key-value store for rapid development using massive semi-structured datasets
You can develop applications on Cosmos DB using popular NoSQL APIs.
Both services have a different scenario and pricing model.
While Azure Storage Tables is aimed at high capacity on a single region (optional secondary read only region but no failover), indexing by PK/RK and storage- optimized pricing; Azure Cosmos DB Tables aims for high throughput (single-digit millisecond latency), global distribution (multiple failover), SLA-backed predictive performance with automatic indexing of each attribute/property and a pricing model focused on throughput.
References:
https://db-engines.com/en/system/Microsoft+Azure+Cosmos+DB%3BMicrosoft+Azure+Table+Storage

by sanjay10 at April 24, 2020, 2:58 p.m.

Comments

Submit Cancel

aitruthseeker

Highly Voted 4 years, 5 months ago

"Table API in Azure Cosmos DB Vs Azure Table storage: Where is Table API not identical with Azure Table storage behavior? There are some behavior differences that users coming from Azure Table storage who want to create tables with the Azure Cosmos DB Table API should be aware of: Azure Cosmos DB Table API uses a reserved capacity model in order to ensure guaranteed performance but this means that one pays for the capacity as soon as the table is created, even if the capacity isn't being used. With Azure Table storage one only pays for capacity that's used. This helps to explain why Table API can offer a 10 ms read and 15 ms write SLA at the 99th percentile while Azure Table storage offers a 10-second SLA. But as a consequence, with Table API tables, even empty tables without any requests, cost money in order to ensure the capacity is available to handle any requests to them at the SLA offered by Azure Cosmos DB." Hence, Table storage is more appropriate here than Azure Cosmos DB Table API. As for why not Azure Blob Storage, enough said already by others here.

upvoted 14 times

OsimIndia

4 years, 5 months ago

Nice Explanation.

upvoted 2 times

...

dev2dev

2 years, 5 months ago

Answer is simple. Price basis Table storage is cheaper. Please don't mix Table API of Cosmos DB which requires storage in Cosmos DB which occurs very high cost.

upvoted 1 times

...

rveney

Most Recent 2 years ago

For a structured NoSQL cloud data store with cost optimization in mind, the most suitable option among the provided choices would be B. Azure Cosmos DB.

upvoted 1 times

...

smacar01

4 years, 2 months ago

What does this question have to do with AI solutions? It's a question about data and pricing. A Cosmos DB solution would be an acceptable solution

upvoted 4 times

...

Larry99

4 years, 5 months ago

Azure Table storage is a cloud-based NoSQL datastore you can use to store large amounts of structured, non-relational data. Azure Table offers a schemaless design, which enables you to store a collection of entities in one table

upvoted 1 times

...

Gopi909

4 years, 5 months ago

Azure Table storage is a service that stores structured NoSQL data in the cloud, providing a key/attribute store with a schemaless design. https://docs.microsoft.com/en-us/azure/cosmos-db/table-storage-overview

upvoted 1 times

...

kempstonjoystick

4 years, 6 months ago

This is an interesting one, as the table storage api for CosmosDB is now recommended over table storage for all use cases, check the wording in the link at the top:- https://azure.microsoft.com/en-gb/services/storage/tables/

upvoted 2 times

...

sanjay10

5 years, 1 month ago

Not sure why it is not Azure Blob storage

upvoted 1 times

Eddie888

5 years ago

Not Azure Blob Storage because it's not NoSQL DB

upvoted 6 times

...

awron_durat

4 years, 6 months ago

It asked for a "structured" NoSQL DB and blob is specifically unstructured.

upvoted 6 times

...