Question 1

A high-traffic news website is experiencing performance issues due to frequent, read-heavy queries to their main database, which stores frequently accessed user session data and website preferences. To enhance the website's responsiveness and reduce database load, they require a caching solution that provides high throughput and low latency for data retrieval.

Which AWS service should the website implement to efficiently cache frequently accessed data and improve application performance?

Options :

A : Configure Amazon S3 with Amazon CloudFront for caching static user session data and website preferences.

B : Implement Amazon ElastiCache to cache frequent read-query results and reduce direct database queries.

C : Deploy Amazon Relational Database Service (RDS) with read replicas to distribute the load of read queries.

D : Deploy Amazon DynamoDB with DAX (DynamoDB Accelerator) for caching read-heavy query results.

Answer: B

Question 2

A Cloud Data Engineer is tasked with setting up a secure and reliable connection from an AWS-based analytics service to an on-premises Microsoft SQL Server database. The goal is to perform regular data import operations.

Which approach would be most effective and secure for accomplishing this task?

Options :

A : Configure an AWS Lambda function within the VPC to use a JDBC connection with the database credentials hard-coded for simplicity and speed.

B : Implement an AWS Direct Connect link between the on-premises network and AWS, and use a JDBC connection with database credentials stored in Amazon RDS.

C : Use AWS DataSync with an ODBC connection to the SQL Server, ensuring the connection over the internet is encrypted with TLS.

D : Establish a VPN connection between the on-premises network and AWS VPC, and then use JDBC with SSL encryption to connect to the SQL Server.

Answer: D

Question 3

A Data Engineering Team needs to help the security team to deliver logs from various AWS services in their production AWS account to a centralized logging AWS account for security analysis. They plan to use Amazon Kinesis Data Streams for real-time log processing and delivery.

To ensure secure and efficient log delivery between accounts, where should the Kinesis Data Stream be deployed and what security considerations should be taken into account?

Options :

A : Set up the Kinesis Data Stream in the production account and configure it to push logs directly to the centralized logging account.

B : Implement the Kinesis Data Stream in the production account and use AWS Lambda for cross-account delivery of logs to the centralized logging account.

C : Deploy the Kinesis Data Stream in the centralized logging account and establish cross-account access for the production account to write logs to the stream.

D : Deploy Kinesis Data Streams in both accounts, using one for collecting logs and the other for receiving and processing these logs.

Answer: C

Question 4

An analytics team frequently runs complex Amazon Athena queries on a dataset stored in an Amazon S3 bucket, with AWS Glue Data Catalog serving as the metadata repository. They've identified a slowdown in Athena query plans and attribute it to the excessive number of S3 partitions. The team needs to enhance query performance and reduce the time Athena takes in query planning.

Which two measures should the team take to meet these performance goals? (Select TWO.)

Options :

A : Implement AWS Glue Elastic Views to automate partition management.

B : Employ Athena-s partition projection for dynamic partitioning based on common query patterns.

C : Merge small S3 objects into larger ones using AWS Glue-s data transformation jobs.

D : Use Athena DML statements to reorganize data into fewer, more meaningful partitions.

E : Transform the data that is in the S3 bucket to Apache Parquet format.

Answer: B,E

Question 5

A Data Engineering team is tasked with selecting an appropriate compute service for a new application that processes streaming data. The application's load will be highly variable, often experiencing unpredictable spikes. The team must decide between using Amazon EC2 (a provisioned service) and AWS Lambda (a serverless service).

What are the key considerations they should evaluate in making this decision?

Options :

A : Choose Amazon EC2 because it provides the flexibility to customize the compute environment for specialized requirements, which could be critical for applications with streaming data.

B : Go with AWS Lambda for its ease of management and pay-as-you-go pricing model, which can be beneficial for applications with variable and unpredictable loads.

C : Opt for AWS Lambda due to its ability to automatically scale with the application-s load, offering a cost-effective solution for unpredictable, sporadic traffic patterns.

D : Select Amazon EC2 for its capacity to support more extended computing operations, which is typically needed for in-depth analysis and processing of streaming data.

Answer: C

Higher Test Marks with Free Online Data-Engineer-Associate Exam Practice

Buying Options: