DEA-C01 Drag & Drop — 10 Questions

Question 1

Arrange the steps to implement a data lake on Amazon S3 with AWS Lake Formation.

Accepted Answer

Create S3 bucket, then register it in Lake Formation, then set up administrators, then define schema in Glue Catalog, then grant access to users. Start by creating the S3 bucket. Then register it in Lake Formation, set up administrators, define the schema in Glue Catalog, and finally grant access to users.

Answer

Set up administrators, then create S3 bucket, then register it in Lake Formation, then define schema in Glue Catalog, then grant access to users

Answer

Create S3 bucket, then define schema in Glue Catalog, then register it in Lake Formation, then set up administrators, then grant access to users

Answer

Register S3 bucket in Lake Formation, then create S3 bucket, then set up administrators, then define schema in Glue Catalog, then grant access to users

Question 2

Arrange the steps to set up cross-region replication for an S3 bucket.

Accepted Answer

Enable versioning on source and destination, then create the destination bucket, then add a replication rule, then assign an IAM role.. First, enable versioning on source and destination. Then create the destination bucket, add a replication rule, and assign an IAM role for replication.

Answer

Create the destination bucket first, then enable versioning on source and destination, then add a replication rule, then assign an IAM role.

Answer

Enable versioning on source and destination, then add a replication rule, then create the destination bucket, then assign an IAM role.

Answer

Enable versioning on source and destination, then create the destination bucket, then assign an IAM role, then add a replication rule.

Question 3

Order the steps to set up an Amazon EMR cluster for processing data in S3 using Spark.

Accepted Answer

Prepare the S3 bucket, then launch the EMR cluster with Spark, then configure instances, then submit the job, then terminate the cluster.. First, prepare the S3 bucket. Then launch the EMR cluster with Spark, configure instances, submit the job, and terminate.

Answer

Launch the EMR cluster with Spark, then prepare the S3 bucket, then configure instances, then submit the job, then terminate the cluster.

Answer

Prepare the S3 bucket, then configure instances, then launch the EMR cluster with Spark, then submit the job, then terminate the cluster.

Answer

Submit the job, then launch the EMR cluster with Spark, then configure instances, then prepare the S3 bucket, then terminate the cluster.

Question 4

Arrange the steps to create an AWS Glue job that transforms data from Amazon S3 to Amazon Redshift in the correct order.

Accepted Answer

Step 1: Catalog the source data with a crawler. Step 2: Prepare the ETL script. Step 3: Configure the job with connections. Step 4: Run the job. Step 5: Verify the results in Amazon Redshift.. First, catalog the source data with a crawler. Then, prepare the ETL script. Configure the job with connections, run it, and finally verify the results in Redshift.

Answer

Step 1: Prepare the ETL script. Step 2: Catalog the source data with a crawler. Step 3: Configure the job with connections. Step 4: Run the job. Step 5: Verify the results in Amazon Redshift.

Answer

Step 1: Configure the job with connections. Step 2: Catalog the source data with a crawler. Step 3: Prepare the ETL script. Step 4: Run the job. Step 5: Verify the results in Amazon Redshift.

Answer

Step 1: Catalog the source data with a crawler. Step 2: Configure the job with connections. Step 3: Prepare the ETL script. Step 4: Run the job. Step 5: Verify the results in Amazon Redshift.

Question 5

Order the steps to migrate an on-premises database to Amazon RDS using AWS DMS.

Accepted Answer

Step 1: Create a replication instance. Step 2: Configure source and target endpoints. Step 3: Create a migration task. Step 4: Start the migration task. Step 5: Validate the migrated data.. First, create the replication instance. Then configure endpoints, create the migration task, start it, and finally validate the migrated data.

Answer

Step 1: Configure source and target endpoints. Step 2: Create a replication instance. Step 3: Create a migration task. Step 4: Start the migration task. Step 5: Validate the migrated data.

Answer

Step 1: Create a replication instance. Step 2: Create a migration task. Step 3: Configure source and target endpoints. Step 4: Start the migration task. Step 5: Validate the migrated data.

Answer

