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

Question 121

A data engineer needs to run a data transformation job whenever a user adds a file to an Amazon S3 bucket. The job will run for less than 1 minute. The job must send the output through an email message to the data engineer. The data engineer expects users to add one file every hour of the day.
Which solution will meet these requirements in the MOST operationally efficient way?

A.Create a small Amazon EC2 instance that polls the S3 bucket for new files. Run transformation code on a schedule to generate the output. Use operating system commands to send email messages.

B.Run an Amazon Elastic Container Service (Amazon ECS) task to poll the S3 bucket for new files.
Run transformation code on a schedule to generate the output. Use operating system commands to send email messages.

C.Create an AWS Lambda function to transform the data. Use Amazon S3 Event Notifications to invoke the Lambda function when a new object is created. Publish the output to an Amazon Simple Notification Service (Amazon SNS) topic. Subscribe the data engineer's email account to the topic.

D.Deploy an Amazon EMR cluster. Use EMR File System (EMRFS) to access the files in the S3 bucket. Run transformation code on a schedule to generate the output to a second S3 bucket.Create an Amazon Simple Notification Service (Amazon SNS) topic. Configure Amazon S3 Event Notifications to notify the topic when a new object is created.

Question 122

A media streaming company uses AWS Glue to process and analyze viewer engagement data stored in Amazon S3. They have implemented incremental data processing in their Glue Jobs to only process new data since the last job run. However, they are encountering issues with job reliability and consistency due to inconsistencies in bookmark management.
Which of the following options describes the purpose and functionality of Glue Job bookmarks?

A.Glue Job bookmarks are used to track the progress of Glue Jobs and resume processing from the last bookmarked state in case of job failures or interruptions.

B.Glue Job bookmarks are static references to the location of input data in Amazon S3, ensuring consistent data processing across job runs.

C.Glue Job bookmarks are used to record the start and end times of Glue Jobs, allowing administrators to monitor job execution durations and performance.

D.Glue Job bookmarks are dynamic pointers to the latest data processed by Glue Jobs, enabling incremental data processing by skipping already processed data.

Question 123

A company receives .csv files that contain physical address data. The data is in columns that have the following names: Door_No, Street_Name, City, and Zip_Code. The company wants to create a single column to store these values in the following format:

Which solution will meet this requirement with the LEAST coding effort?

A.Use AWS Glue DataBrew to read the files. Use the NEST_TO_ARRAY transformation to create the new column.

B.Write a Lambda function in Python to read the files. Use the Python data dictionary type to create the new column.

C.Use AWS Glue DataBrew to read the files. Use the PIVOT transformation to create the new column.

D.Use AWS Glue DataBrew to read the files. Use the NEST_TO_MAP transformation to create the new column.

Question 124

Which Snowflake feature facilitates access to external API services such as geocoders. data transformation, machine Learning models and other custom code?

A.Security integration

B.External tables

C.External functions

D.Java User-Defined Functions (UDFs)

Question 125

A company that operates globally must follow regulations that require data from an AWS Region to be accessible only within that Region.
A data engineer is creating a data pipeline that will create resources in the Region where the data engineer works. The data pipeline should have access to data only from the Region where the data engineer works. The pipeline uses Active Directory as an identity and authentication system.
The pipeline uses a custom identity broker application to verify that employees are signed in to Active Directory and to obtain temporary credentials by using the AssumeRole API operation.
Which solution will meet the locality requirements with the LEAST administrative effort?

A.Create an IAM role that has permissions to create resources. Create a policy for each Region that ensures users can create resources only in that Region. Pass the policy as the session policy when employees obtain the temporary credentials.

B.Create an IAM role for data engineers in each Region separately. Instruct each data engineer to obtain temporary credentials by assuming the appropriate Region specific IAM role.

C.Create an IAM group for each Region. Include the required IAM policies for each IAM group. Add users to each IAM group so that when users log in by obtaining the temporary credentials, the users will receive the appropriate access based on the IAM group.

D.Create individual IAM policies that allow users to create resources in a specific Region. Assign the policies to each data engineer. Allow users to assume the individually assigned role when the users log in to AWS.

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

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

Question 121

Question 122

Question 123

Question 124

Question 125

Download PDF File