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

The correct answer is A. Azure Data Lake C. Azure SQL Data Warehouse. You can use Power BI to analyze and visualize data stored in Azure Data Lake and Azure SQL Azure Data Lake includes all of the capabilities required to make it easy for developers, data scientists and analysts to store data of any size and shape and at any speed, and do all types

Submitted by renata2k· Mar 5, 2026Describe Azure architecture and services

Question

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.

Options

AAzure Data Lake
BAzure Cosmos DB
CAzure SQL Data Warehouse
DAzure SQL Database
EAzure Database for PostgreSQL

How the community answered

(40 responses)

A
83% (33)
B
5% (2)
D
10% (4)
E
3% (1)

Explanation

You can use Power BI to analyze and visualize data stored in Azure Data Lake and Azure SQL Azure Data Lake includes all of the capabilities required to make it easy for developers, data scientists and analysts to store data of any size and shape and at any speed, and do all types of processing and analytics across platforms and languages. It removes the complexities of ingesting and storing all your data while making it faster to get up and running with batch, streaming and interactive analytics. It also integrates seamlessly with operational stores and data warehouses so that you can extend current data applications. https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-power-bi https://azure.microsoft.com/en-gb/solutions/data-lake/

Community Discussion

No community discussion yet for this question.

Full AZ-900 Practice