Free Snowflake COF-R02 Practice Exam with Questions & Answers | Set: 4

STRUCT

OBJECT

BINARY

ARRAY

CLOB

SCIM

Federated authentication

TLS 1.2

Key-pair authentication

OAuth

OCSP authentication

Through the Snowflake web interface (Ul)

Through the DATA_SHARE=TRUE parameter

Through SQL commands

Through the enable__share=true parameter

Using the CREATE SHARE AS SELECT * TABLE command

8-16 MB

16-24 MB

10-99 MB

100-250 MB

Query execution

Data loading

Time Travel data

Security

Authentication and access control

grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on all tables in database DB1 to role MYROLE;

grant SELECT on future tables in database DB1 to role MYROLE;

In the metadata of the target table for 14 days

In the metadata of the pipe for 14 days

In the metadata of the target table for 64 days

In the metadata of the pipe for 64 days

CHECK_JSON

TO_JSON

FLATTEN

PARSE_JSON

Compute

Data storage

Cloud services

Cloud provider

Whether or not it is also a secure view

How often the underlying base table is queried

How often the base table changes

Whether the materialized view has a cluster key defined

How often the materialized view is queried