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

質問 1

An airline company is collecting metrics about flight activities for analytics. The company is conducting a proof of concept (POC) test to show how analytics can provide insights that the company can use to increase on-time departures.
The POC test uses objects in Amazon S3 that contain the metrics in .csv format. The POC test uses Amazon Athena to query the data. The data is partitioned in the S3 bucket by date.
As the amount of data increases, the company wants to optimize the storage solution to improve query performance.
Which combination of solutions will meet these requirements? (Choose two.)

（A）Use an S3 bucket that is in the same AWS Region where the company runs Athena queries.

（B）Preprocess the .csv data to JSON format by fetching only the document keys that the query requires.

（C）Use an S3 bucket that is in the same account that uses Athena to query the data.

（D）Add a randomized string to the beginning of the keys in Amazon S3 to get more throughput across partitions.

（E）Preprocess the .csv data to Apache Parquet format by fetching only the data blocks that are needed for predicates.

正解：A、E 解答を投票する

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

質問 2

A data engineer needs to use Amazon Neptune to develop graph applications.
Which programming languages should the engineer use to develop the graph applications?
(Choose two.)

（A）ANSI SQL

（B）SQL

（C）Spark SQL

（D）Gremlin

（E）SPARQL

正解：D、E 解答を投票する

質問 3

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 Kinesis Data Streams to deliver the data to the S3 bucket. Configure the stream to use 5 provisioned shards.

（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 and call the Kinesis Client Library to deliver the data to the S3 bucket. Use a 5 second buffer interval from an application.

（D）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.

正解：D 解答を投票する

質問 4

A company uses Amazon Redshift as a data warehouse solution. One of the datasets that the company stores in Amazon Redshift contains data for a vendor.
Recently, the vendor asked the company to transfer the vendor's data into the vendor's Amazon S3 bucket once each week.
Which solution will meet this requirement?

（A）Configure Amazon Redshift Spectrum to use the vendor's S3 bucket a destination, Enable data querying in both directions.

（B）Create an AWS Lambda function to connect to the Redshift data warehouse. Configure the Lambda function to use the Redshift COPY command to copy the required data to the vendor's S3 bucket on a schedule.

（C）Use the Amazon Redshift data sharing feature. Set the vendor's S3 bucket as the destination.
Configure the source to be as a custom SQL query that selects the required data.

（D）Create an AWS Glue job to connect to the Redshift data warehouse. Configure the AWS Glue job to use the Redshift UNLOAD command to load the required data to the vendor's S3 bucket on a schedule.

正解：D 解答を投票する

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

質問 5

A company needs to build a data lake in AWS. The company must provide row-level data access and column-level data access to specific teams. The teams will access the data by using Amazon Athena, Amazon Redshift Spectrum, and Apache Hive from Amazon EMR.
Which solution will meet these requirements with the LEAST operational overhead?

（A）Use Amazon Redshift for data lake storage. Use Redshift security policies to restrict data access by rows and columns. Provide data access by using Apache Spark and Amazon Athena federated queries.

（B）Use Amazon S3 for data lake storage. Use AWS Lake Formation to restrict data access by rows and columns. Provide data access through AWS Lake Formation.

（C）Use Amazon S3 for data lake storage. Use Apache Ranger through Amazon EMR to restrict data access by rows and columns. Provide data access by using Apache Pig.

（D）Use Amazon S3 for data lake storage. Use S3 access policies to restrict data access by rows and columns. Provide data access through Amazon S3.

正解：B 解答を投票する

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

質問 6

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）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.

（C）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）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 解答を投票する

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

質問 7

A data engineer has a one-time task to read data from objects that are in Apache Parquet format in an Amazon S3 bucket. The data engineer needs to query only one column of the data.
Which solution will meet these requirements with the LEAST operational overhead?

（A）Configure an AWS Lambda function to load data from the S3 bucket into a pandas dataframe.
Write a SQL SELECT statement on the dataframe to query the required column.

（B）Use S3 Select to write a SQL SELECT statement to retrieve the required column from the S3 objects.

（C）Prepare an AWS Glue DataBrew project to consume the S3 objects and to query the required column.

（D）Run an AWS Glue crawler on the S3 objects. Use a SQL SELECT statement in Amazon Athena to query the required column.

正解：B 解答を投票する

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

質問 8

An investment company needs to manage and extract insights from a volume of semi-structured data that grows continuously.
A data engineer needs to deduplicate the semi-structured data, remove records that are duplicates, and remove common misspellings of duplicates.
Which solution will meet these requirements with the LEAST operational overhead?

（A）Use the FindMatches feature of AWS Glue to remove duplicate records.

（B）Use Amazon Neptune ML and an Apache Gremlin script to remove duplicate records.

（C）Use non-Windows functions in Amazon Athena to remove duplicate records.

（D）Use the global tables feature of Amazon DynamoDB to prevent duplicate data.

正解：A 解答を投票する

質問 9

A company uses an Amazon S3 Standard bucket to maintain a self-managed transactional data lake that uses Apache Iceberg tables. The data lake ingests data both in real time and in batches.
Users report slow performance for real-time tables. A data engineer reviews the real-time tables and notices that the tables are made up of many small data files The data engineer must improve the performance of the real-time tables.
Which solution will meet this requirement?

（A）Archive historic snapshots.

（B）Expire historic snapshots.

（C）Apply compaction.

（D）Delete S3 objects that are not linked from the Iceberg table.

正解：C 解答を投票する

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

質問 10

A data engineer creates an AWS Glue Data Catalog table by using an AWS Glue crawler that is named Orders. The data engineer wants to add the following new partitions:
s3://transactions/orders/order_date=2023-01-01
s3://transactions/orders/order_date=2023-01-02
The data engineer must edit the metadata to include the new partitions in the table without scanning all the folders and files in the location of the table.
Which data definition language (DDL) statement should the data engineer use in Amazon Athena?

（A）MSCK REPAIR TABLE Orders;

（B）ALTER TABLE Orders MODIFY PARTITION(order_date='2023-01-01') LOCATION
's3://transactions/orders/2023-01-01';
ALTER TABLE Orders MODIFY PARTITION(order_date='2023-01-02') LOCATION
's3://transactions/orders/2023-01-02';

（C）REPAIR TABLE Orders;

（D）ALTER TABLE Orders ADD PARTITION(order_date='2023-01-01') LOCATION
's3://transactions/orders/order_date=2023-01-01';
ALTER TABLE Orders ADD PARTITION(order_date='2023-01-02') LOCATION
's3://transactions/orders/order_date=2023-01-02';

正解：D 解答を投票する

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

質問 11

A company has a business intelligence platform on AWS. The company uses an AWS Storage Gateway Amazon S3 File Gateway to transfer files from the company's on-premises environment to an Amazon S3 bucket.
A data engineer needs to setup a process that will automatically launch an AWS Glue workflow to run a series of AWS Glue jobs when each file transfer finishes successfully.
Which solution will meet these requirements with the LEAST operational overhead?

（A）Set up an AWS Lambda function that will invoke the AWS Glue Workflow. Set up an event for the creation of an S3 object as a trigger for the Lambda function.

（B）Determine when the file transfers usually finish based on previous successful file transfers. Set up an Amazon EventBridge scheduled event to initiate the AWS Glue jobs at that time of day.

（C）Set up an Amazon EventBridge event that initiates the AWS Glue workflow after every successful S3 File Gateway file transfer event.

（D）Set up an on-demand AWS Glue workflow so that the data engineer can start the AWS Glue workflow when each file transfer is complete.

正解：C 解答を投票する

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

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

弊社を連絡する

関連リンク

トップ試験