Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

• A.CONTENT
• B.PATH
• C.BYTE_SIZE
• D.INDEX
• E.DATATYPE

Comment: *

Name: *

Email: *

Verification: *

A column named " Data " contains VARIANT data and stores values as follows:
How will Snowflake extract the employee ' s name from the column data?

• A.Data:employee.name
• B.DATA:employee.name
• C.data:Employee.name
• D.data:employee.name

Comment: *

Name: *

Email: *

Verification: *

What parameter setting will maximize parallel processing when unloading data from Snowflake?

• A.SINGLE = TRUE
• B.SINGLE = FALSE
• C.DETAILED_OUTPUT
• D.DETAILED OUTPUT = TRUE/FALSE

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake edition enables data sharing only through Snowflake Support?

• A.Virtual Private Snowflake
• B.Business Critical
• C.Enterprise
• D.Standard

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;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;

Comment: *

Name: *

Email: *

Verification: *