최신 DEA-C01 무료덤프 - Snowflake SnowPro Advanced: Data Engineer Certification

문제1

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. Create an AWS Lambda function to schedule a cron job to run the stored procedure.

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

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

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

문제2

A company receives call logs as Amazon S3 objects that contain sensitive customer information.
The company must protect the S3 objects by using encryption. The company must also use encryption keys that only specific employees can access.
Which solution will meet these requirements with the LEAST effort?

A. Use server-side encryption with AWS KMS keys (SSE-KMS) to encrypt the objects that contain customer information. Configure an IAM policy that restricts access to the KMS keys that encrypt the objects.

B. Use server-side encryption with Amazon S3 managed keys (SSE-S3) to encrypt the objects that contain customer information. Configure an IAM policy that restricts access to the Amazon S3 managed keys that encrypt the objects.

C. Use server-side encryption with customer-provided keys (SSE-C) to encrypt the objects that contain customer information. Restrict access to the keys that encrypt the objects.

D. Use an AWS CloudHSM cluster to store the encryption keys. Configure the process that writes to Amazon S3 to make calls to CloudHSM to encrypt and decrypt the objects. Deploy an IAM policy that restricts access to the CloudHSM cluster.

정답: A

문제3

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

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

문제4

A company has developed several AWS Glue extract, transform, and load (ETL) jobs to validate and transform data from Amazon S3. The ETL jobs load the data into Amazon RDS for MySQL in batches once every day. The ETL jobs use a DynamicFrame to read the S3 data.
The ETL jobs currently process all the data that is in the S3 bucket. However, the company wants the jobs to process only the daily incremental data.
Which solution will meet this requirement with the LEAST coding effort?

A. Create an ETL job that reads the S3 file status and logs the status in Amazon DynamoDB.

B. Enable job metrics for the ETL jobs to help keep track of processed objects in Amazon CloudWatch.

C. Enable job bookmarks for the ETL jobs to update the state after a run to keep track of previously processed data.

D. Configure the ETL jobs to delete processed objects from Amazon S3 after each run.

정답: C

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

문제5

A company receives a daily file that contains customer data in .xls format. The company stores the file in Amazon S3. The daily file is approximately 2 GB in size.
A data engineer concatenates the column in the file that contains customer first names and the column that contains customer last names. The data engineer needs to determine the number of distinct customers in the file.
Which solution will meet this requirement with the LEAST operational effort?

A. Create and run an Apache Spark job in an AWS Glue notebook. Configure the job to read the S3 file and calculate the number of distinct customers.

B. Create and run an Apache Spark job in Amazon EMR Serverless to calculate the number of distinct customers.

C. Use AWS Glue DataBrew to create a recipe that uses the COUNT_DISTINCT aggregate function to calculate the number of distinct customers.

D. Create an AWS Glue crawler to create an AWS Glue Data Catalog of the S3 file. Run SQL queries from Amazon Athena to calculate the number of distinct customers.

정답: C

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

문제6

A company stores daily records of the financial performance of investment portfolios in .csv format in an Amazon S3 bucket. A data engineer uses AWS Glue crawlers to crawl the S3 data.
The data engineer must make the S3 data accessible daily in the AWS Glue Data Catalog.
Which solution will meet these requirements?

A. Create an IAM role that includes the AmazonS3FullAccess policy. Associate the role with the crawler. Specify the S3 bucket path of the source data as the crawler's data store. Allocate data processing units (DPUs) to run the crawler every day. Specify a database name for the output.

B. Create an IAM role that includes the AWSGlueServiceRole policy. Associate the role with the crawler. Specify the S3 bucket path of the source data as the crawler's data store. Allocate data processing units (DPUs) to run the crawler every day. Configure the output destination to a new path in the existing S3 bucket.

C. Create an IAM role that includes the AmazonS3FullAccess policy. Associate the role with the crawler. Specify the S3 bucket path of the source data as the crawler's data store. Create a daily schedule to run the crawler. Configure the output destination to a new path in the existing S3 bucket.

D. Create an IAM role that includes the AWSGlueServiceRole policy. Associate the role with the crawler. Specify the S3 bucket path of the source data as the crawler's data store. Create a daily schedule to run the crawler. Specify a database name for the output.

정답: D

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

문제7

A company uses an Amazon Redshift cluster that runs on RA3 nodes. The company wants to scale read and write capacity to meet demand. A data engineer needs to identify a solution that will turn on concurrency scaling.
Which solution will meet this requirement?

A. Turn on concurrency scaling for the daily usage quota for the Redshift cluster.

B. Turn on concurrency scaling in the settings during the creation of any new Redshift cluster.

C. Turn on concurrency scaling at the workload management (WLM) queue level in the Redshift cluster.

D. Turn on concurrency scaling in workload management (WLM) for Redshift Serverless workgroups.

정답: C

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

문제8

A company uses Amazon Athena for one-time queries against data that is in Amazon S3. The company has several use cases. The company must implement permission controls to separate query processes and access to query history among users, teams, and applications that are in the same AWS account.
Which solution will meet these requirements?

A. Create an Athena workgroup for each use case. Apply tags to the workgroup. Create an IAM policy that uses the tags to apply appropriate permissions to the workgroup.

B. Create an IAM role for each use case. Assign appropriate permissions to the role for each use case. Associate the role with Athena.

C. Create an AWS Glue Data Catalog resource policy that grants permissions to appropriate individual IAM users for each use case. Apply the resource policy to the specific tables that Athena uses.

D. Create an S3 bucket for each use case. Create an S3 bucket policy that grants permissions to appropriate individual IAM users. Apply the S3 bucket policy to the S3 bucket.

정답: A

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

문제9

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 an EC2 instance store 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 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.

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

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

정답: D

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

문제10

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 Glue

B. AWS Lambda

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

D. AWS Step Functions

정답: C

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

최신 DEA-C01 무료덤프 - Snowflake SnowPro Advanced: Data Engineer Certification

우리와 연락하기

유용한 링크

최신 업데이트