Free Amazon AWS-DEA-C01 Exam Questions

Question 1

A company has as JSON file that contains personally identifiable information (PIT) data and non-PII data. The company needs to make the data available for querying and analysis. The non-PII data must be available to everyone in the company. The PII data must be available only to a limited group of employees. Which solution will meet these requirements with the LEAST operational overhead?

A : Store the JSON file in an Amazon S3 bucket. Configure AWS Glue to split the file into one file that contains the PII data and one file that contains the non-PII data. Store the output files in separate S3 buckets. Grant the required access to the buckets based on the type of user.

B : Store the JSON file in an Amazon S3 bucket. Use Amazon Macie to identify PII data and to grant access based on the type of user.

C : Store the JSON file in an Amazon S3 bucket. Catalog the file schema in AWS Lake Formation. Use Lake Formation permissions to provide access to the required data based on the type of user.

D : Create two Amazon RDS PostgreSQL databases. Load the PII data and the non-PII data into the separate databases. Grant access to the databases based on the type of user.

Answer: C

Question 2

An analyst is using Amazon Athena and needs to create a new table in the Parquet format with SNAPPY compression from an existing table named old_table. The task requires the correct syntax for a Create Table As Select (CTAS) statement in Athena. Which of the following SQL statements correctly achieves this objective?

A : CREATE NEW TABLE new_tableFROM old_tableWITH FORMAT AS 'Parquet' AND COMPRESSION AS 'SNAPPY';

B : CREATE TABLE new_tableSET FORMAT = 'Parquet', COMPRESSION = 'SNAPPY'AS SELECT *FROM old_table;

C : CREATE TABLE new_table ASSELECT *FROM old_tableUSING ('format' = 'Parquet', 'compression' = 'SNAPPY');

D : CREATE TABLE new_tableWITH ( format = 'Parquet', write_compression = 'SNAPPY')AS SELECT *FROM old_table;

Answer: D

Question 3

A company wants to migrate a data warehouse from Teradata to Amazon Redshift. Which solution will meet this requirement with the LEAST operational effort?

A : Use AWS Database Migration Service (AWS DMS) Schema Conversion to migrate the schema. Use AWS DMS to migrate the data.

B : Use the AWS Schema Conversion Tool (AWS SCT) to migrate the schema. Use AWS Database Migration Service (AWS DMS) to migrate the data.

C : Use AWS Database Migration Service (AWS DMS) to migrate the data. Use automatic schema conversion.

D : Manually export the schema definition from Teradata. Apply the schema to the Amazon Redshift database. Use AWS Database Migration Service (AWS DMS) to migrate the data.

Answer: B

Question 4

A company has as JSON file that contains personally identifiable information (PIT) data and non-PII data. The company needs to make the data available for querying and analysis. The non-PII data must be available to everyone in the company. The PII data must be available only to a limited group of employees. Which solution will meet these requirements with the LEAST operational overhead?

A : Store the JSON file in an Amazon S3 bucket. Configure AWS Glue to split the file into one file that contains the PII data and one file that contains the non-PII data. Store the output files in separate S3 buckets. Grant the required access to the buckets based on the type of user.

B : Store the JSON file in an Amazon S3 bucket. Use Amazon Macie to identify PII data and to grant access based on the type of user.

C : Store the JSON file in an Amazon S3 bucket. Catalog the file schema in AWS Lake Formation. Use Lake Formation permissions to provide access to the required data based on the type of user.

D : Create two Amazon RDS PostgreSQL databases. Load the PII data and the non-PII data into the separate databases. Grant access to the databases based on the type of user.

Answer: C

Question 5

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