Limitations of QuickSight Data Repositories for MSP Bank on AWS
Question
MSP Bank, Limited is a leading Japanese monetary institution that provides a full range of financial products and services to both institutional and individual customers.
It is headquartered in Tokyo.
MSP Bank is hosting their existing infrastructure on AWS.
MSP bank has many organizations internally and they are planning to launch a self-data discovery platform running out of AWS on QuickSight. Data is spread across multiple data repositories on AWS.
Which data repositories cannot be directly connected by QuickSight to build a Dataset? Select 3 options.
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D. E. F. G.Answer: C,E,F.
The following data sources can be connected through QuickSight
https://docs.aws.amazon.com/quicksight/latest/user/supported-data-sources.htmlQuickSight is a business analytics service that provides an easy-to-use interface to build visualizations, perform ad-hoc analysis, and quickly get business insights from different data sources. When it comes to connecting to data sources, QuickSight provides a wide range of connectors for various data sources, including Amazon S3, Amazon Redshift, Amazon Aurora, Amazon Athena, Amazon RDS, and more.
However, there are certain data repositories that cannot be directly connected by QuickSight to build a Dataset. Here are the explanations for the options provided:
A. Amazon Aurora: Amazon Aurora is a MySQL and PostgreSQL compatible relational database built for the cloud. QuickSight can connect to Aurora, and you can create datasets from Aurora tables and use them in your analyses and visualizations.
B. Amazon Redshift: Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and existing Business Intelligence tools. QuickSight can connect to Amazon Redshift, and you can create datasets from Redshift tables and use them in your analyses and visualizations.
C. Amazon Neptune: Amazon Neptune is a fast, reliable, fully-managed graph database service that makes it easy to build and run applications that work with highly connected datasets. QuickSight cannot connect to Amazon Neptune directly to build a Dataset.
D. Amazon Redshift Spectrum: Amazon Redshift Spectrum allows you to run SQL queries against exabytes of data in Amazon S3, with no loading or ETL required. QuickSight can connect to Amazon Redshift Spectrum, and you can create datasets from Redshift Spectrum tables and use them in your analyses and visualizations.
E. Amazon DynamoDB: Amazon DynamoDB is a fast and flexible NoSQL database service for all applications that need consistent, single-digit millisecond latency at any scale. QuickSight cannot connect to Amazon DynamoDB directly to build a Dataset.
F. Amazon Elasticsearch: Amazon Elasticsearch is a managed service that makes it easy to deploy, operate, and scale Elasticsearch clusters in the AWS Cloud. QuickSight can connect to Amazon Elasticsearch, and you can create datasets from Elasticsearch indexes and use them in your analyses and visualizations.
G. CSV/TSV files in S3: QuickSight can connect to CSV/TSV files in Amazon S3, and you can create datasets from these files and use them in your analyses and visualizations.
H. XLSX/ELF/CLF files in S3: QuickSight can connect to XLSX/ELF/CLF files in Amazon S3, and you can create datasets from these files and use them in your analyses and visualizations.
Therefore, the three data repositories that cannot be directly connected by QuickSight to build a Dataset are Amazon Neptune, Amazon DynamoDB, and XLSX/ELF/CLF files in S3.
