A company needs to store 2 TB worth of data that is infrequently used. The data needs to be accessed via Power BI. Which of the following could be used as a cost-effective data layer for this requirem

The correct answer is D. Azure Data Lake. If you are looking at storing data that is not frequently used, you can use the Azure Data Lake You should use Azure SQL, Azure PostgreSQL or Cosmos DB for frequently accessed data. https://docs.microsoft.com/en-us/power-bi/service-dataflows-connect-azure-data-lake-storage-

Submitted by skyler.x· Mar 5, 2026Describe Azure Architecture and Services

Question

A company needs to store 2 TB worth of data that is infrequently used. The data needs to be accessed via Power BI. Which of the following could be used as a cost-effective data layer for this requirement?

Exhibit

Options

AAzure SQL databases
BAzure PostgreSQL
CAzure Cosmos DB
DAzure Data Lake

How the community answered

(41 responses)

A
5% (2)
B
12% (5)
C
2% (1)
D
80% (33)

Explanation

If you are looking at storing data that is not frequently used, you can use the Azure Data Lake You should use Azure SQL, Azure PostgreSQL or Cosmos DB for frequently accessed data. https://docs.microsoft.com/en-us/power-bi/service-dataflows-connect-azure-data-lake-storage-

Community Discussion

No community discussion yet for this question.

Full AZ-900 Practice