Task 3.2: Analyze Data by Using AWS Services DEA-C01 Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   A data engineer needs to create an interactive dashboard with drill-down capabilities for business stakeholders. The data is stored in Amazon S3 and needs to be visualized without building a custom web application. Which AWS service is designed for this purpose?

   • AAmazon Athena
   • BAmazon QuickSight
   • CAWS Glue DataBrew
   • DAWS Lambda
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   A data engineer wants to create a logical table in Amazon Athena that represents a filtered subset of data from an existing table, so that analysts can query the subset without repeating the filter condition. Which SQL statement should be used?

   • ACREATE DATABASE
   • BCREATE TABLE
   • CCREATE INDEX
   • DCREATE VIEW
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A data engineer is querying a large dataset in Amazon Athena. The dataset contains sales records with columns: 'order_id', 'customer_id', 'order_date', and 'order_amount'. The engineer needs to find the total order amount for each customer. Which SQL query should the engineer run?

   • ASELECT customer_id, AVG(order_amount) AS total_amount FROM sales GROUP BY customer_id;
   • BSELECT customer_id, COUNT(order_amount) AS total_amount FROM sales GROUP BY customer_id;
   • CSELECT customer_id, SUM(order_amount) AS total_amount FROM sales GROUP BY customer_id;
   • DSELECT customer_id, order_amount FROM sales;
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   A data engineer needs to smooth out short-term fluctuations in a time series of daily website traffic to identify longer-term trends. Which technique should the engineer use?

   • ARolling average
   • BData grouping
   • CData aggregation
   • DData pivoting
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   A data engineer is comparing Amazon Redshift (provisioned) and Amazon Athena (serverless) for running SQL queries. Which statement accurately describes a key difference between these two services?

   • ARedshift requires you to provision and manage a cluster, while Athena is serverless and requires no infrastructure management.
   • BBoth Redshift and Athena are serverless services that require no infrastructure management.
   • CBoth Redshift and Athena are provisioned services that require you to manage clusters.
   • DAthena requires you to provision and manage a cluster, while Redshift is serverless and requires no infrastructure management.
   Reveal Solution Discussion Select an answer first