Microsoft Azure Fundamentals — Question 46

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.

Answer options

• A. Azure Data Lake
• B. Azure Cosmos DB
• C. Azure SQL Data Warehouse
• D. Azure SQL Database
• E. Azure Database for PostgreSQL

Correct answer: A, C

Explanation

Azure Data Lake is designed for big data analytics and can efficiently store large volumes of data that is accessed infrequently, making it suitable for this scenario. Azure SQL Data Warehouse, now known as Azure Synapse Analytics, is also a good choice for storing large datasets and supports complex queries, which is beneficial for visualization in Power BI. The other options, like Azure Cosmos DB and Azure SQL Database, are not ideally suited for infrequent access of such large datasets.