A user needs access to create materialized view on a shema mydb.myschema.
What is the appropriate command to provide the access?

• A.GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
• B.GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
• C.GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

Comment: *

Name: *

Email: *

Verification: *

Running EXPLAIN on a query does not require a running warehouse

• A.FALSE
• B.TRUE

Comment: *

Name: *

Email: *

Verification: *

You have created a reader account for sharing data. who will pay for the compute usage of the account

• A.Consumer
• B.Provider

Comment: *

Name: *

Email: *

Verification: *

As of today snowflake supports replication for databases only

• A.FALSE
• B.TRUE

Comment: *

Name: *

Email: *

Verification: *

You want to automatically delete the files from stage after a successful load using the COPY INTO command.
What will be recommended approach for deletion?

• A.Set PURGE=TRUE in the COPY INTO command
• B.No need to do anything, snowflake does it automatically
• C.Set REMOVE=TRUE in the COPY INTO Command

Comment: *

Name: *

Email: *

Verification: *