AWS QuickSight Data Joining and Access with Aurora | MSP Bank Limited

AWS QuickSight Data Joining and Access with Aurora

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. Using QuickSight, dataset is being created based on their existing RDS data source.

Multiple tables have been identified which needs to be joined and accessed.

Team is evaluating if they can join this data from another Aurora database.

Please advise the team what can be achieved. select 4 options.

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D. E. F. G.

Answer: A,C, E,F.

Option A is correct -Both data sets are based on the same SQL database data source.

https://docs.aws.amazon.com/quicksight/latest/user/joining-tables.html

Option B is incorrect -Both data sets are based on the same SQL database data source.

https://docs.aws.amazon.com/quicksight/latest/user/joining-tables.html

Option C is correct -To join tables from different data sources, create the join before importing to Amazon QuickSight.

https://docs.aws.amazon.com/quicksight/latest/user/joining-tables.html

Option D is incorrect -QuickSight does not provide this facility.

https://docs.aws.amazon.com/quicksight/latest/user/joining-tables.html

Option E is correct -QuickSight allows configure join type, can be inner, outer, left, right.

https://docs.aws.amazon.com/quicksight/latest/user/joining-tables.html

Option F is correct -If you chose a table and made changes to the fields (for example, changing a field name or adding a calculated field), these changes are discarded when you add tables using the join interface.

https://docs.aws.amazon.com/quicksight/latest/user/joining-tables.html

Option G is incorrect - If you chose a table and made changes to the fields (for example, changing a field name or adding a calculated field), these changes are discarded when you add tables using the join interface.

https://docs.aws.amazon.com/quicksight/latest/user/joining-tables.html

The team is evaluating the feasibility of joining data from another Aurora database with their existing RDS data source on QuickSight. Based on this scenario, we can provide the following explanations to the team:

A. Both data sets are based on the same SQL database data source: This is not relevant to the scenario because the team is trying to join data from different SQL data sources.

B. Both data sets are not required to be on the same SQL database data source: This is correct. QuickSight allows users to join data from different SQL data sources. Hence, the team can join data from the RDS data source and Aurora database.

C. To join tables from different data sources, create the join before importing to Amazon QuickSight: This is correct. To join tables from different data sources, users must create the join before importing the data into QuickSight.

D. QuickSight provides facility to join tables from different data sources: This is correct. QuickSight provides users with the ability to join tables from different data sources.

E. QuickSight allows configure join type: This is correct. QuickSight allows users to configure the join type (such as inner join, left join, right join, etc.) when joining tables from different data sources.

F. If you chose a table and made changes to the fields (for example, changing a field name or adding a calculated field), these changes are discarded when you add tables using the join interface: This is not correct. If the team made changes to the fields of a table, these changes are accepted when joining tables from different data sources.

G. If you chose a table and made changes to the fields (for example, changing a field name or adding a calculated field), these changes are accepted even when you add tables using the join interface: This is correct. If the team made changes to the fields of a table, these changes are accepted when joining tables from different data sources.

In summary, the team can join data from different SQL data sources using QuickSight. They must create the join before importing the data into QuickSight and can configure the join type. Also, any changes made to the fields of a table are accepted when joining tables from different data sources.