Can Masking policies be applied to virtual columns?

• A.FALSE
• B.TRUE

Comment: *

Name: *

Email: *

Verification: *

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

• A.PUBLIC
• B.SYSADMIN
• C.CUSTOM ROLE
• D.SECURITYADMIN

Comment: *

Name: *

Email: *

Verification: *

As Data Engineer, you have been asked to access data held in AWS Glacier Deep Archive storage class for Historical Data Analysis, which one is the correct statement to recommend?

• A.You cannot access data held in archival cloud storage classes that requires restoration before it can be retrieved.
• B.Loading data from AWS cloud storage services is supported regardless of the cloud platform that hosts your Snowflake account.
• C.Data can be accessed from External stage using AWS Private link in this case.
• D.We can simply access AWS Glacier Deep Archive storage External Stage data using PUT command.
• E.Upload (i.e. stage) files to your cloud storage account using the tools provided by the cloud storage service.

Comment: *

Name: *

Email: *

Verification: *

If external software i.e. TIBCO, exports Data fields enclosed in quotes but inserts a leading space before the opening quotation character for each field, How Snowflake handle it? [Select 2]

• A.Snowflake automatically handles leading spaces by trimming implicitly & removes the quotation marks enclosing each field.
• B.field_optionally_enclosed_by option along with TRIM_IF function in COPY INTO statement can be used to handle this scenario successfully.
• C.Snowflake reads the leading space rather than the opening quotation character as the beginning of the field and the quotation characters are interpreted as string data.
  (Correct)
• D.COPY command trims the leading space and removes the quotation marks enclosing each field
  1.copy into SFtable
  2.from @%SFtable
  3.file_format = (type = csv trim_space=true field_optionally_enclosed_by = '0x22');

Comment: *

Name: *

Email: *

Verification: *

Changing the retention period for your account or individual objects changes the value for all lower-level objects that do not have a retention period explicitly set?

• A.TRUE
• B.FALSE

Comment: *

Name: *

Email: *

Verification: *