ExamGecko
Home / Snowflake / SnowPro Core
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 30

Question list
Search

Question 291

Report
Export
Collapse

A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables. Which set operator should be used?

INTERSECT
INTERSECT
MFRCK
MFRCK
MINUS
MINUS
UNION
UNION
Suggested answer: A

Explanation:

To find out which numeric values are present in both tables, the INTERSECT set operator should be used.This operator returns rows from one query's result set which also appear in another query's result set, effectively finding the common elements between the two tables45.

asked 23/09/2024
Teste Teste
39 questions

Question 292

Report
Export
Collapse

What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).

A VARIANT column
A VARIANT column
A column with very low cardinality
A column with very low cardinality
A column with very high cardinality
A column with very high cardinality
A column that is most actively used in selective filters
A column that is most actively used in selective filters
A column that is most actively used in join predicates
A column that is most actively used in join predicates
Suggested answer: C, D

Explanation:

Snowflake recommends using columns with very high cardinality and those that are most actively used in selective filters as clustering keys. High cardinality columns have a wide range of unique values, which helps in evenly distributing the data across micro-partitions. Columns used in selective filters help in pruning the number of micro-partitions to scan, thus improving query performance.

Reference: Based on general database optimization principles.

asked 23/09/2024
Hendrik van Bemmel
32 questions

Question 293

Report
Export
Collapse

Which of the following describes the Snowflake Cloud Services layer?

Coordinates activities in the Snowflake account
Coordinates activities in the Snowflake account
Executes queries submitted by the Snowflake account users
Executes queries submitted by the Snowflake account users
Manages quotas on the Snowflake account storage
Manages quotas on the Snowflake account storage
Manages the virtual warehouse cache to speed up queries
Manages the virtual warehouse cache to speed up queries
Suggested answer: A

Explanation:

The Snowflake Cloud Services layer coordinates activities within the Snowflake account. It is responsible for tasks such as authentication, infrastructure management, metadata management, query parsing and optimization, and access control.

Reference: Based on general cloud database architecture knowledge.

asked 23/09/2024
Crystal Eagle
31 questions

Question 294

Report
Export
Collapse

What does Snowflake recommend regarding database object ownership? (Select TWO).

Create objects with ACCOUNTADMIN and do not reassign ownership.
Create objects with ACCOUNTADMIN and do not reassign ownership.
Create objects with SYSADMIN.
Create objects with SYSADMIN.
Create objects with SECURITYADMIN to ease granting of privileges later.
Create objects with SECURITYADMIN to ease granting of privileges later.
Create objects with a custom role and grant this role to SYSADMIN.
Create objects with a custom role and grant this role to SYSADMIN.
Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.
Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.
Suggested answer: B, D

Explanation:

Snowflake recommends creating objects with a role that has the necessary privileges and is not overly permissive. SYSADMIN is typically used for managing system-level objects and operations. Creating objects with a custom role and granting this role to SYSADMIN allows for more granular control and adherence to the principle of least privilege.

Reference: Based on best practices for database object ownership and role management.

asked 23/09/2024
Mary Andreou
46 questions

Question 295

Report
Export
Collapse

If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?

1 minute
1 minute
2 minutes
2 minutes
6 minutes
6 minutes
8 minutes
8 minutes
Suggested answer: B

Explanation:

In a multi-cluster warehouse with an economy scaling policy, queries will wait in the queue for 2 minutes before another cluster is started. This is to minimize costs by allowing queries to queue up for a short period before adding additional compute resources.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Jasper Fons
38 questions

Question 296

Report
Export
Collapse

How can a Snowflake user access a JSON object, given the following table? (Select TWO).

Snowflake SnowPro Core image Question 296 74657 09232024004504000000

src:salesperson.name
src:salesperson.name
src:sa1esPerson. name
src:sa1esPerson. name
src:salesperson.Name
src:salesperson.Name
SRC:salesperson.name
SRC:salesperson.name
SRC:salesperson.Name
SRC:salesperson.Name
Suggested answer: A, C

Explanation:

To access a JSON object in Snowflake, dot notation is used where the path to the object is specified after the column name containing the JSON data. Both lowercase and uppercase can be used for attribute names, so both ''name'' and ''Name'' are valid.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Vishal Vitthal Pawar
41 questions

Question 297

Report
Export
Collapse

What happens when a database is cloned?

It does not retain any privileges granted on the source object.
It does not retain any privileges granted on the source object.
It replicates all granted privileges on the corresponding source objects.
It replicates all granted privileges on the corresponding source objects.
It replicates all granted privileges on the corresponding child objects.
It replicates all granted privileges on the corresponding child objects.
It replicates all granted privileges on the corresponding child schema objects.
It replicates all granted privileges on the corresponding child schema objects.
Suggested answer: A

Explanation:

When a database is cloned in Snowflake, it does not retain any privileges that were granted on the source object. The clone will need to have privileges reassigned as necessary for users to access it.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Anand Prakash
31 questions

Question 298

Report
Export
Collapse

Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)

NUMBER
NUMBER
OBJECT
OBJECT
STRING
STRING
VARCHAR
VARCHAR
VARIANT
VARIANT
Suggested answer: B, E

Explanation:

Snowflake supports semi-structured data types, which include OBJECT and VARIANT. These data types are capable of storing JSON-like data structures, allowing for flexibility in data representation.OBJECT can directly contain VARIANT, and thus indirectly contain any other data type, including itself1.

asked 23/09/2024
Reneus Martini
33 questions

Question 299

Report
Export
Collapse

Snowflake's hierarchical key mode includes which keys? (Select TWO).

Account master keys
Account master keys
Database master keys
Database master keys
File keys
File keys
Secure view keys
Secure view keys
Schema master keys
Schema master keys
Suggested answer: A, C

Explanation:

Snowflake's hierarchical key model includes several levels of keys, where Account master keys and File keys are part of this hierarchy.Account master keys are used to encrypt all the data within an account, while File keys are used to encrypt individual files within the database2.

asked 23/09/2024
Christopher Schmidt
38 questions

Question 300

Report
Export
Collapse

How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?

Use Snowpipe.
Use Snowpipe.
Use the INSERT command.
Use the INSERT command.
Use an external table.
Use an external table.
Use the COPY command.
Use the COPY command.
Suggested answer: D

Explanation:

Snowflake recommends using the COPY command for bulk loading data batches from files already available in cloud storage.This command allows for efficient and large-scale data loading operations from files staged in cloud storage into Snowflake tables3.

asked 23/09/2024
Jason Kelley
34 questions
Total 627 questions
Go to page: of 63