Data-Engineer-Associate Practice Questions

A.  

Use Amazon S3 for data lake storage. Use S3 access policies to restrict data access by rows and columns. Provide data access through Amazon S3.

B.  

Use Amazon S3 for data lake storage. Use Apache Ranger through Amazon EMR to restrict data access by rows and columns. Provide data access by using Apache Pig.

C.  

Use Amazon Redshift for data lake storage. Use Redshift security policies to restrict data access by rows and columns. Provide data access by using Apache Spark and Amazon Athena federated queries.

D.  

Use Amazon S3 for data lake storage. Use AWS Lake Formation to restrict data access by rows and columns. Provide data access through AWS Lake Formation.

A.  

Option A

B.  

Option B

C.  

Option C

D.  

Option D

A.  

Establish WebSocket connections to Amazon Redshift.

B.  

Use the Amazon Redshift Data API.

C.  

Set up Java Database Connectivity (JDBC) connections to Amazon Redshift.

D.  

Store frequently accessed data in Amazon S3. Use Amazon S3 Select to run the queries.

A.  

Create a separate Redshift cluster for each team. Load only the required data for each team. Restrict access to clusters based on the teams.

B.  

Create views that include required fields for each of the data requirements. Grant the teams access only to the view that each team requires.

C.  

Create a separate Amazon Redshift database role for each team. Define masking policies that apply for each team separately. Attach appropriate masking policies to each team role.

D.  

Move the customer data to an Amazon S3 bucket. Use AWS Lake Formation to create a data lake. Use fine-grained security capabilities to grant each team appropriate permissions to access the data.

A.  

Generate new SSH keys for the Transfer Family server. Make the old keys and the new keys available for use.

B.  

Update the security group rules for the on-premises network to allow only connections that use TLS 1.2 or above.

C.  

Update the security policy of the Transfer Family server to specify a minimum protocol version of TLS 1.2.

D.  

Install an SSL certificate on the Transfer Family server to encrypt data transfers by using TLS 1.2.

A.  

Create an AWS Lambda function that connects to Amazon Redshift and runs a COPY command. Use Amazon EventBridge to invoke the Lambda function based on an Amazon S3 upload trigger.

B.  

Create an Amazon Data Firehose stream. Configure the stream to use an AWS Lambda function as a source to pull data from the S3 bucket. Set Amazon Redshift as the destination.

C.  

Use Amazon Redshift Spectrum to query the S3 bucket. Configure an AWS Glue Crawler for the S3 bucket to update metadata in an AWS Glue Data Catalog.

D.  

Creates an AWS Database Migration Service (AWS DMS) task. Specify an appropriate data schema to migrate. Specify the appropriate type of migration to use.

A.  

Create an S3 bucket policy to limit the access each application has. Create multiple copies of the dataset. Give each dataset copy the appropriate level of redaction for the needs of the application that accesses the copy.

B.  

Create an S3 Object Lambda endpoint. Use the S3 Object Lambda endpoint to read data from the S3 bucket. Implement redaction logic within an S3 Object Lambda function to dynamically redact PII based on the needs of each application that accesses the data.

C.  

Use AWS Glue to transform the data for each application. Create multiple copies of the dataset. Give each dataset copy the appropriate level of redaction for the needs of the application that accesses the copy.

D.  

Create an API Gateway endpoint that has custom authorizers. Use the API Gateway endpoint to read data from the S3 bucket. Initiate a REST API call to dynamically redact PII based on the needs of each application that accesses the data.

A.  

Design the application so it can remove duplicates during processing by embedding a unique ID in each record at the source.

B.  

Update the checkpoint configuration of the Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) data collection application to avoid duplicate processing of events.

C.  

Design the data source so events are not ingested into Kinesis Data Streams multiple times.

D.  

Stop using Kinesis Data Streams. Use Amazon EMR instead. Use Apache Flink and Apache Spark Streaming in Amazon EMR.

A.  

Enable DynamoDB TTL on the DynamoDB table. Adjust the application source code to set the TTL attribute appropriately.

B.  

Create an Amazon EventBridge rule that uses a daily cron expression to trigger an AWS Lambda function to delete items that are older than the specified age.

C.  

Add a lifecycle configuration to the DynamoDB table that deletes items that are older than the specified age.

D.  

Create a DynamoDB stream that has an AWS Lambda function that reacts to data modifications. Configure the Lambda function to delete items that are older than the specified age.

A.  

Use AWS Glue Data Catalog to generate column-level statistics for the Iceberg tables on a schedule.

B.  

Use AWS Glue Data Catalog to automatically compact the Iceberg tables.

C.  

Use AWS Glue Data Catalog to automatically optimize indexes for the Iceberg tables.

D.  

Use AWS Glue Data Catalog to enable copy-on-write for the Iceberg tables.

E.  

Use AWS Glue Data Catalog to generate views for the Iceberg tables.