Step 1: Create a replication instance. Step 2: Configure source and target endpoints. Step 3: Start the migration task. Step 4: Create a migration task. Step 5: Validate the migrated data.

Question 6

Order the steps to troubleshoot a failed AWS Glue job that reads from JDBC and writes to S3.

Accepted Answer

Check AWS Glue job logs, then verify network connectivity, then verify IAM permissions, then test JDBC connection, then review the Glue script.. Start with logs to identify errors, then check connectivity, IAM permissions, test connection, and review script.

Answer

Verify IAM permissions, then check AWS Glue job logs, then verify network connectivity, then test JDBC connection, then review the Glue script.

Answer

Test JDBC connection, then check AWS Glue job logs, then verify network connectivity, then verify IAM permissions, then review the Glue script.

Answer

Review the Glue script, then check AWS Glue job logs, then verify network connectivity, then verify IAM permissions, then test JDBC connection.

Question 7

Order the steps to query data in Amazon Redshift Spectrum from an external table in Athena.

Accepted Answer

Create external schema in Redshift, then create external table, then grant permissions, then run the query, then verify results.. Start by creating the external schema in Redshift, then the external table, grant permissions, run the query, and verify results.

Answer

Run the query, then verify results, then create external table, then grant permissions, then create external schema.

Answer

Create external table, then create external schema, then grant permissions, then run the query, then verify results.

Answer

Create external schema, then create external table, then run the query, then grant permissions, then verify results.

Question 8

Arrange the steps to set up a streaming ETL pipeline using Amazon Kinesis Data Firehose to Amazon S3.

Accepted Answer

1. Create a Kinesis Data Firehose stream
2. Configure the data source
3. Set the S3 destination
4. Enable optional Lambda transformation
5. Test the pipeline. First, create the Firehose stream, configure source, set S3 destination, enable optional Lambda transformation, and test.

Answer

1. Configure the data source
2. Create a Kinesis Data Firehose stream
3. Enable optional Lambda transformation
4. Set the S3 destination
5. Test the pipeline

Answer

1. Create a Kinesis Data Firehose stream
2. Set the S3 destination
3. Configure the data source
4. Enable optional Lambda transformation
5. Test the pipeline

Answer

1. Configure the data source
2. Set the S3 destination
3. Create a Kinesis Data Firehose stream
4. Enable optional Lambda transformation
5. Test the pipeline

Question 9

Arrange the steps to implement data encryption at rest for an Amazon Redshift cluster using AWS KMS.

Accepted Answer

Step 1: Create a KMS key. Step 2: Launch a new Amazon Redshift cluster. Step 3: Enable encryption and specify the KMS key during launch. Step 4: Verify that the cluster is encrypted at rest.. First, create the KMS key. Then launch a new encrypted cluster, specify the key, configure, and verify encryption.

Answer

Step 1: Launch a new Amazon Redshift cluster. Step 2: Create a KMS key. Step 3: Enable encryption and specify the KMS key. Step 4: Verify encryption.

Answer

Step 1: Create a KMS key. Step 2: Verify encryption. Step 3: Launch a new Amazon Redshift cluster. Step 4: Enable encryption and specify the KMS key.

Answer

Step 1: Specify the KMS key. Step 2: Create a KMS key. Step 3: Launch a new Amazon Redshift cluster. Step 4: Verify encryption.

Question 10

Order the steps to set up a Kinesis Data Analytics application for real-time stream processing.

Accepted Answer

Step 1: Set up source stream; Step 2: Create analytics application; Step 3: Configure application with source and logic; Step 4: Start application; Step 5: Monitor performance. First, set up the source stream. Then create the analytics application, configure it with the source and logic, start it, and finally monitor performance.

Answer

Step 1: Create analytics application; Step 2: Configure application with source and logic; Step 3: Set up source stream; Step 4: Start application; Step 5: Monitor performance

Answer

Step 1: Set up source stream; Step 2: Create analytics application; Step 3: Start application; Step 4: Configure application with source and logic; Step 5: Monitor performance

Answer

Step 1: Set up source stream; Step 2: Create analytics application; Step 3: Configure application with source and logic; Step 4: Monitor performance; Step 5: Start application