Question 1

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

Options :

A : GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

B : GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

C : GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

D : GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Answer: D

Question 2

When does a materialized view get suspended in Snowflake?

Options :

A : When a column is added to the base table

B : When a column is dropped from the base table

C : When a DML operation is run on the base table

D : When the base table is reclustered

Answer: B

Question 3

Which commands are restricted in owner's rights stored procedures? (Select TWO).

Options :

A : SHOW

B : MERGE

C : INSERT

D : DELETE

E : DESCRIBE

Answer: A,E

Question 4

What tasks can be completed using the copy command? (Select TWO)

Options :

A : Columns can be aggregated

B : Columns can be joined with an existing table

C : Columns can be reordered

D : Columns can be omitted

E : Data can be loaded without the need to spin up a virtual warehouse

Answer: C,D

Question 5

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?

Options :

A : Create a zero-copy clone of the worksheet and grant permissions to teammates

B : Create a private Data Exchange so that any teammate can use the worksheet

C : Share the worksheet with teammates within Snowsight

D : Create a database and grant all permissions to teammates

Answer: C

Higher Test Marks with Free Online SnowPro-Core Exam Practice