Topic 1 · Question 160

You plan to store 20 TB of data in Azure. The data will be accessed infrequently and visualized by using Microsoft Power BI.
You need to recommend a storage solution for the data.
Which two solutions should you recommend? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Azure Data Lake

B. Azure Cosmos DB

C. Azure SQL Data Warehouse

D. Azure SQL Database

E. Azure Database for PostgreSQL

Top comment

Community votes:AC · 5 (100%)

▲ 176Highly votedMay 04, 2020 10:12 am

Azure SQL Data Warehouse is now Azure Synapse Analytics can you please change it in the options.

10 more highly voted comments

adino13▲ 43Highly votedJune 11, 2020 12:45 am

Heads up: Azure SQL DW is no longer the appropriate name. It has been changed to Azure Synapse Analytics

Zurvan▲ 31Highly votedJanuary 28, 2020 11:18 pm

Also infrequently is here the key. Otherwise Cosmos DB would have been the right answer.

marttcore▲ 26Highly votedJune 29, 2023 03:56 pm

"few years later..."

ultraOriginalVillain▲ 26Highly votedApril 11, 2020 11:34 am

Out of the various storage solutions by Azure, only these two are designed as purely huge data dumps for the most infrequent usage.

lawcarvalho▲ 23Highly votedAugust 22, 2020 01:11 pm

In my point of view, the storage size is very important to respond this question.
Postgress up to 16 TB: https://azure.microsoft.com/en-us/pricing/details/postgresql/server/
SQL DB up to 4 TB: https://docs.microsoft.com/pt-br/azure/azure-sql/managed-instance/resource-limits

MissLuka▲ 14Highly votedMarch 11, 2023 02:49 pm

I just passed, this question appeared on my exam, there were a lot of questions from examtopic a few new and a few which were changed a bit

Saurabh2102▲ 13Highly votedJune 01, 2022 10:03 pm

Correct answers are 'A' and 'C', Keywords to identify answers are 20TB(Big data), and it will be accessed infrequently(Data Warehouse).

sudheerdhawangis▲ 8Highly votedJune 26, 2021 06:39 pm

Learn like this: Power BI :::Azure Data Lake, Azure SQL Data Warehouse.

murat12345▲ 8Highly votedJanuary 27, 2021 08:53 am

What does infrequently has to do with azure dataware house and datalake? The datawarehouse van be accesed as (in)frequently as the user wants.. The huge amount of data that is stored is the key I think.

Carmen_S▲ 7Highly votedSeptember 01, 2020 03:41 pm

Thanks everyone for the useful comments. Just had my exam. This was was def on the test!

Open discussion on ExamTopics ↗