Store Data in Azure: Infrequent Access | Power BI Visualization
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.
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D. E.AC
You can use Power BI to analyze and visualize data stored in Azure Data Lake and Azure SQL Data Warehouse.
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/ https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-power-biFor storing 20 TB of data in Azure that will be accessed infrequently and visualized using Power BI, the recommended storage solution would be a cost-effective, scalable, and secure solution.
Out of the given options, the two recommended solutions for this scenario are:
A. Azure Data Lake: Azure Data Lake is a highly scalable and cost-effective data lake solution that enables storage and analysis of big data. It is suitable for storing large amounts of unstructured or semi-structured data, and it provides enterprise-grade security features to ensure data privacy and compliance. Data can be accessed using a variety of tools, including Power BI. Azure Data Lake is also capable of handling large files, making it a suitable option for storing 20 TB of data.
C. Azure SQL Data Warehouse: Azure SQL Data Warehouse is a cloud-based data warehousing solution that provides scalable and secure storage for structured data. It is optimized for analytics workloads and can handle large volumes of data. Data can be accessed using a variety of tools, including Power BI. It also supports columnstore indexes, which can improve query performance for large datasets.
B, D, and E are not suitable solutions for storing 20 TB of infrequently accessed data that will be visualized using Power BI.
Azure Cosmos DB is a NoSQL database service that is designed for fast and scalable applications. It is more suitable for transactional workloads and real-time applications that require low latency.
Azure SQL Database is a cloud-based relational database service that provides scalable and secure storage for structured data. It is optimized for transactional workloads and is not suitable for storing large volumes of infrequently accessed data.
Azure Database for PostgreSQL is a managed PostgreSQL database service that is suitable for transactional workloads and is not optimized for analytics workloads.
Therefore, the correct answers for this scenario are A. Azure Data Lake and C. Azure SQL Data Warehouse.
