Snowflake SnowPro Advanced: Data Engineer Certification

문제1
A company uses an organization in AWS Organizations to manage multiple AWS accounts. The company uses an enhanced fanout data stream in Amazon Kinesis Data Streams to receive streaming data from multiple producers. The company runs the data stream in an account named Account A. The company wants to use an AWS Lambda function in an account named Account B to process the data from the data stream. The company creates a Lambda execution role in Account B that has permissions to access data from the data stream in Account A.
What additional step must the company take to meet this requirement?

A. Add a resource-based policy to the data stream to allow read access for the cross-account Lambda execution role.

B. Create a service control policy (SCP) to grant the data stream read access to the cross-account Lambda execution role. Attach the SCP to Account A.

C. Create a service control policy (SCP) to grant the data stream read access to the cross-account Lambda execution role. Attach the SCP to Account B.

D. Add a resource-based policy to the cross-account Lambda function to grant the data stream read access to the function.

정답: A

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

문제2
A company is migrating its database servers from Amazon EC2 instances that run Microsoft SQL Server to Amazon RDS for Microsoft SQL Server DB instances. The company's analytics team must export large data elements every day until the migration is complete. The data elements are the result of SQL joins across multiple tables. The data must be in Apache Parquet format. The analytics team must store the data in Amazon S3.
Which solution will meet these requirements in the MOST operationally efficient way?

A. Create an AWS Lambda function that queries the EC2 instance-based databases by using Java Database Connectivity (JDBC). Configure the Lambda function to retrieve the required data, transform the data into Parquet format, and transfer the data into an S3 bucket. Use Amazon EventBridge to schedule the Lambda function to run every day.

B. Schedule SQL Server Agent to run a daily SQL query that selects the desired data elements from the EC2 instance-based SQL Server databases. Configure the query to direct the output .csv objects to an S3 bucket. Create an S3 event that invokes an AWS Lambda function to transform the output format from .csv to Parquet.

C. Create a view in the EC2 instance-based SQL Server databases that contains the required data elements. Create an AWS Glue job that selects the data directly from the view and transfers the data in Parquet format to an S3 bucket. Schedule the AWS Glue job to run every day.

D. Use a SQL query to create a view in the EC2 instance-based SQL Server databases that contains the required data elements. Create and run an AWS Glue crawler to read the view.
Create an AWS Glue job that retrieves the data and transfers the data in Parquet format to an S3 bucket. Schedule the AWS Glue job to run every day.

정답: C

문제3
A data engineer needs to onboard a new data producer into AWS. The data producer needs to migrate data products to AWS.
The data producer maintains many data pipelines that support a business application. Each pipeline must have service accounts and their corresponding credentials. The data engineer must establish a secure connection from the data producer's on-premises data center to AWS. The data engineer must not use the public internet to transfer data from an on-premises data center to AWS.
Which solution will meet these requirements?

A. Create an AWS Direct Connect connection to the on-premises data center. Store the service account credentials in AWS Secrets manager.

B. Create a security group in a public subnet. Configure the security group to allow only connections from the CIDR blocks that correspond to the data producer. Create Amazon S3 buckets than contain presigned URLS that have one-day expiration dates.

C. Instruct the new data producer to create Amazon Machine Images (AMIs) on Amazon Elastic Container Service (Amazon ECS) to store the code base of the application. Create security groups in a public subnet that allow connections only to the on-premises data center.

D. Create an AWS Direct Connect connection to the on-premises data center. Store the application keys in AWS Secrets Manager. Create Amazon S3 buckets that contain presigned URLS that have one-day expiration dates.

정답: A

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

문제4
A company generates reports from 30 tables in an Amazon Redshift data warehouse. The data source is an operational Amazon Aurora MySQL database that contains 100 tables. Currently, the company refreshes all data from Aurora to Amazon Redshift every hour, which causes delays in report generation. Which combination of steps will meet these requirements with the LEAST operational overhead? (Choose two.)

A. Create a zero-ETL integration in Amazon Aurora. Select only the required tables.

B. Create a database in Amazon Redshift that uses the integration.

C. Use query editor v2 in Amazon Redshift to access the data in Aurora.

