You work as a machine learning specialist for an auto manufacturer.
You are on a machine learning team that is responsible for analyzing the efficiency of potential electric car drive trains.
These drivetrains have explicit energy storage requirements (regenerative braking) to help with efficiency when driving in cities.
Your team is in the feature engineering phase of your model development.
You need to produce visualizations to get an idea of which features are useful and which can be improved using dimensionality reduction.
You have several data sources that you would like to visualize in your QuickSight environment.
Which of your data sources cannot be directly used as data sources in QuickSight?
Click on the arrows to vote for the correct answer
A. B. C. D.Correct Answer: A.
Option A is correct.
DynamoDb is not supported as a direct data source for QuickSight.
You need to use an intermediary service, such as Athena and its data source connectors, to make your DynamoDB table data available to QuickSight.
Option B is incorrect.
Snowflake is a supported data source for QuickSight.
Option C is incorrect.
Presto is a supported data source for QuickSight.
Option D is incorrect.
Teradata is a supported data source for QuickSight.
References:
Please see the Amazon QuickSight user guide titled Supported Data Sources (https://docs.aws.amazon.com/quicksight/latest/user/supported-data-sources.html),
The article titled GETTING TO THE HEART OF EVS: A CLOSE-UP LOOK AT THE ELECTRIC DRIVETRAIN (https://www.innovativeautomation.com/the-electric-vehicle-drivetrain/),
The AWS Big Data blog titled Accessing and visualizing data from multiple data sources with Amazon Athena and Amazon QuickSight, (https://aws.amazon.com/blogs/big-data/accessing-and-visualizing-data-from-multiple-data-sources-with-amazon-athena-and-amazon-quicksight/)
QuickSight is a cloud-based business analytics service that provides users with visualizations, dashboards, and reports to analyze and gain insights from their data. QuickSight supports a wide range of data sources, including on-premises databases, cloud-based data warehouses, and various cloud storage services.
To answer the question, we need to identify the data source that cannot be directly used as a data source in QuickSight.
A. DynamoDB: DynamoDB is a fully managed NoSQL database service provided by AWS. QuickSight natively supports DynamoDB as a data source, and users can directly connect to DynamoDB tables and visualize the data.
B. Snowflake: Snowflake is a cloud-based data warehousing platform. QuickSight supports Snowflake as a data source, and users can directly connect to Snowflake data warehouses and visualize the data.
C. Presto: Presto is an open-source distributed SQL query engine used to query data from various data sources. QuickSight supports Presto as a data source, and users can connect to Presto clusters and visualize the data.
D. Teradata: Teradata is a popular data warehousing platform used to store and manage large-scale data. Unfortunately, QuickSight does not natively support Teradata as a data source, and users cannot directly connect to Teradata. However, Teradata can be integrated with QuickSight using a custom JDBC driver.
Therefore, the answer is D. Teradata.