DEA-C01試験無料問題集（132題）「Snowflake SnowPro Advanced: Data Engineer Certification 認定」

出題：1

In a data engineering pipeline, a company is using multiple applications and teams to access a shared Amazon S3 bucket. To streamline access and simplify permissions management for these different entities, which S3 feature should the company utilize?

A. Use S3 Access Points to create unique endpoints with tailored permissions for each application or team.

B. Implement S3 Lifecycle policies for each application or team to manage their specific data access and retention.

C. Enable multiple IAM roles, each corresponding to an application or team, granting access to the S3 bucket.

D. Activate S3 Transfer Acceleration for the bucket to ensure fast and differentiated access for each application or team.

正解：A 解答を投票する

出題：2

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 dual-layer server-side encryption with AWS KMS keys (DSSE-KMS).

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

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

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

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

Which of the following best describes the type of data found in traditional relational databases?

A. Structured data

B. Unstructured data

C. Free-form data

D. Semi-structured data

正解：A 解答を投票する

出題：4

A company is developing an application that runs on Amazon EC2 instances. Currently, the data that the application generates is temporary. However, the company needs to persist the data, even if the EC2 instances are terminated.
A data engineer must launch new EC2 instances from an Amazon Machine Image (AMI) and configure the instances to preserve the data.
Which solution will meet this requirement?

A. Launch new EC2 instances by using an AMI that is backed by a root Amazon Elastic Block Store (Amazon EBS) volume that contains the application data. Apply the default settings to the EC2 instances.

B. Launch new EC2 instances by using an AMI that is backed by an EC2 instance store volume.
Attach an Amazon Elastic Block Store (Amazon EBS) volume to contain the application data.
Apply the default settings to the EC2 instances.

C. Launch new EC2 instances by using an AMI that is backed by an EC2 instance store volume that contains the application data. Apply the default settings to the EC2 instances.

D. Launch new EC2 instances by using an AMI that is backed by an Amazon Elastic Block Store (Amazon EBS) volume. Attach an additional EC2 instance store volume to contain the application data. Apply the default settings to the EC2 instances.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

A company uses Amazon EMR as an extract, transform, and load (ETL) pipeline to transform data that comes from multiple sources. A data engineer must orchestrate the pipeline to maximize performance.
Which AWS service will meet this requirement MOST cost effectively?

A. AWS Step Functions

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

C. Amazon EventBridge

D. AWS Glue Workflows

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

A company wants to migrate data from an Amazon RDS for PostgreSQL DB instance in the eu- east-1 Region of an AWS account named Account_A. The company will migrate the data to an Amazon Redshift cluster in the eu-west-1 Region of an AWS account named Account_B.
Which solution will give AWS Database Migration Service (AWS DMS) the ability to replicate data between two data stores?

A. Set up an AWS DMS replication instance in Account_B in eu-east-1.

B. Set up an AWS DMS replication instance in Account_B in eu-west-1.

C. Set up an AWS DMS replication instance in Account_A in eu-east-1.

D. Set up an AWS DMS replication instance in a new AWS account in eu-west-1.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

A media company wants to improve a system that recommends media content to customer based on user behavior and preferences. To improve the recommendation system, the company needs to incorporate insights from third-party datasets into the company's existing analytics platform.
The company wants to minimize the effort and time required to incorporate third-party datasets.
Which solution will meet these requirements with the LEAST operational overhead?

A. Use Amazon Kinesis Data Streams to access and integrate third-party datasets from AWS CodeCommit repositories.

B. Use API calls to access and integrate third-party datasets from AWS Data Exchange.

C. Use API calls to access and integrate third-party datasets from AWS DataSync.

D. Use Amazon Kinesis Data Streams to access and integrate third-party datasets from Amazon Elastic Container Registry (Amazon ECR).

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

A financial company wants to use Amazon Athena to run on-demand SQL queries on a petabyte- scale dataset to support a business intelligence (BI) application. An AWS Glue job that runs during non-business hours updates the dataset once every day. The BI application has a standard data refresh frequency of 1 hour to comply with company policies.
A data engineer wants to cost optimize the company's use of Amazon Athena without adding any additional infrastructure costs.
Which solution will meet these requirements with the LEAST operational overhead?

A. Change the format of the files that are in the dataset to Apache Parquet.

B. Configure an Amazon S3 Lifecycle policy to move data to the S3 Glacier Deep Archive storage class after 1 day.

C. Add an Amazon ElastiCache cluster between the BI application and Athena.

D. Use the query result reuse feature of Amazon Athena for the SQL queries.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

A lab uses IoT sensors to monitor humidity, temperature, and pressure for a project. The sensors send 100 KB of data every 10 seconds. A downstream process will read the data from an Amazon S3 bucket every 30 seconds.
Which solution will deliver the data to the S3 bucket with the LEAST latency?

A. Use Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) and Amazon Kinesis Data Firehose to deliver the data to the S3 bucket. Use a 5 second buffer interval for Kinesis Data Firehose.

B. Use Amazon Kinesis Data Streams and Amazon Kinesis Data Firehose to deliver the data to the S3 bucket. Use the default buffer interval for Kinesis Data Firehose.

C. Use Amazon Kinesis Data Streams to deliver the data to the S3 bucket. Configure the stream to use 5 provisioned shards.

D. Use Amazon Kinesis Data Streams and call the Kinesis Client Library to deliver the data to the S3 bucket. Use a 5 second buffer interval from an application.

正解：A 解答を投票する

出題：10

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.
The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.
Which combination of steps will meet this requirement with the LEAST operational overhead?
(Choose two.)

A. Turn on the public access setting for the DB instance.

B. Update the security group of the DB instance to allow only Lambda function invocations on the database port.

C. Configure the Lambda function to run in the same subnet that the DB instance uses.

D. Attach the same security group to the Lambda function and the DB instance. Include a self- referencing rule that allows access through the database port.

E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port.

正解：B,C 解答を投票する

DEA-C01試験無料問題集「Snowflake SnowPro Advanced: Data Engineer Certification 認定」