Quiz 2 - 2023-07-18

How could you protect a table with sensitive columns from being accessed by certain roles, without consuming more storage?

• Create a secure materialized view on the sensitive table, grant access only to the secure materialized view
• Create a secure view on the sensitive table, grant access only to the secure view
• Create a materialized view on the sensitive table, grant access only to the materialized view
• Create a view on the sensitive table, grant access only to the view.

Which feature can facilitate continuous data loading?

• Snowkafka
• Snowkinesis
• Snowpipe
• Snowrealtime
• Snowfirehose

You wish to export data from Snowflake. Which command will help with this?

• COPY FROM
• COPY INTO
• UNLOAD INTO
• EXPORT FROM

What are ways you can define when a task should run?

• Click the scheduling options in the Task wizard.
• Specify the AFTER option to automatically run a child task after its parent task has successfully completed.
• Specify an interval of time after which the task should run (such as 60 minutes).
• Use the SCHEDULE parameter to specify a time, date, day of the week, and similar options.

Which role has all privileges, so should be assigned to a limited number of people (and not as their default role)?

• SECURITYADMIN
• USERADMIN
• SYSADMIN
• ACCOUNTADMIN

If you were querying a table earlier, but now the query returns an error message and you no longer see the table in the Object Browser, what should you check first?

• Check with someone who can use the ACCOUNTADMIN role and ask them to make sure nothing happened to the table.
• Check which role you are currently using, as you may have switched to a role that does not have access to the table.
• Check with other users to find out if someone deleted the table.
• Check with Snowflake support to ask them to retrieve the table with Fail-safe.

How does Snowflake most commonly store semi-structured data, such as JSON, Avro, Parquet, ORC, and XML?

• Stored as JSON, AVRO, PARQUET, ORC, or XML data types
• Stored as CLOB, NCLOB, LOB, or BSON data types
• Stored as VARCHAR data type
• Stored as VARIANT data type

To refer to the value "temperature" in column "v" of a JSON data file, you can use SELECT v:temperature or SELECT v['temperature'].

• True
• False

How can you operate on values stored in semi-structured format, for example, to compare values, add or average values, or filter them?

• Use the UNRAVEL command
• CAST the values to SQL data types
• Use the FLATTEN command to pull out nested values
• Directly query the VARIANT column

Data sharing is _________.

• globally available
• subject to data transfer costs from Provider to Consumer
• available only for read-only access
• revokable at any time