QUESTION: 93

An online retail company has an application that runs on Amazon EC2 instances that are in a VPC. The company wants to collect flow logs for the VPC and analyze network traffic.
Which solution will meet these requirements MOST cost-effectively?

Publish flow logs to Amazon CloudWatch Logs. Use Amazon Athena for analytics.
Publish flow logs to Amazon CloudWatch Logs. Use an Amazon OpenSearch Service cluster for analytics.
Publish flow logs to Amazon S3 in text format. Use Amazon Athena for analytics.
Publish flow logs to Amazon S3 in Apache Parquet format. Use Amazon Athena for analytics.

Answer(s): D

Reveal Solution Next Question

QUESTION: 94

A retail company stores transactions, store locations, and customer information tables in four reserved ra3.4xlarge Amazon Redshift cluster nodes. All three tables use even table distribution.
The company updates the store location table only once or twice every few years.
A data engineer notices that Redshift queues are slowing down because the whole store location table is constantly being broadcast to all four compute nodes for most queries. The data engineer wants to speed up the query performance by minimizing the broadcasting of the store location table.
Which solution will meet these requirements in the MOST cost-effective way?

Change the distribution style of the store location table from EVEN distribution to ALL distribution.
Change the distribution style of the store location table to KEY distribution based on the column that has the highest dimension.
Add a join column named store_id into the sort key for all the tables.
Upgrade the Redshift reserved node to a larger instance size in the same instance family.

Answer(s): A

Reveal Solution Next Question

QUESTION: 95

A company has a data warehouse that contains a table that is named Sales. The company stores the table in Amazon Redshift. The table includes a column that is named city_name. The company wants to query the table to find all rows that have a city_name that starts with "San" or "El".
Which SQL query will meet this requirement?

Select * from Sales where city_name ~ ‘$(San|El)*’;
Select * from Sales where city_name ~ ‘^(San|El)*’;
Select * from Sales where city_name ~’$(San&El)*’;
Select * from Sales where city_name ~ ‘^(San&El)*’;

Answer(s): B

Reveal Solution Next Question

QUESTION: 96

A company needs to send customer call data from its on-premises PostgreSQL database to AWS to generate near real-time insights. The solution must capture and load updates from operational data stores that run in the PostgreSQL database. The data changes continuously.
A data engineer configures an AWS Database Migration Service (AWS DMS) ongoing replication task. The task reads changes in near real time from the PostgreSQL source database transaction logs for each table. The task then sends the data to an Amazon Redshift cluster for processing.
The data engineer discovers latency issues during the change data capture (CDC) of the task. The data engineer thinks that the PostgreSQL source database is causing the high latency.
Which solution will confirm that the PostgreSQL database is the source of the high latency?

Use Amazon CloudWatch to monitor the DMS task. Examine the CDCIncomingChanges metric to identify delays in the CDC from the source database.
Verify that logical replication of the source database is configured in the postgresql.conf configuration file.
Enable Amazon CloudWatch Logs for the DMS endpoint of the source database. Check for error messages.
Use Amazon CloudWatch to monitor the DMS task. Examine the CDCLatencySource metric to identify delays in the CDC from the source database.

Answer(s): D

Reveal Solution Next Question

Free DEA-C01 Exam Braindumps (page: 25)

QUESTION: 93

QUESTION: 94

QUESTION: 95

QUESTION: 96

DEA-C01 Discussions & Posts