COF-R02 Exam Dumps - Snowflake SnowPro Core Certification Questions and Answers

12am-5am

Only during administrator defined time slots

When its provisioning is complete

After replication

True

False

4

16

32

128

True

False

It was built specifically for the cloud

It was built as an on-premises solution and then ported to the cloud

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

It was built for Hadoop architecture

It's based on an Oracle Architecture

Temporary

Translent

Provisional

Permanent

A single join node uses more than 50% of the query time

Partitions scanned is equal to partitions total

An AggregateOperacor node is present

The query is spilling to remote storage

Compute resources

Query execution

Authentication

Data storage

Metadata

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

They happen approximately weekly

They roll up and release approximately monthly, but customers can request early release application

During a release, new customer requests/queries/connections transparently move over to the newer

version

A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the

system will be unavailable and customer is upgraded