A Data Engineer defines the following masking policy:

....
must be applied to the full_name column in the customer table:

Which query will apply the masking policy on the full_name column?

• A.ALTER TABLE customer MODIFY COLUMN full_name Set MASKING POLICY name_policy;
• B.ALTER TABLE customer MODIFY COLUMN full_nam ADD MASKING POLICY name_poiicy;
• C.ALTER TABLE customer MODIFY COLUMN first_nane SET MASKING POLICY name_policy; lasT_name SET MASKING POLICY name_pclicy;
• D.ALTER TABLE customer MODIFY COLUMN first_name ADD MASKING POLICY name_policy,

Comment: *

Name: *

Email: *

Verification: *

Mark the Correct Statements for the VALIDATION_MODE option used by Data Engineer for Da-ta loading operations in his/her COPY INTO <table> command:

• A.VALIDATION_MODE instructs the COPY command to validate the data files instead of loading them into the specified table; i.e., the COPY command tests the files for er-rors but does not load them.
• B.VALIDATION_MODE option supported these values:
  RETURN_n_ROWS,
  RETURN_ERRORS,
  RETURN_ALL_ERRORS
• C.VALIDATION_MODE does not support COPY statements that transform data during a load. If the parameter is specified, the COPY statement returns an error.
• D.VALIDATION_MODE only support Data loading operation i.e., do not work while da-ta unloading.

Comment: *

Name: *

Email: *

Verification: *

As a Data Engineer, you have requirement to query most recent data from the Large Dataset that reside in the external cloud storage, how would you design your data pipelines keeping in mind fastest time to delivery?

• A.Data pipelines would be created to first load data into internal stages & then into Per-manent table with SCD Type 2 transformation.
• B.Direct Querying External tables on top of existing data stored in external cloud storage for analysis without first loading it into Snowflake.
• C.Unload data into SnowFlake Internal data storage using PUT command.
• D.Snowpipe can be leveraged with streams to load data in micro batch fashion with CDC streams that capture most recent data only.
• E.External tables with Materialized views can be created in Snowflake.

Comment: *

Name: *

Email: *

Verification: *

A Data Engineer is working on a Snowflake deployment in AWS eu-west-1 (Ireland). The Engineer is planning to load data from staged files into target tables using the copy into command Which sources are valid? (Select THREE)

• A.Internal stage on GCP us-central1 (Iowa)
• B.Internal stage on AWS eu-central-1 (Frankfurt)
• C.External stage on GCP us-central1 (Iowa)
• D.External stage in an Amazon S3 bucket on AWS eu-west-1 (Ireland)
• E.External stage in an Amazon S3 bucket on AWS eu-central 1 (Frankfurt)
• F.SSO attached to an Amazon EC2 instance on AWS eu-west-1 (Ireland)

Comment: *

Name: *

Email: *

Verification: *

Snowflake supports using key pair authentication for enhanced authentication security as an alterna-tive to basic authentication (i.e. username and password). Select the list of SnowFlake Clients sup-port the same?
[Select All that Apply]

• A.SnowCD
• B.SnowFlake Connector for Spark
• C.SnowSQL
• D.Go Driver
• E.Node.js

Comment: *

Name: *

Email: *

Verification: *