Exam AI-100 All Questions

View all questions & answers for the AI-100 exam

Exam AI-100 topic 2 question 60 discussion

Actual exam question from Microsoft's AI-100

Question #: 60
Topic #: 2

You are designing an AI application that will use an azure Machine Learning Studio experiment.
The source data contains more than 200 TB of relational tables. The experiment will run once a month.
You need to identify a data storage solution for the application. The solution must minimize compute costs.
Which data storage solution should you identify?

A. Azure Database for MySQL
B. Azure SQL Database
C. Azure SQL Data Warehouse

Show Suggested Answer

Suggested Answer: A 🗳️
Reference:
https://docs.microsoft.com/en-us/azure/mysql/overview

by exam_taker5 at Aug. 9, 2019, 6:39 p.m.

Comments

Submit Cancel

exam_taker5

Highly Voted 5 years, 10 months ago

I believe this should be data warehouse. Since the experiment will only run once a month, querying power is not needed. Warehouse is also able to store much more data and would minimize cost for 200TB

upvoted 25 times

...

Bharat

Highly Voted 5 years, 10 months ago

True. Moreover the provided link shows that the upper limit for SQL Database is 4 TB

upvoted 7 times

Miles19

5 years, 2 months ago

SQL database can go up to 100TB on hyper-scale, but it's still not sufficient. I agree with the data warehouse.

upvoted 7 times

sayak17

4 years, 9 months ago

SQL Database can go more than 200 TB. Check Gen5 here https://azure.microsoft.com/en-in/pricing/details/sql-database/single/

upvoted 2 times

...

rveney

Most Recent 2 years ago

C. Azure SQL Data Warehouse Explanation: To store more than 200 TB of relational tables and minimize compute costs for the AI application that will use Azure Machine Learning Studio experiment, the recommended data storage solution is Azure SQL Data Warehouse. Azure SQL Data Warehouse is a cloud-based, fully managed data warehouse service that provides high-performance analytics and scalability. It is designed to handle large volumes of data and allows you to scale compute resources independently of storage. This flexibility enables you to allocate the necessary compute resources for the monthly experiment while minimizing costs during idle periods.

upvoted 1 times

...

dijaa

3 years, 10 months ago

Difinetely warehouse

upvoted 1 times

...

Sonuand

4 years ago

For all those in favor of 'C', please note that a Warehouse has low storage costs and high computational costs (OLAP). A database has high storage costs but comparatively lower computational costs. Here we must minimize compute costs.

upvoted 1 times

...

Wisenut

4 years, 5 months ago

My pick would be C due to the following 1) Storage limits 2) Ability to pause DW computes when it is not used https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-overview https://stackify.com/azure-sql-database-vs-warehouse/

upvoted 4 times

Cornholioz

4 years, 4 months ago

Agree. Although I wouldn't choose DWH over SQL DB for the storage limits but for the pause feature to reduce costs. And also because of the Massive Parallel Processing which is required for an AI ML project such as this one. This is also why the question is relevant in an AI exam because it is important to pick a DWH instead of a DB even if it doesn't detail requirements about having datamarts or slice & dice of a DWH.

upvoted 1 times

...

UpsetUser

4 years, 5 months ago

Can someone tell me How this question is relevant to AI-100 exam,,, ??

upvoted 3 times

Timeless_Faceless

4 years, 5 months ago

Bruhhh..... Just learn it though. We'll ask questions after we have gotten the certificates

upvoted 5 times

...

allanm

4 years, 1 month ago

AI-100/AI-102 focusses on becoming an Azure AI architect. By nature of what it has to offer, there will be questions where it will focus on AI storage and retrieval and hence database options will be one of them.

upvoted 1 times

...

nepketo

4 years, 8 months ago

I think it's Azure SQL Data Warehouse, which is now called Azure Synapse. Gen 1 has max size of 240 TB with an ability to grow up to 1 PB with clustered columnstore compression. Plus, with the pause and scale feature, compute costs can be greatly reduced which is what we want here. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-service-capacity-limits https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-best-practices

upvoted 6 times

...

Shay14

4 years, 9 months ago

So it says the source data is 200TB. Are they not asking where to store the output data? SQL Database could be sufficient then?

upvoted 1 times

sayak17

4 years, 9 months ago

The next thing they say is it should minimize compute costs. Now if you check the 40 core 204 GB option for sql database under gen 5 and the 32 core 320 GB option for "database for mysql" then it seems that "database for mysql" should be the answer

upvoted 1 times

sayak17

4 years, 9 months ago

relevant links: https://azure.microsoft.com/en-in/pricing/details/sql-database/single/ https://azure.microsoft.com/en-us/pricing/details/mysql/server/

upvoted 1 times

Wisenut

4 years, 5 months ago

But doesnt Azure DB for MySQL have a 16TB storage limit

upvoted 1 times

Cornholioz

4 years, 4 months ago

Correct. I wouldn't choose MySQL here. https://docs.microsoft.com/en-us/azure/mysql/concepts-pricing-tiers

upvoted 2 times

...

Johnnien

4 years, 8 months ago

The answer could be "A. Azure Database for MySQL"

upvoted 1 times

...

htest2000

4 years, 9 months ago

I think SQL Data Warehouse is correct answer due to 200 TB size of data. It should be C.

upvoted 1 times

sayak17

4 years, 9 months ago

check Gen5 here. it can very well support it https://azure.microsoft.com/en-in/pricing/details/sql-database/single/

upvoted 1 times

...

avg15

4 years, 11 months ago

I just spent some time reading through several articles on this topic, and I'm certain that SQL DB cannot be the solution because of the amount of data is capped around 10 TB. It's cheaper initially but cannot support the premises of this question. The correct answer is Data Warehouse

upvoted 1 times

sayak17

4 years, 9 months ago

Check this https://azure.microsoft.com/en-in/pricing/details/sql-database/single/ It can go more than 200 TB. See under Gen5

upvoted 1 times

...

Atanu

5 years, 2 months ago

C is the right ans

upvoted 1 times

...

putriafebriana

5 years, 3 months ago

Max instance storage size (reserved) - 2 TB for 4 vCores (Gen5 only) - 8 TB for other sizes Gen4: 1 TB Gen5: - 1 TB for 4, 8, 16 vCores - 2 TB for 24 vCores - 4 TB for 32, 40, 64, 80 vCores These are the max instance for SQL database, the answer should be SQL data warehouse

upvoted 2 times

putriafebriana

5 years, 3 months ago

https://stackify.com/azure-sql-database-vs-warehouse/ Azure SQL Database Azure SQL Data Warehouse Data type Relational Relational

upvoted 3 times

...

sayak17

4 years, 9 months ago

No. See Gen5 tiers here for SQL Database here. https://azure.microsoft.com/en-in/pricing/details/sql-database/single/ It can go more than 200 TB

upvoted 1 times

...

MK1977

5 years, 5 months ago

I believe keyword was 'relational', hence the Azure SQL DB response (and low cost).

upvoted 1 times

Swatishri

5 years, 5 months ago

Relational data type is relevant for both SQL DB and SQL Warehouse

upvoted 4 times

...

SwatiMS

5 years, 6 months ago

Correct answer should be Azure SQL Data Warehouse

upvoted 4 times

Stants

5 years, 6 months ago

Only Azure SQL Data Warehouse can support 200TB DB https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-service-capacity-limits

upvoted 5 times

sayak17

4 years, 9 months ago

why? Check Gen5 for sql database here. it can support more than 200TB https://azure.microsoft.com/en-in/pricing/details/sql-database/single/

upvoted 1 times

...