A Snowflake Architect created a new data share and would like to verify that only specific records in secure views are visible within the data share by the consumers.
What is the recommended way to validate data accessibility by the consumers?

• A.Create reader accounts as shown below and impersonate the consumers by logging in with their credentials.
  create managed account reader_acctl admin_name = userl , adroin_password 'Sdfed43da!44T , type = reader;
• B.Create a row access policy as shown below and assign it to the data share.
  create or replace row access policy rap_acct as (acct_id varchar) returns boolean -> case when
  'acctl_role' = current_role() then true else false end;
• C.Set the session parameter called SIMULATED_DATA_SHARING_C0NSUMER as shown below in order to impersonate the consumer accounts.
  alter session set simulated_data_sharing_consumer - 'Consumer Acctl*
• D.Alter the share settings as shown below, in order to impersonate a specific consumer account.
  alter share sales share set accounts = 'Consumerl' share restrictions = true

Comment: *

Name: *

Email: *

Verification: *

Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query.

This command results in the following error:
SQL compilation error: invalid parameter 'validation_mode'
Assuming the syntax is correct, what is the cause of this error?

• A.The VALIDATION_MODE parameter supports COPY statements that load data from external stages only.
• B.The VALIDATION_MODE parameter does not support COPY statements with CSV file formats.
• C.The VALIDATION_MODE parameter does not support COPY statements that transform data during a load.
• D.The value return_all_errors of the option VALIDATION_MODE is causing a compilation error.

Comment: *

Name: *

Email: *

Verification: *

A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition.
How can this data be shared?

• A.The healthcare company will need to change the institute's Snowflake edition in the accounts panel.
• B.By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.
• C.Contact Snowflake and they will execute the share request for the healthcare company.
• D.Set the share_restriction parameter on the shared object to false.

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake data modeling approach is designed for BI queries?

• A.3 NF
• B.Star schema
• C.Data Vault
• D.Snowflake schema

Comment: *

Name: *

Email: *

Verification: *

An Architect runs the following SQL query:

How can this query be interpreted?

• A.FILEROWS is a stage. FILE_ROW_NUMBER is line number in file.
• B.FILEROWS is the table. FILE_ROW_NUMBER is the line number in the table.
• C.FILEROWS is a file. FILE_ROW_NUMBER is the file format location.
• D.FILERONS is the file format location. FILE_ROW_NUMBER is a stage.

Comment: *

Name: *

Email: *

Verification: *