Exam: AZ-900: Microsoft Azure Fundamentals 0 Likes
You plan to store 20 TB of data in Azure. The data will be accessed (AZ-900)
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.
A) Azure Data Lake.
B) Azure Cosmos DB.
C) Azure SQL Data Warehouse.
D) Azure SQL Database.
E) Azure Database for PostgreSQL.
Solution
Correct answer: A) Azure Data Lake and C) Azure SQL Data Warehouse.
Here's why:
Azure Data Lake is a highly scalable and secure repository for big data analytics. It's designed for infrequently accessed data and supports various data formats, making it a great fit for your use case.
Azure Storage (Hot and Cold) provides a cost-effective solution for storing large amounts of data. You can store your data in Hot storage for frequently accessed data and move less frequently accessed data to Cold storage, which is more cost-effective.
Azure Cosmos DB is a globally distributed, multi-model database service, which might not be the best fit for your use case since you mentioned the data will be accessed infrequently. Azure SQL Data Warehouse, Azure SQL Database, and Azure Database for PostgreSQL are relational databases, which might not be the best fit for storing large amounts of unstructured data.
Note that you may also consider using Azure Blob Storage or Azure File Storage as a storage solution, depending on the specific requirements of your data and how you plan to access it.
Category: Azure architecture and services