[2026] Snowflake SnowPro Advanced: Data Engineer Certification

문제1

A data engineer notices that Amazon Athena queries are held in a queue before the queries run.
How can the data engineer prevent the queries from queueing?

A. Allow users who run the Athena queries to an existing workgroup.

B. Configure provisioned capacity for an existing workgroup.

C. Increase the query result limit.

D. Use federated queries.

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제2

A company adds new data to a large CSV file in an Amazon S3 bucket every day. The file contains company sales data from the previous 5 years. The file currently includes more than
5,000 rows. The CSV file structure is shown below with sample data:

The company needs to use Amazon Athena to run queries on the CSV file to fetch data from a specific time period.
Which solution will meet this requirement MOST cost-effectively?

A. Create an Amazon RDS database. Create a table named SALES that matches the schema of the CSV file. Create an index on the SALE_DATE column. Create an AWS Lambda function to load the CSV data into the RDS database. Use S3 Event Notifications to invoke the Lambda function.

B. Launch an Amazon EMR cluster. Specify AWS Glue Data Catalog as the default Apache Hive metastore. Use Presto in Trino to run queries on the data.

C. Write an Apache Spark script to convert the CSV data to JSON format. Create an AWS Glue job to run the script every day. Catalog the JSON data in AWS Glue. Run the Athena queries on the JSON data.

D. Use prefixes to partition the data in the S3 bucket. Use the SALE_DATE column to create a partition for each day. Catalog the data in AWS Glue and ensure that the partitions are added.
Update the Athena queries to use the new partitions.

정답: D

설명: (Fast2test 회원만 볼 수 있음)

문제3

A marketing company uses Amazon S3 to store marketing data. The company uses versioning in some buckets. The company runs several jobs to read and load data into the buckets.
To help cost-optimize its storage, the company wants to gather information about incomplete multipart uploads and outdated versions that are present in the S3 buckets.
Which solution will meet these requirements with the LEAST operational effort?

A. Use AWS usage reports for Amazon S3 to gather the information.

B. Use AWS CLI to gather the information.

C. Use the Amazon S3 Storage Lens dashboard to gather the information.

D. Use Amazon S3 Inventory configurations reports to gather the information.

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제4

A gaming company uses a NoSQL database to store customer information. The company is planning to migrate to AWS.
The company needs a fully managed AWS solution that will handle high online transaction processing (OLTP) workload, provide single-digit millisecond performance, and provide high availability around the world.
Which solution will meet these requirements with the LEAST operational overhead?

A. Amazon Timestream

B. Amazon DocumentDB (with MongoDB compatibility)

C. Amazon Keyspaces (for Apache Cassandra)

D. Amazon DynamoDB

정답: D

문제5

A company stores data in a data lake that is in Amazon S3. Some data that the company stores in the data lake contains personally identifiable information (PII). Multiple user groups need to access the raw data. The company must ensure that user groups can access only the PII that they require.
Which solution will meet these requirements with the LEAST effort?

A. Create IAM roles that have different levels of granular access. Assign the IAM roles to IAM user groups. Use an identity-based policy to assign access levels to user groups at the column level.

B. Use Amazon QuickSight to access the data. Use column-level security features in QuickSight to limit the PII that users can retrieve from Amazon S3 by using Amazon Athena. Define QuickSight access levels based on the PII access requirements of the users.

C. Build a custom query builder UI that will run Athena queries in the background to access the data.
Create user groups in Amazon Cognito. Assign access levels to the user groups based on the PII access requirements of the users.

D. Use Amazon Athena to query the data. Set up AWS Lake Formation and create data filters to establish levels of access for the company's IAM roles. Assign each user to the IAM role that matches the user's PII access requirements.

정답: D

설명: (Fast2test 회원만 볼 수 있음)

문제6

A data engineer needs to create a new empty table in Amazon Athena that has the same schema as an existing table named old_table.
Which SQL statement should the data engineer use to meet this requirement?

A. CREATE TABLE new_table AS SELECT * FROM old_tables;

B. CREATE TABLE new_table AS (SELECT * FROM old_table) WITH NO DATA;

C. INSERT INTO new_table SELECT * FROM old_table;

D. CREATE TABLE new_table (LIKE old_table);

정답: B

문제7

A company is using Amazon Redshift to build a data warehouse solution. The company is loading hundreds of files into a fact table that is in a Redshift cluster.
The company wants the data warehouse solution to achieve the greatest possible throughput.
The solution must use cluster resources optimally when the company loads data into the fact table.
Which solution will meet these requirements?

A. Use a single COPY command to load the data into the Redshift cluster.

B. Use a number of INSERT statements equal to the number of Redshift cluster nodes. Load the data in parallel into each node.

C. Use S3DistCp to load multiple files into Hadoop Distributed File System (HDFS). Use an HDFS connector to ingest the data into the Redshift cluster.

D. Use multiple COPY commands to load the data into the Redshift cluster.

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제8

A company is setting up a data pipeline in AWS. The pipeline extracts client data from Amazon S3 buckets, performs quality checks, and transforms the data. The pipeline stores the processed data in a relational database. The company will use the processed data for future queries.
Which solution will meet these requirements MOST cost-effectively?

A. Use AWS Glue Studio to extract the data from the S3 buckets. Use AWS Glue DataBrew to perform the transformations and quality checks. Load the processed data into an Amazon RDS for MySQL instance. Load the quality check results into a new S3 bucket.

B. Use AWS Glue ETL to extract the data from the S3 buckets and perform the transformations. Use AWS Glue Data Quality to enforce suggested quality rules. Load the data and the quality check results into an Amazon RDS for MySQL instance.

C. Use AWS Glue Studio to extract the data from the S3 buckets. Use AWS Glue DataBrew to perform the transformations and quality checks. Load the processed data and quality check results into an Amazon RDS for MySQL instance.

D. Use AWS Glue ETL to extract the data from the S3 buckets and perform the transformations. Use AWS Glue DataBrew to perform quality checks.
Load the processed data and the quality check results into a new S3 bucket.

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제9

A company uses AWS Key Management Service (AWS KMS) to encrypt an Amazon Redshift cluster. The company wants to configure a cross-Region snapshot of the Redshift cluster as part of disaster recovery (DR) strategy.
A data engineer needs to use the AWS CLI to create the cross-Region snapshot.
Which combination of steps will meet these requirements? (Choose two.)

A. Convert the cluster to a Multi-AZ deployment.

B. Create a KMS key and configure a snapshot copy grant in the source AWS Region.

C. Create a KMS key and configure a snapshot copy grant in the destination AWS Region.

D. In the source AWS Region, enable snapshot copying. Specify the name of the snapshot copy grant that is created in the destination AWS Region.

E. In the source AWS Region, enable snapshot copying. Specify the name of the snapshot copy grant that is created in the source AWS Region.

정답: C,D

설명: (Fast2test 회원만 볼 수 있음)

Snowflake SnowPro Advanced: Data Engineer Certification - DEA-C01무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트