DAS-C01 · Question #148
DAS-C01 Question #148: Real Exam Question with Answer & Explanation
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #148. The question stem and answer options stay visible for context.
Question
A large energy company is using Amazon QuickSight to build dashboards and report the historical usage data of its customers. This data is hosted in Amazon Redshift. The reports need access to all the fact tables' billions ot records to create aggregation in real time grouping by multiple dimensions. A data analyst created the dataset in QuickSight by using a SQL query and not SPICE Business users have noted that the response time is not fast enough to meet their needs. Which action would speed up the response time for the reports with the LEAST implementation effort?
Options
- AUse QuickSight to modify the current dataset to use SPICE
- BUse AWS Glue to create an Apache Spark job that joins the fact table with the dimensions.
- CUse Amazon Redshift to create a materialized view that joins the fact table with the dimensions
- DUse Amazon Redshift to create a stored procedure that joins the fact table with the dimensions.
Unlock DAS-C01 to see the answer
You've previewed enough free DAS-C01 questions. Unlock DAS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.