exam questions

Exam AZ-900 All Questions

View all questions & answers for the AZ-900 exam

Exam AZ-900 topic 1 question 160 discussion

Actual exam question from Microsoft's AZ-900
Question #: 160
Topic #: 1
[All AZ-900 Questions]

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.

  • A. Azure Data Lake
  • B. Azure Cosmos DB
  • C. Azure SQL Data Warehouse
  • D. Azure SQL Database
  • E. Azure Database for PostgreSQL
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
[Removed]
Highly Voted 4 years, 7 months ago
Azure SQL Data Warehouse is now Azure Synapse Analytics can you please change it in the options.
upvoted 172 times
marttcore
1 year, 5 months ago
"few years later..."
upvoted 24 times
...
...
[Removed]
Highly Voted 4 years, 11 months ago
Azure Data Lake integration features https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-and-azure-data-lake-storage-gen2-integration-preview/ Azure SQL Data Warehouse integration features https://powerbi.microsoft.com/en-us/integrations/azure-sql-data-warehouse/
upvoted 56 times
...
Amineelk
Most Recent 9 months, 3 weeks ago
Selected Answer: AC
"A and C"
upvoted 1 times
...
MissLuka
1 year, 8 months ago
I just passed, this question appeared on my exam, there were a lot of questions from examtopic a few new and a few which were changed a bit
upvoted 12 times
...
ganeriwal
1 year, 9 months ago
Selected Answer: AC
A and C
upvoted 3 times
...
buiducvu
1 year, 11 months ago
Selected Answer: AC
A and C
upvoted 2 times
...
Billy235
2 years, 2 months ago
This has been removed from syllabus as of May 2022 refresh?
upvoted 4 times
semauni
1 year, 6 months ago
Someone apparently had this question on their exam two months ago.
upvoted 1 times
...
...
Pa1theAchiever
2 years, 5 months ago
A and C
upvoted 2 times
...
cuentaalternajsr
2 years, 6 months ago
Synapse y Data Lake.
upvoted 3 times
...
Saurabh2102
2 years, 6 months ago
Correct answers are 'A' and 'C', Keywords to identify answers are 20TB(Big data), and it will be accessed infrequently(Data Warehouse).
upvoted 12 times
...
JKRowlings
2 years, 7 months ago
A and C are the answers. They provide solutions for Big Data.
upvoted 2 times
...
Monster5566
2 years, 7 months ago
https://azure.microsoft.com/zh-tw/solutions/data-lake/ https://docs.microsoft.com/zh-tw/azure/data-lake-store/data-lake-store-power-bi https://docs.microsoft.com/zh-tw/azure/architecture/data-guide/relational-data/data-warehousing
upvoted 1 times
...
Custodian
2 years, 8 months ago
Azure SQL Data Warehouse is now called: SQL Pool https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is
upvoted 4 times
...
Official
2 years, 9 months ago
Selected Answer: AC
A and C
upvoted 2 times
...
deanbox
2 years, 10 months ago
Selected Answer: AC
Correct Ans is A and C
upvoted 2 times
...
gld2
2 years, 10 months ago
https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources
upvoted 3 times
sideque
1 year, 8 months ago
According to this link, PowerBI can connect to Azure Cosmos DB, Azure Data Lake, Azure SQL Database, Azure Synapse. The answer of A and C is wrong
upvoted 1 times
NoursBear
1 month, 4 weeks ago
Azure Synaptics is the new name for Data Warehouse so correct
upvoted 1 times
...
semauni
1 year, 6 months ago
I think the question is outdated anyways
upvoted 1 times
...
semauni
1 year, 6 months ago
There is something about 'accessed infrequently' that we appear to be missing, as there is a comment here from someone who says that they had this question on their exam two months ago. So it's not outdated (ignore my other comment).
upvoted 1 times
...
...
...
nav777
2 years, 10 months ago
Correct Ans is A and C
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...