Snowflake is designed for which type of workloads? (Choose two.)

• A.OLAP (Analytics) workloads
• B.OLTP (Transactional) workloads
• C.Concurrent workloads
• D.On-premise workloads

Comment: *

Name: *

Email: *

Verification: *

If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?

• A.60
• B.91
• C.120
• D.121

Comment: *

Name: *

Email: *

Verification: *

Which system_defined, read-only view display information on column lineage that specifies how data flows from source to target in a SQL write operation?

• A.ACCESS_HISTORY
• B.LOAD_HOSTORY
• C.QUERY_HISTORY
• D.COPY_HISTORY

Comment: *

Name: *

Email: *

Verification: *

True or False: You can query the files in an External Stage directly without having to load the data into a table.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *

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

• A.GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
• B.GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
• C.GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K"-'SCHEMA TO USER! ;
• D.GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE
  MYROLE;

Comment: *

Name: *

Email: *

Verification: *