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

Question 26

Which Role inherits the privileges of the USERADMIN role via the system role hierarchy?

A.PUBLIC

B.SYSADMIN

C.SECURITYADMIN

D.CUSTOM ROLE

Question 27

A company is migrating its database servers from Amazon EC2 instances that run Microsoft SQL Server to Amazon RDS for Microsoft SQL Server DB instances. The company's analytics team must export large data elements every day until the migration is complete. The data elements are the result of SQL joins across multiple tables. The data must be in Apache Parquet format. The analytics team must store the data in Amazon S3.
Which solution will meet these requirements in the MOST operationally efficient way?

A.Use a SQL query to create a view in the EC2 instance-based SQL Server databases that contains the required data elements. Create and run an AWS Glue crawler to read the view.
Create an AWS Glue job that retrieves the data and transfers the data in Parquet format to an S3 bucket. Schedule the AWS Glue job to run every day.

B.Schedule SQL Server Agent to run a daily SQL query that selects the desired data elements from the EC2 instance-based SQL Server databases. Configure the query to direct the output .csv objects to an S3 bucket. Create an S3 event that invokes an AWS Lambda function to transform the output format from .csv to Parquet.

C.Create an AWS Lambda function that queries the EC2 instance-based databases by using Java Database Connectivity (JDBC). Configure the Lambda function to retrieve the required data, transform the data into Parquet format, and transfer the data into an S3 bucket. Use Amazon EventBridge to schedule the Lambda function to run every day.

D.Create a view in the EC2 instance-based SQL Server databases that contains the required data elements. Create an AWS Glue job that selects the data directly from the view and transfers the data in Parquet format to an S3 bucket. Schedule the AWS Glue job to run every day.

Question 28

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.

Question 29

Which functions will compute a 'fingerprint' over an entire table, query result, or window to quickly detect changes to table contents or query results? (Select TWO).

A.HASH (*)

B.HASH_AGG(*)

C.HASH_AGG(<expr>, <expr>)

D.HASH_AGG_COMPARE (*)

E.HASH COMPARE(*)

Question 30

Which of the following best describes the type of data found in traditional relational databases?

A.Semi-structured data

B.Structured data

C.Unstructured data

D.Free-form data

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

Latest Upload: 121Fortinet.NSE7_SSE_AD-25.v2026-09-05.q85; 168Microsoft.PL-400.v2026-09-05.q375; 298Snowflake.DEA-C01.v2026-09-04.q215; 193HP.HPE0-V27.v2026-09-04.q127; 249NAHQ.CPHQ.v2026-09-03.q481; 120SAP.C-S4CPB-2602.v2026-09-02.q7; 137Cisco.700-805.v2026-09-02.q86; 167MSSC.CLT-4.0.v2026-09-02.q43; 132Fitness.NCSF-CPT.v2026-09-02.q18; 204Google.Generative-AI-Leader.v2026-09-02.q77

Question 26

Question 27

Question 28

Question 29

Question 30

Download PDF File