D. Create an AWS Glue job to transfer each required table. Run an AWS Glue workflow to initiate the jobs every 5 minutes.

E. Use AWS Database Migration Service (AWS DMS) to create a replication task. Select only the required tables.

정답: A,B

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

문제5
A company is migrating on-premises workloads to AWS. The company wants to reduce overall operational overhead. The company also wants to explore serverless options.
The company's current workloads use Apache Pig, Apache Oozie, Apache Spark, Apache Hbase, and Apache Flink. The on-premises workloads process petabytes of data in seconds. The company must maintain similar or better performance after the migration to AWS.
Which extract, transform, and load (ETL) service will meet these requirements?

A. AWS Lambda

B. Amazon Redshift

C. AWS Glue

D. Amazon EMR

정답: D

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

문제6
A company uses a data lake that is based on an Amazon S3 bucket. To comply with regulations, the company must apply two layers of server-side encryption to files that are uploaded to the S3 bucket. The company wants to use an AWS Lambda function to apply the necessary encryption.
Which solution will meet these requirements?

A. Use both server-side encryption with AWS KMS keys (SSE-KMS) and the Amazon S3 Encryption Client.

B. Use server-side encryption with customer-provided keys (SSE-C) before files are uploaded.

C. Use server-side encryption with AWS KMS keys (SSE-KMS).

D. Use dual-layer server-side encryption with AWS KMS keys (DSSE-KMS).

정답: D

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

문제7
A data engineer wants to orchestrate a set of extract, transform, and load (ETL) jobs that run on AWS. The ETL jobs contain tasks that must run Apache Spark jobs on Amazon EMR, make API calls to Salesforce, and load data into Amazon Redshift.
The ETL jobs need to handle failures and retries automatically. The data engineer needs to use Python to orchestrate the jobs.
Which service will meet these requirements?

A. Amazon EventBridge

B. AWS Step Functions

C. Amazon Managed Workflows for Apache Airflow (Amazon MWAA)

D. AWS Glue

정답: C

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

문제8
A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.
Which solution will meet this requirement MOST cost-effectively?

A. Use Amazon Athena Federated Query to join the data from all data sources.

B. Use an Amazon EMR provisioned cluster to read from all sources. Use Apache Spark to join the data and perform the analysis.

C. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3. Run Amazon Athena queries directly on the S3 files.

D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift.

정답: A

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

문제9
A company maintains a central Amazon Redshift data warehouse that aggregates daily transactional data from Amazon RDS for PostgreSQL and Amazon Aurora MySQL. A data engineer notices that some complex transformation queries take hours to finish. The data engineer wants to optimize query performance to reduce query execution time as much as possible.
Which solution will meet this requirement?

A. Use materialized views in Amazon Redshift for frequently queried data patterns.

B. Use Amazon Redshift Spectrum to create external tables based on the Redshift tables.

C. Export the tables to an Amazon S3 bucket. Use Amazon Athena to query the data in the bucket.

D. Increase the concurrency scaling quota for the Redshift cluster.

정답: A

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

문제10
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. In the source AWS Region, enable snapshot copying. Specify the name of the snapshot copy grant that is created in the source AWS Region.

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

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

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

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

정답: B,E

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

문제11
A data engineer finished testing an Amazon Redshift stored procedure that processes and inserts data into a table that is not mission critical. The engineer wants to automatically run the stored procedure on a daily basis.
Which solution will meet this requirement in the MOST cost-effective way?

A. Schedule and run the stored procedure by using the Amazon Redshift Data API in an Amazon EC2 Spot Instance.

B. Create an AWS Lambda function to schedule a cron job to run the stored procedure.

C. Schedule an AWS Glue Python shell job to run the stored procedure.

D. Use query editor v2 to run the stored procedure on a schedule.

정답: D

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

문제12
A company uses AWS Glue jobs to implement several data pipelines. The pipelines are critical to the company.
The company needs to implement a monitoring mechanism that will alert stakeholders if the pipelines fail.
Which solution will meet these requirements with the LEAST operational overhead?

A. Configure an Amazon CloudWatch Logs log group for the AWS Glue jobs. Create an Amazon EventBridge rule to match new log creation events in the log group. Configure the rule to send notifications to an Amazon Simple Notification Service (Amazon SNS) topic.

