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

質問 1

A data engineer creates an AWS Lambda function that an Amazon EventBridge event will invoke.
When the data engineer tries to invoke the Lambda function by using an EventBridge event, an AccessDeniedException message appears.
How should the data engineer resolve the exception?

（A）Ensure that the subnet where the Lambda function is deployed is configured to be a private subnet.

（B）Ensure that both the IAM role that EventBridge uses and the Lambda function's resource-based policy have the necessary permissions.

（C）Ensure that EventBridge schemas are valid and that the event mapping configuration is correct.

（D）Ensure that the trust policy of the Lambda function execution role allows EventBridge to assume the execution role.

正解：B 解答を投票する

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

質問 2

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-west-1.

（B）Set up an AWS DMS replication instance in Account_B in eu-east-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.

正解：B 解答を投票する

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

質問 3

A company plans to provision a log delivery stream within a VPC. The company configured the VPC flow logs to publish to Amazon CloudWatch Logs. The company needs to send the flow logs to Splunk in near real time for further analysis.
Which solution will meet these requirements with the LEAST operational overhead?

（A）Configure an Amazon Kinesis Data Streams data stream to use Splunk as the destination. Create a CloudWatch Logs subscription filter to send log events to the data stream.

（B）Create an Amazon Kinesis Data Firehose delivery stream to use Splunk as the destination. Create an AWS Lambda function to send the flow logs from CloudWatch Logs to the delivery stream.

（C）Configure an Amazon Kinesis Data Streams data stream to use Splunk as the destination. Create an AWS Lambda function to send the flow logs from CloudWatch Logs to the data stream.

（D）Create an Amazon Kinesis Data Firehose delivery stream to use Splunk as the destination. Create a CloudWatch Logs subscription filter to send log events to the delivery stream.

正解：D 解答を投票する

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

質問 4

A company is designing a data lake on Amazon S3. To ensure high performance when accessing the data, which best practice should the company adopt in organizing its data in the S3 bucket?

（A）Store all data files as a single large file and use AWS Lambda to parse required data segments.

（B）Partition data based on commonly accessed attributes and use a consistent naming scheme for prefixes.

（C）Enable S3 Transfer Acceleration to ensure data is quickly accessible from any location.

（D）Use a flat structure by avoiding the creation of any prefix or "folder" hierarchy.

正解：B 解答を投票する

質問 5

A data engineer wants to improve the performance of SQL queries in Amazon Athena that run against a sales data table.
The data engineer wants to understand the execution plan of a specific SQL statement. The data engineer also wants to see the computational cost of each operation in a SQL query.
Which statement does the data engineer need to run to meet these requirements?

（A）EXPLAIN ANALYZE SELECT * FROM sales;

（B）EXPLAIN FROM sales;

（C）EXPLAIN SELECT * FROM sales;

（D）EXPLAIN ANALYZE FROM sales;

正解：A 解答を投票する

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

質問 6

An ecommerce company wants to use AWS to migrate data pipelines from an on-premises environment into the AWS Cloud. The company currently uses a third-party tool in the on- premises environment to orchestrate data ingestion processes.
The company wants a migration solution that does not require the company to manage servers.
The solution must be able to orchestrate Python and Bash scripts. The solution must not require the company to refactor any code.
Which solution will meet these requirements with the LEAST operational overhead?

（A）AWS Step Functions

（B）Amazon Managed Workflows for Apache Airflow (Amazon MVVAA)

（C）AWS Glue

（D）AWS Lambda

正解：B 解答を投票する

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

質問 7

A data engineer must manage the ingestion of real-time streaming data into AWS. The data engineer wants to perform real-time analytics on the incoming streaming data by using time- based aggregations over a window of up to 30 minutes. The data engineer needs a solution that is highly fault tolerant.
Which solution will meet these requirements with the LEAST operational overhead?

（A）Use an AWS Lambda function that includes both the business and the analytics logic to perform aggregations for a tumbling window of up to 30 minutes, based on the event timestamp.

（B）Use an AWS Lambda function that includes both the business and the analytics logic to perform time-based aggregations over a window of up to 30 minutes for the data in Amazon Kinesis Data Streams.

（C）Use Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to analyze the data that might occasionally contain duplicates by using multiple types of aggregations.

（D）Use Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to analyze the data by using multiple types of aggregations to perform time-based analytics over a window of up to 30 minutes.

正解：D 解答を投票する

質問 8

A manufacturing company wants to collect data from sensors. A data engineer needs to implement a solution that ingests sensor data in near real time.
The solution must store the data to a persistent data store. The solution must store the data in nested JSON format. The company must have the ability to query from the data store with a latency of less than 10 milliseconds.
Which solution will meet these requirements with the LEAST operational overhead?

（A）Use AWS Lambda to process the sensor data. Store the data in Amazon S3 for querying.

（B）Use Amazon Simple Queue Service (Amazon SQS) to buffer incoming sensor data. Use AWS Glue to store the data in Amazon RDS for querying.

（C）Use Amazon Kinesis Data Streams to capture the sensor data. Store the data in Amazon DynamoDB for querying.

（D）Use a self-hosted Apache Kafka cluster to capture the sensor data. Store the data in Amazon S3 for querying.

正解：B 解答を投票する

質問 9

A data engineer is building a data orchestration workflow. The data engineer plans to use a hybrid model that includes some on-premises resources and some resources that are in the cloud. The data engineer wants to prioritize portability and open source resources.
Which service should the data engineer use in both the on-premises environment and the cloud- based environment?

（A）AWS Glue

（B）Amazon Managed Workflows for Apache Airflow (Amazon MWAA)

（C）AWS Data Exchange

（D）Amazon Simple Workflow Service (Amazon SWF)

正解：B 解答を投票する

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

質問 10

What is the primary purpose of data lineage in data engineering?

（A）To optimize query performance.

（B）To trace the source and flow of data.

（C）To transform data formats.

（D）To create visualizations.

正解：B 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験