Free Access Snowflake.DEA-C01.v2026-09-04.q215 Practice Test (Page 34)

Question 161

A company uses Amazon Redshift for its data warehouse. The company must automate refresh schedules for Amazon Redshift materialized views.
Which solution will meet this requirement with the LEAST effort?

A.Use Apache Airflow to refresh the materialized views.

B.Use an AWS Lambda user-defined function (UDF) within Amazon Redshift to refresh the materialized views.

C.Use the query editor v2 in Amazon Redshift to refresh the materialized views.

D.Use an AWS Glue workflow to refresh the materialized views.

Question 162

A company uses AWS Glue ETL pipelines to process data. The company uses Amazon Athena to analyze data in an Amazon S3 bucket.
To better understand shipping timelines, the company decides to collect and store shipping and delivery dates in addition to order data. The company adds a data quality check to ensure that shipping date is greater than order date and that delivery date is greater than shipping date.
Orders that fail the quality check must be stored in a second S3 bucket.
Which solution will meet these requirements MOST cost-effectively?

A.Use the AWS Glue DataBrew DATEDIFF function to create two additional columns. Check the new columns.

B.Use Athena to query all three date columns, and compare the columns.

C.Use AWS Glue Data Quality to create a custom rule that uses the three date columns.

D.Use an AWS Glue crawler to populate an AWS Glue Data Catalog. Use the three date columns to create a filter.

Question 163

A data engineer needs to deploy a serverless data pipeline. In the pipeline, CSV files are uploaded to an Amazon S3 bucket, which invokes an AWS Lambda function. The Lambda function transforms the CSV files to JSON format and stores the results in a second S3 bucket.
The data engineer has created an AWS Serverless Application Model (AWS SAM) template that includes the Lambda function. The data engineer wants to use AWS SAM for the pipeline deployment.
Which solution will package and deploy this serverless data pipeline?

A.Add the first S3 bucket and the S3 event source for the Lambda function to the SAM template. Run the sam build command to prepare the deployment package. Run the sam deploy --guided command to deploy the pipeline.

B.Run the sam deploy command directly with the --s3-bucket parameter to deploy the Lambda function code. Manually configure the S3 event trigger in the AWS Management Console.

C.Add the first S3 bucket to the SAM template. Run the sam package template to upload the Lambda function code to Amazon S3. Create an AWS CloudFormation stack from the packaged template. Configure event notifications manually.

D.Add the first S3 bucket and the S3 event source for the Lambda function to the SAM template. Run the sam build command followed by the aws cloudformation deploy command to deploy the pipeline.

Question 164

A company stores customer data in an Amazon S3 bucket. Multiple teams in the company want to use the customer data for downstream analysis. The company needs to ensure that the teams do not have access to personally identifiable information (PII) about the customers.
Which solution will meet this requirement with LEAST operational overhead?

A.Use Amazon Data Firehose and Amazon Comprehend to detect and remove PII.

B.Use Amazon Macie to create and run a sensitive data discovery job to detect and remove PII.

C.Use an AWS Glue DataBrew job to store the PII data in a second S3 bucket. Perform analysis on the data that remains in the original S3 bucket.

D.Use S3 Object Lambda to access the data, and use Amazon Comprehend to detect and remove PII.

Question 165

A financial company recently added more features to its mobile app. The new features required the company to create a new topic in an existing Amazon Managed Streaming for Apache Kafka (Amazon MSK) cluster.
A few days after the company added the new topic, Amazon CloudWatch raised an alarm on the RootDiskUsed metric for the MSK cluster.
How should the company address the CloudWatch alarm?

A.Expand the storage of the MSK broker. Configure the MSK cluster storage to expand automatically.

B.Expand the storage of the Apache ZooKeeper nodes.

C.Update the MSK broker instance to a larger instance type. Restart the MSK cluster.

D.Specify the Target Volume-in-GiB parameter for the existing topic.

Other Version: 1887Snowflake.DEA-C01.v2024-01-27.q66

Latest Upload: 232Snowflake.DEA-C01.v2026-09-04.q215; 163HP.HPE0-V27.v2026-09-04.q127; 187NAHQ.CPHQ.v2026-09-03.q481; 118SAP.C-S4CPB-2602.v2026-09-02.q7; 116Cisco.700-805.v2026-09-02.q86; 163MSSC.CLT-4.0.v2026-09-02.q43; 131Fitness.NCSF-CPT.v2026-09-02.q18; 199Google.Generative-AI-Leader.v2026-09-02.q77; 144PECB.ISO-14001-Lead-Auditor.v2026-09-01.q39; 129Google.GCP-DE.v2026-09-01.q27

Question 161

Question 162

Question 163

Question 164

Question 165

Download PDF File