B. Create an Amazon EventBridge rule to match AWS Glue job failure events. Configure the rule to target an AWS Lambda function to process events. Configure the function to send notifications to an Amazon Simple Notification Service (Amazon SNS) topic.

C. Create an Amazon EventBridge rule to match AWS Glue job failure events. Define an Amazon CloudWatch metric based on the EventBridge rule. Set up a CloudWatch alarm based on the metric to send notifications to an Amazon Simple Notification Service (Amazon SNS) topic.

D. Configure an Amazon CloudWatch Logs log group for the AWS Glue jobs. Create an Amazon EventBridge rule to match new log creation events in the log group. Configure the rule to target an AWS Lambda function that reads the logs and sends notifications to an Amazon Simple Notification Service (Amazon SNS) topic if AWS Glue job failure logs are present.

정답: C

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

문제13
A data engineer needs to run a data transformation job whenever a user adds a file to an Amazon S3 bucket. The job will run for less than 1 minute. The job must send the output through an email message to the data engineer. The data engineer expects users to add one file every hour of the day.
Which solution will meet these requirements in the MOST operationally efficient way?

A. Create a small Amazon EC2 instance that polls the S3 bucket for new files. Run transformation code on a schedule to generate the output. Use operating system commands to send email messages.

B. Deploy an Amazon EMR cluster. Use EMR File System (EMRFS) to access the files in the S3 bucket. Run transformation code on a schedule to generate the output to a second S3 bucket.Create an Amazon Simple Notification Service (Amazon SNS) topic. Configure Amazon S3 Event Notifications to notify the topic when a new object is created.

C. Create an AWS Lambda function to transform the data. Use Amazon S3 Event Notifications to invoke the Lambda function when a new object is created. Publish the output to an Amazon Simple Notification Service (Amazon SNS) topic. Subscribe the data engineer's email account to the topic.

D. Run an Amazon Elastic Container Service (Amazon ECS) task to poll the S3 bucket for new files.
Run transformation code on a schedule to generate the output. Use operating system commands to send email messages.

정답: C

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

문제14
A company utilizes AWS Glue for ETL (Extract, Transform, Load) jobs to process large volumes of data stored in Amazon S3. Recently, they have been experiencing performance issues with their Glue jobs, resulting in longer processing times and delays in data delivery. Upon investigation, they found that the bottleneck occurred during data extraction from S3. Which of the following could be the potential cause of this performance issue?

A. The Glue job's configuration lacks optimization for parallelism, causing inefficient data extraction from S3, leading to longer processing times.

B. The underlying network bandwidth between AWS Glue and Amazon S3 is insufficient, causing slow data transfer rates and impacting job performance.

C. The size and structure of the S3 data files are causing overhead during data extraction, resulting in longer processing times for Glue jobs.

D. There are issues with the IAM (Identity and Access Management) roles associated with the Glue job, leading to permission errors or delays in accessing S3 data.

정답: A

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

문제15
A company has a data pipeline that processes transaction data in real time. The company needs a notification system that alerts different teams based on the type of processing error without any delay. For security-related errors, the system must immediately notify the security team. For data validation errors, the system must notify the data quality team. For system errors, the system must notify the operations team. Which solution will meet these requirements with the LEAST operational overhead?

A. Set up Amazon CloudWatch alarms with different metrics for each error type. Invoke a different Amazon Simple Notification Service (Amazon SNS) notification each time a metrics threshold is crossed.

B. Configure Amazon EventBridge rules with distinct event patterns for each error type. Route each error type to a dedicated Amazon Simple Notification Service (Amazon SNS) topic for team- specific alerts.

C. Use Amazon Simple Queue Service (Amazon SQS) with message attributes to categorize errors.
Allow each team to poll their respective SQS queue for relevant errors.

D. Create an Amazon Simple Notification Service (Amazon SNS) topic with an AWS Lambda function subscriber that evaluates the error type and forwards the error to the appropriate email addresses.

정답: B

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

최신Snowflake SnowPro Advanced: Data Engineer Certification - DEA-C01무료샘플문제

KoreaDumps의 제품으로 GO GO GO !

자격증의 중요성:

KoreaDumps 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공: