ExamGecko
Home / Snowflake / SnowPro Core
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 35

Question list
Search

Question 341

Report
Export
Collapse

Which task privilege does a Snowflake role need in order to suspend or resume a task?

USAGE
USAGE
OPERATE
OPERATE
MONITOR
MONITOR
OWNERSHIP
OWNERSHIP
Suggested answer: B

Explanation:

In Snowflake, the OPERATE privilege is required for a role to suspend or resume a task.This privilege allows the role to perform operational tasks such as starting and stopping tasks, which includes suspending and resuming them6

asked 23/09/2024
James Morris
35 questions

Question 342

Report
Export
Collapse

Which role has the ability to create and manage users and roles?

ORGADMIN
ORGADMIN
USERADMIN
USERADMIN
SYSADMIN
SYSADMIN
SECURITYADMIN
SECURITYADMIN
Suggested answer: B

Explanation:

The USERADMIN role in Snowflake has the ability to create and manage users and roles within the Snowflake environment.This role is specifically dedicated to user and role management and creation

Topic 4, Exam pool D

asked 23/09/2024
Matthew McConnell
41 questions

Question 343

Report
Export
Collapse

Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).

A user with an USERADMIN or higher role
A user with an USERADMIN or higher role
A user with a SECURITYADMIN or higher role
A user with a SECURITYADMIN or higher role
A role that has been granted the ATTACH POLICY privilege
A role that has been granted the ATTACH POLICY privilege
A role that has the NETWORK_POLlCY account parameter set
A role that has the NETWORK_POLlCY account parameter set
A role that has the ownership of the network policy
A role that has the ownership of the network policy
Suggested answer: B, E

Explanation:

In Snowflake, a user with the SECURITYADMIN role or higher can activate and enforce a network policy for all users in an account.Additionally, a role that has ownership of the network policy can also activate and enforce it

asked 23/09/2024
Andrea Ciovati
41 questions

Question 344

Report
Export
Collapse

A permanent table and temporary table have the same name, TBL1, in a schema.

What will happen if a user executes select * from TBL1 ;?

The temporary table will take precedence over the permanent table.
The temporary table will take precedence over the permanent table.
The permanent table will take precedence over the temporary table.
The permanent table will take precedence over the temporary table.
An error will say there cannot be two tables with the same name in a schema.
An error will say there cannot be two tables with the same name in a schema.
The table that was created most recently will take precedence over the older table.
The table that was created most recently will take precedence over the older table.
Suggested answer: A

Explanation:

In Snowflake, if a temporary table and a permanent table have the same name within the same schema, the temporary table takes precedence over the permanent table within the session where the temporary table was created4.

asked 23/09/2024
Benvindo Almeida
41 questions

Question 345

Report
Export
Collapse

What tasks can an account administrator perform in the Data Exchange? (Select TWO).

Add and remove members.
Add and remove members.
Delete data categories.
Delete data categories.
Approve and deny listing approval requests.
Approve and deny listing approval requests.
Transfer listing ownership.
Transfer listing ownership.
Transfer ownership of a provider profile.
Transfer ownership of a provider profile.
Suggested answer: A, C

Explanation:

An account administrator in the Data Exchange can perform tasks such as adding and removing members and approving or denying listing approval requests.These tasks are part of managing the Data Exchange and ensuring that only authorized listings and members are part of it12.

asked 23/09/2024
Lourdhureddy Kommareddy
29 questions

Question 346

Report
Export
Collapse

Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).

Bytes scanned
Bytes scanned
Bytes written to result
Bytes written to result
Partitions scanned
Partitions scanned
Partitions total
Partitions total
Percentage scanned from cache
Percentage scanned from cache
Suggested answer: C, D

Explanation:

The statistics that can be used to identify queries with inefficient pruning are 'Partitions scanned' and 'Partitions total'.These statistics indicate how much of the data was actually needed and scanned versus the total available, which can highlight inefficiencies in data pruning34.

asked 23/09/2024
frederic Morteau
31 questions

Question 347

Report
Export
Collapse

Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?

USAGE_VIEWER
USAGE_VIEWER
GOVERNANCE_VIEWER
GOVERNANCE_VIEWER
OBJECT_VIEWER
OBJECT_VIEWER
SECURITY_VIEWER
SECURITY_VIEWER
Suggested answer: B

Explanation:

The GOVERNANCE_VIEWER role in the ACCOUNT_USAGE schema provides visibility into policy-related information within Snowflake.This role is specifically designed to access views that display object metadata and usage metrics related to governance12.

asked 23/09/2024
J. Cuylits
34 questions

Question 348

Report
Export
Collapse

Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)

INTEGER
INTEGER
OBJECT
OBJECT
VARIANT
VARIANT
VARCHAR
VARCHAR
LIST
LIST
Suggested answer: B, C

Explanation:

The Snowflake data types that can be used to build nested hierarchical data are OBJECT and VARIANT.These data types support the storage and querying of semi-structured data, allowing for the creation of complex, nested data structures

asked 23/09/2024
umar raad
36 questions

Question 349

Report
Export
Collapse

How can a dropped internal stage be restored?

Enable Time Travel.
Enable Time Travel.
Clone the dropped stage.
Clone the dropped stage.
Execute the UNDROP command.
Execute the UNDROP command.
Recreate the dropped stage.
Recreate the dropped stage.
Suggested answer: D

Explanation:

Once an internal stage is dropped in Snowflake, it cannot be recovered or restored using Time Travel or UNDROP commands.The only option is to recreate the dropped stage

asked 23/09/2024
Christophe Troessaert
37 questions

Question 350

Report
Export
Collapse

Who can grant object privileges in a regular schema?

Object owner
Object owner
Schema owner
Schema owner
Database owner
Database owner
SYSADMIN
SYSADMIN
Suggested answer: A

Explanation:

In a regular schema within Snowflake, the object owner has the privilege to grant object privileges.The object owner is typically the role that created the object or to whom the ownership of the object has been transferred78.

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

asked 23/09/2024
Mary Cris Barreda
33 questions
Total 627 questions
Go to page: of 63