AWS Certified Big Data - Specialty Exam: MSP Bank Case Study
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 segments internally and they are planning to launch a self-data discovery platform running out of AWS on QuickSight. Using QuickSight, multiple datasets are created and multiple analyses are generated respectively.
The Team identified multiple datasets both dependent and not dependent on SPICE that needs to be refreshed.
Team is evaluating the options.
Please Advice! select 6 options.
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D. E. F. G.Answer: A,B,D,E,G,H.
Option A is correct -Refresh a SPICE Data Set from the Your Data Sets Page is allowed.
https://docs.aws.amazon.com/quicksight/latest/user/refreshing-imported-data.html#refresh-Option B is correct - Refresh a SPICE Data Set During Data Preparation is allowed.
https://docs.aws.amazon.com/quicksight/latest/user/refreshing-imported-data.htmlOption C is incorrect - Refresh a SPICE Data Set During Data Analysis is not allowed.
Instead, Refresh a Data Set During Data Preparation is allowed.
https://docs.aws.amazon.com/quicksight/latest/user/refreshing-imported-data.htmlOption D is correct -Refresh a SPICE Data Set on a Schedule.
https://docs.aws.amazon.com/quicksight/latest/user/refreshing-imported-data.htmlOption E is correct -To refresh file-based data, you must delete and recreate the data set.
https://docs.aws.amazon.com/quicksight/latest/user/refreshing-imported-data.htmlOption F is incorrect -To refresh file-based data, you must delete and recreate the data set.
https://docs.aws.amazon.com/quicksight/latest/user/refreshing-imported-data.htmlOption G is correct -To refresh data from a database, reopen your data set or the visualization you created.
https://docs.aws.amazon.com/quicksight/latest/user/refreshing-imported-data.htmlOption H is correct - To refresh data from a database, reopen your data set or the visualization you created.
https://docs.aws.amazon.com/quicksight/latest/user/refreshing-imported-data.htmlMSP Bank is planning to launch a self-data discovery platform running out of AWS on QuickSight. QuickSight is a business intelligence service that allows users to create and publish interactive dashboards and reports.
Multiple datasets have been created and multiple analyses have been generated using QuickSight. The team has identified multiple datasets that need to be refreshed, some of which are dependent on SPICE.
SPICE is the Super-fast, Parallel, In-memory Calculation Engine used by Amazon QuickSight to provide fast and responsive query performance.
To refresh a SPICE data set, there are several options available:
A. Refresh a SPICE Data Set from the Your Data Sets Page: This option allows you to manually refresh the SPICE data set from the Your Data Sets page in the QuickSight console. This option is suitable for ad hoc refreshes or when you need to manually refresh a data set.
B. Refresh a SPICE Data Set During Data Preparation: This option allows you to refresh the SPICE data set during data preparation. This option is useful when you want to refresh the data set before performing any analysis.
C. Refresh a SPICE Data Set During Data Analysis: This option allows you to refresh the SPICE data set during data analysis. This option is useful when you want to refresh the data set after performing some analysis.
D. Refresh a SPICE Data Set on a Schedule: This option allows you to schedule regular refreshes of the SPICE data set. This option is suitable when you have a data set that requires frequent updates.
E. To Refresh file-based data, you must delete and recreate the data set: This option is suitable when you have file-based data that needs to be refreshed. To refresh file-based data, you must delete the existing data set and recreate it with the updated data.
F. To refresh file-based data, you must copy the new dataset onto the old data set: This option is suitable when you have file-based data that needs to be refreshed. To refresh file-based data, you must copy the updated data onto the existing data set.
G. To refresh data from a database, reopen your data set: This option is suitable when you have data from a database that needs to be refreshed. To refresh data from a database, you must reopen the data set in QuickSight.
H. To refresh data from a database, reopen the visualization: This option is suitable when you have data from a database that needs to be refreshed. To refresh data from a database, you must reopen the visualization in QuickSight.
In summary, QuickSight provides several options to refresh SPICE data sets and file-based or database-based data. The appropriate option depends on the data set and the desired refresh frequency.
