Free Amazon AWS-DEA-C01 Exam Questions

Question 1

A company needs to load customer data that comes from a third party into an Amazon Redshift datawarehouse. The company stores order data and product data in the same data warehouse. The company wantsto use the combined dataset to identify potential new customers.A data engineer notices that one of the fields in the source data includes values that are in JSON format.How should the data engineer load the JSON data into the data warehouse with the LEAST effort?

A : Use the SUPER data type to store the data in the Amazon Redshift table.

B : Use AWS Glue to flatten the JSON data and ingest it into the Amazon Redshift table.

C : Use Amazon S3 to store the JSON data. Use Amazon Athena to query the data.

D : Use an AWS Lambda function to flatten the JSON data. Store the data in Amazon S3.

Answer: A

Question 2

A data engineer has two datasets that contain sales information for multiple cities and states. One dataset is named reference, and the other dataset is named primary. The data engineer needs a solution to determine whether a specific set of values in the city and state columns of the primary dataset exactly match the same specific values in the reference dataset. The data engineer wants to use Data Quality Definition Language (DQDL) rules in an AWS Glue Data Quality job. Which rule will meet these requirements?

A : DatasetMatch "reference" "city->ref_city, state->ref_state" = 1.0

B : ReferentialIntegrity "city,state" "reference.{ref_city,ref_state}" = 1.0

C : DatasetMatch "reference" "city->ref_city, state->ref_state" = 100

D : ReferentialIntegrity "city,state" "reference.{ref_city,ref_state}" = 100

Answer: A

Question 3

A company has a production AWS account that runs company workloads. The company's security team

created a security AWS account to store and analyze security logs from the production AWS account. The

security logs in the production AWS account are stored in Amazon CloudWatch Logs.

The company needs to use Amazon Kinesis Data Streams to deliver the security logs to the security AWS

account.

Which solution will meet these requirements?

A : Create a destination data stream in the production AWS account. In the security AWS account, create an IAM role that has cross-account permissions to Kinesis Data Streams in the production AWS account.

B : Create a destination data stream in the security AWS account. Create an IAM role and a trust policy to grant CloudWatch Logs the permission to put data into the stream. Create a subscription filter in the security AWS account.

C : Create a destination data stream in the production AWS account. In the production AWS account, create an IAM role that has cross-account permissions to Kinesis Data Streams in the security AWS account

D : Create a destination data stream in the security AWS account. Create an IAM role and a trust policy to grant CloudWatch Logs the permission to put data into the stream. Create a subscription filter in the production AWS account.

Answer: D

Question 4

A Cloud Data Engineering Consultant has been tasked with organizing access control for a team of analysts using an Amazon Redshift data warehouse. The team requires varying levels of access to sensitive financial data for reporting and analysis. The consultants need to define a strategy that provides the necessary access for the analysts to perform their duties while ensuring that principles of least privilege and data governance are upheld.

Which of the following actions should the consultant take to appropriately manage user access and permissions within the Amazon Redshift database? (Select TWO)

A : Implement row-level security within Redshift tables to control access to rows of data based on user roles, ensuring analysts only see data relevant to their analysis.

B : Grant superuser privileges to all analysts to ensure they have the ability to query all necessary tables within the Redshift cluster, then audit queries periodically for compliance.

C : Enable Amazon Redshift Spectrum to manage external tables and use IAM policies to grant access to these tables.

D : Set up database groups within Redshift and assign users to groups based on their access requirements, then grant group-specific permissions to the relevant schemas and tables.

E : Create individual IAM users for each analyst with attached policies that define the level of access to Redshift resources, and use those IAM users for database authentication.

Answer: A,D

Question 5

Files from multiple data sources arrive in an Amazon S3 bucket on a regular basis. A data engineer wants to ingest new files into Amazon Redshift in near real time when the new files arrive in the S3 bucket. Which solution will meet these requirements?

A : Use the query editor v2 to schedule a COPY command to load new files into Amazon Redshift.

B : Use the zero-ETL integration between Amazon Aurora and Amazon Redshift to load new files into Amazon Redshift.

C : Use AWS Glue job bookmarks to extract, transform, and load (ETL) load new files into Amazon Redshift.

D : Use S3 Event Notifications to invoke an AWS Lambda function that loads new files into Amazon Redshift.

Answer: D