Question 1

What will happen to ALTER a column setting it to NOT NULL if it contains NULL values?

Options :

A : Snowflake deletes the rows with NULL values.

B : NULL values are changed to an empty string " "

C : Snowflake returns an error

D : NULL values are changed to 0

Answer: C

Question 2

Suppose you have two databases D1 and D2. Theses databases contain data required by business analysts in your organization. Based on their functional responsibilities, entry level analysts should have read only access to D1, but access to D2 should be given to advanced analysts only. Which option will you choose to setup the access?

Options :

A :

2020-09-06-20-26-48-21b07202e527a5b67bbba720952a3ecf

B :

C :

Answer: C

Question 3

A user named USER_01 needs access to create a materialized view on a schema EDW. STG_SCHEMA. How can this access be provided?

Options :

A : GRANT CREATE MATERIALIZED VIEW ON SCHEMA EDW.STG_SCHEMA TO USER USER_01;

B : GRANT CREATE MATERIALIZED VIEW ON DATABASE EDW TO USER USERJD1;

C : GRANT ROLE NEW_ROLE TO USER USER_01; GRANT CREATE MATERIALIZED VIEW ON SCHEMA ECW.STG_SCHEKA TO NEW_ROLE;

D : GRANT ROLE NEW_ROLE TO USER_01; GRANT CREATE MATERIALIZED VIEW ON EDW.STG_SCHEMA TO NEW_ROLE;

Answer: A

Question 4

After creating a database and a schema using the following commands:CREATE OR REPLACE DATABASE MY_DB DATA_RETENTION_TIME_IN_DAYS=30;CREATE OR REPLACE SCHEMA S1 DATA_RETENTION_TIME_IN_DAYS=50;How long will we be able to access the data from the schema using the Time Travel functionality if we drop the database?

Options :

A : 90 days.

B : 50 days.

C : The default time of the account.

D : 30 days.

Answer: D

Question 5

Your business team runs a set of identical queries every day after the batch ETL run is complete. From the following actions, what is the best action that you will recommend.

Options :

A : After the ETL run, execute the identical queries so that they remain in the result cache

B : After the ETL run, resize the warehouse to a larger warehouse

C : After the ETL run, copy the tables to another schema for the business users to query

Answer: A

Free SnowPro-Advanced-Architect Mock Exam – Practice Online Confidently

Buying Options: