You plan to store 20 TB of data in Azure. The data will be accessed infrequently and visualized using Microsoft Power BI. You need to recommend a storage solution. Which two solutions should you recommend? Each correct answer is a complete solution. NOTE: Each correct selection is worth one point.
Choose an answer
Tap an option to check your answer.
Correct answer: Azure Data Lake, Azure SQL Data Warehouse.
Why this is the answer
Azure Data Lake is suitable for storing large volumes of unstructured or semi-structured data, like the 20 TB mentioned, and is often used for big data analytics, which aligns with Power BI visualization. Azure SQL Data Warehouse (now Azure Synapse Analytics) is an enterprise data warehouse that can handle massive amounts of relational and non-relational data, optimized for analytical workloads and direct integration with Power BI. Azure Cosmos DB is a NoSQL database, not ideal for large-scale analytical processing with Power BI. Azure SQL Database and Azure Database for PostgreSQL are relational databases primarily designed for transactional workloads, not typically optimized for 20 TB of infrequently accessed analytical data.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed