Exam: AZ-900: Microsoft Azure Fundamentals 0 Likes
Your company needs to have a data store in Azure. Below are the key (AZ-900)
Your company needs to have a data store in Azure. Below are the key requirements for the data store: The data store should be capable of storing 10TB of data. The data would be accessed infrequently. The data would need to be visualised using PowerBI.
Which of the following services could you use for this requirement?
Choose 2 answers from the options given below.
A) Azure SQL database.
B) Azure SQL data warehouse.
C) Azure Data Lake.
D) Azure Cosmos DB.
Solution
Correct answer: B) Azure SQL data warehouse and C) Azure Data Lake.
For storing 10TB of data that is accessed infrequently and needs to be visualized using PowerBI, the most suitable Azure services from the given options would be:
Azure SQL Data Warehouse (now known as Azure Synapse Analytics): This is a scalable and secure analytics service that supports data warehousing and big data analytics. It integrates well with PowerBI for data visualization.
Azure Data Lake: This is a highly scalable data storage service for big data analytics workloads. It can store vast amounts of data, including unstructured, semi-structured, and structured data. Azure Data Lake integrates well with PowerBI for visualizing large datasets.
These services are designed to handle large-scale data storage and analytics, making them suitable for your requirements.
Azure SQL Database and Azure Cosmos DB are not as well-suited for the specified use case:
Azure SQL Database is more suitable for transactional workloads rather than storing and analyzing large-scale data infrequently.
Azure Cosmos DB is a globally distributed, multi-model database service, which is also not primarily designed for infrequent access of large volumes of data for analytics purposes.
Category: Azure architecture and services