Online Access Free Snowflake.DEA-C01.v2024-11-04.q118 Practice Test (Page 15)

DEA-C01 Exam Question 66

Marko, a Data Engineer is using Snowpipe for data loading in micro batches for one of the Finance Data workloads. There are set of files he attempted to load into the snowflake table using Snow-pipe. While monitoring he found that there are set of files has multiple issue, He queried the COPY_HISTORY view & checked the STATUS column which indicates whether a particular set of files was loaded, partially loaded, or failed to load. But he wants to view all errors in the files along with Load status, how he can check all errors?

A.He can check RETURN_ALL_ERROR_MESSAGE column in the COPY_HISTORY view which can provides a reason and view all errors in the files.

B.He can view all errors in the files, by executing a COPY INTO <table> statement with the VALIDATION_ERROR_MODE copy option set to RE-TURN_ALL_PIPE_ERRORS.

C.Marko can look out for FIRST_ERROR_MESSAGE column in the COPY_HISTORY view which can provides a reason why a file partially loaded or failed for all the files.

D.He can view all errors in the files, by executing a COPY INTO <table> statement with the VALIDATION_MODE copy option set to RETURN_ALL_ERRORS.

DEA-C01 Exam Question 67

You have been tasked with migrating an on-premises MySQL database to Amazon Aurora PostgreSQL using AWS Database Migration Service (DMS). The stakeholder emphasizes that the source database must remain fully operational during the migration process.
Which of the following statements about DMS is accurate with respect to this scenario?

A.AWS DMS supports both full-load and continuous replication, allowing the source MySQL database to remain operational during migration.

B.AWS DMS only supports full-load migrations, which would require downtime for the source database.

C.AWS DMS can convert the MySQL database schema directly to PostgreSQL without any manual intervention.

D.When using DMS, the target Amazon Aurora PostgreSQL instance cannot be accessed or queried until the migration is complete.

E.AWS DMS requires the source MySQL database to be version 5.7 or higher for migrating to Amazon Aurora PostgreSQL.

DEA-C01 Exam Question 68

A company needs to set up a data catalog and metadata management for data sources that run in the AWS Cloud. The company will use the data catalog to maintain the metadata of all the objects that are in a set of data stores. The data stores include structured sources such as Amazon RDS and Amazon Redshift. The data stores also include semistructured sources such as JSON files and .xml files that are stored in Amazon S3.
The company needs a solution that will update the data catalog on a regular basis. The solution also must detect changes to the source metadata.
Which solution will meet these requirements with the LEAST operational overhead?

A.Use the AWS Glue Data Catalog as the central metadata repository. Use AWS Glue crawlers to connect to multiple data stores and to update the Data Catalog with metadata changes. Schedule the crawlers to run periodically to update the metadata catalog.

B.Use Amazon Aurora as the data catalog. Create AWS Lambda functions that will connect to the data catalog. Configure the Lambda functions to gather the metadata information from multiple sources and to update the Aurora data catalog. Schedule the Lambda functions to run periodically.

C.Use the AWS Glue Data Catalog as the central metadata repository. Extract the schema for Amazon RDS and Amazon Redshift sources, and build the Data Catalog. Use AWS Glue crawlers for data that is in Amazon S3 to infer the schema and to automatically update the Data Catalog.

D.Use Amazon DynamoDB as the data catalog. Create AWS Lambda functions that will connect to the data catalog. Configure the Lambda functions to gather the metadata information from multiple sources and to update the DynamoDB data catalog. Schedule the Lambda functions to run periodically.

DEA-C01 Exam Question 69

Select the Correct statements with regard to using Federated authentication/SSO?

A.Snowflake supports using MFA in conjunction with SSO to provide additional levels of security.

B.Snowflake supports multiple audience values (i.e. Audience or Audience Restriction Fields) in the SAML 2.0 assertion from the identity provider to Snowflake.

C.Snowflake supports using SSO with organizations, and you can use the corresponding URL in the SAML2 security integration.

D.Snowflake supports SSO with Private Connectivity to the Snowflake Service for Snow-flake accounts on Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform.

DEA-C01 Exam Question 70

To troubleshoot data load failure in one of your Copy Statement, Data Engineer have Executed a COPY statement with the VALIDATION_MODE copy option set to RETURN_ALL_ERRORS with reference to the set of files he had attempted to load. Which below function can facilitate analysis of the problematic records on top of the Results produced? [Select 2]

A.RESULT_SCAN

B.LAST_QUERY_ID

C.Rejected_record

D.LOAD_ERROR

Other Version: 1912Snowflake.DEA-C01.v2025-05-21.q101; 1502Snowflake.DEA-C01.v2023-08-10.q54

Latest Upload: 143CrowdStrike.CCSE-204.v2026-06-12.q25; 163VMware.2V0-17.25.v2026-06-12.q49; 154Appian.ACA-100.v2026-06-11.q23; 210CompTIA.220-1202.v2026-06-11.q114; 164CheckPoint.156-590.v2026-06-11.q47; 225CompTIA.220-1202.v2026-06-10.q109; 210CertiProf.CEHPC.v2026-06-10.q54; 152Hitachi.HQT-4160.v2026-06-10.q25; 405PMI.PMI-ACP-CN.v2026-06-09.q453; 193Splunk.SPLK-5002.v2026-06-08.q52

DEA-C01 Exam Question 66

DEA-C01 Exam Question 67

DEA-C01 Exam Question 68

DEA-C01 Exam Question 69

DEA-C01 Exam Question 70

Download PDF File