DEA-C01 mock exam

Question 1, Data Ingestion and TransformationYou need to deliver streaming clickstream data to S3 with no consumer code to maintain. What fits best?

• AAmazon EBS snapshots
• BA nightly AWS Glue crawler
• CAmazon Data Firehose
• DA self-managed Kafka cluster on EC2

Question 2, Data Ingestion and TransformationSeveral independent applications must read the same stream with low latency and replay older records. What should you pick?

• AAmazon Kinesis Data Streams
• BAWS Glue streaming crawlers
• CAmazon Athena federated queries
• DAmazon SQS standard queues

Question 3, Data Store ManagementAthena queries on a large S3 dataset are slow and expensive. What usually helps most?

• AConvert to partitioned Parquet
• BStore the data as larger CSV files
• CMove the data to EBS
• DIncrease Lambda memory

Question 4, Data Store ManagementRarely read data older than 90 days should cost less, automatically. What do you configure?

• AA Glue crawler
• BA larger Redshift cluster
• CAn EventBridge schedule that deletes data
• DAn S3 Lifecycle rule to a colder storage class

Question 5, Data Store ManagementYou need to load large files from S3 into Amazon Redshift quickly. What is the recommended way?

• ALambda calling SELECT in a loop
• BAthena CTAS into S3
• CMany single-row INSERT statements
• DThe COPY command

Question 6, Data Operations and SupportA multi-step pipeline has branching and retries, and you want a managed, visual workflow. What do you use?

• AAmazon S3 Select
• BAmazon Route 53
• CAWS KMS
• DAWS Step Functions

Question 7, Data Operations and SupportBad records keep reaching downstream tables, and you want rules checked in the pipeline. What fits?

• AAmazon CloudFront
• BAWS Glue Data Quality
• CA bigger EMR cluster
• DAWS Budgets

Question 8, Data Security and GovernanceAnalysts need column-level access to data lake tables, managed centrally. What do you use?

• AAWS Lake Formation permissions
• BS3 bucket policies per object
• CSecurity groups
• DA shared IAM user