← Back to exam page

Free SNOWPRO-ADVANCED-DATA-ENGINEER – Snowflake SNOWPRO-ADVANCED-DATA-ENGINEER Practice Test Question

Loading demo links...

Showing 10–12 of 13 questions

Question 10 (Topic 1)

A Data Engineer is trying to clone a very large table from a source environment that has set DATA_RETENTION_TIME_IN_DAYS = 0. During the cloning operation, Data Manipulation Language (DML) transactions are executed on the source table, and the user receives the error "Data is not available." How can this error be prevented, while ensuring successful cloning of the table? (Choose two.)

Select an option, then click Submit answer.

  • ○ Increase the warehouse size to speed up the cloning process and avoid DML conflicts.
  • ○ Set the DATA_RETENTION_TIME_IN_DAYS = 1 for the table in the source environment before starting the cloning process, and revert it to = 0 after the clone is completed.
  • ○ Avoid all DML transactions on the source table until the cloning operation is complete.
  • ○ Disable Time Travel on the cloned table to reduce storage costs once the cloning is complete.
  • ○ Use a CREATE TABLE AS SELECT STATEMENT to create a new table, instead of creating a clone.
Question 11 (Topic 1)

A Data Engineer needs to create a tag-based masking policy to determine whether data should be masked based on the value of the label string assigned to column salary in table staff. The Engineer created the tag and masking policy with these commands: USE SCHEMA governance.tags; CREATE TAG hr_col_salary; USE ROLE masking_admin; USE SCHEMA governance.masking_policies; CREATE MASKING POLICY salary_mask_tag_policy AS (val number) RETURNS number -> CASE - WHEN SYSTEM$GET_TAG_ON_CURRENT_COLUMN('tags.hr_col_salary') = 'visible' or 'payroll_admin' = current_role() THEN val ELSE -1 - END; ALTER TAG hr_col_salary SET - MASKING POLICY salary_mask_tag_policy; How should the Engineer apply the tag to ensure that only users with the payroll_admin role can access the data?

Select an option, then click Submit answer.

  • ○

  • ○

  • ○

  • ○

Question 12 (Topic 1)

A Data Engineer created table t1 and applied a projection policy, my_proj_policy to several columns: What effect will the policy have on columns account_number and account_type? (Choose three.)

Select an option, then click Submit answer.

  • ○ The columns cannot be used to insert data into another table.
  • ○ The columns will be masked and will only be visible to a defined user role.
  • ○ These columns cannot pass an argument to an external function or external stored procedure.
  • ○ The data in these columns will not be included in query results.
  • ○ Tags can now be placed on these columns.
  • ○ The columns cannot be used in a WHERE clause.