ExamGecko
Home / Snowflake / COF-C02
Ask Question

Snowflake COF-C02 Practice Test - Questions Answers, Page 53

Question list
Search

Question 521

Report
Export
Collapse

How can a user get the MOST detailed information about individual table storage details in Snowflake?

SHOW TABLES command
SHOW TABLES command
SHOW EXTERNAL TABLES command
SHOW EXTERNAL TABLES command
TABLES view
TABLES view
TABLE STORAGE METRICS view
TABLE STORAGE METRICS view
Suggested answer: D

Explanation:

To get the most detailed information about individual table storage details in Snowflake, the TABLE STORAGE METRICS view should be used. This Information Schema view provides granular storage metrics for tables within Snowflake, including data related to the size of the table, the amount of data stored, and storage usage over time. It's an essential tool for administrators and users looking to monitor and optimize storage consumption and costs.

References:

Snowflake Documentation: Information Schema - TABLE STORAGE METRICS View

asked 23/09/2024
bijay ghimire
37 questions

Question 522

Report
Export
Collapse

What happens when a network policy includes values that appear in both the allowed and blocked IP address list?

Those IP addresses are allowed access to the Snowflake account as Snowflake applies the allowed IP address list first.
Those IP addresses are allowed access to the Snowflake account as Snowflake applies the allowed IP address list first.
Those IP addresses are denied access lei the Snowflake account as Snowflake applies the blocked IP address list first.
Those IP addresses are denied access lei the Snowflake account as Snowflake applies the blocked IP address list first.
Snowflake issues an alert message and adds the duplicate IP address values lo both 'he allowed and blocked IP address lists.
Snowflake issues an alert message and adds the duplicate IP address values lo both 'he allowed and blocked IP address lists.
Snowflake issues an error message and adds the duplicate IP address values to both the allowed and blocked IP address list
Snowflake issues an error message and adds the duplicate IP address values to both the allowed and blocked IP address list
Suggested answer: B

Explanation:

In Snowflake, when setting up a network policy that specifies both allowed and blocked IP address lists, if an IP address appears in both lists, access from that IP address will be denied. The reason is that Snowflake prioritizes security, and the presence of an IP address in the blocked list indicates it should not be allowed regardless of its presence in the allowed list. This ensures that access controls remain stringent and that any potentially unsafe IP addresses are not inadvertently permitted access.

References:

Snowflake Documentation: Network Policies

asked 23/09/2024
ABCO TECHNOLOGY
32 questions

Question 523

Report
Export
Collapse

What is the MINIMUM permission needed to access a file URL from an external stage?

MODIFY
MODIFY
READ
READ
SELECT
SELECT
USAGE
USAGE
Suggested answer: D

Explanation:

To access a file URL from an external stage in Snowflake, the minimum permission required is USAGE on the stage object. USAGE permission allows a user to reference the stage in SQL commands, necessary for actions like listing files or loading data from the stage, but does not permit the user to alter or drop the stage.

References:

Snowflake Documentation: Access Control

asked 23/09/2024
Cesar Castillo
31 questions

Question 524

Report
Export
Collapse

Which function will provide the proxy information needed to protect Snowsight?

SYSTEMADMIN_TAG
SYSTEMADMIN_TAG
SYSTEM$GET_PRIVATELINK
SYSTEM$GET_PRIVATELINK
SYSTEMSALLONTLIST
SYSTEMSALLONTLIST
SYSTEMAUTHORIZE
SYSTEMAUTHORIZE
Suggested answer: B

Explanation:

The SYSTEM$GET_PRIVATELINK function in Snowflake provides proxy information necessary for configuring PrivateLink connections, which can protect Snowsight as well as other Snowflake services. PrivateLink enhances security by allowing Snowflake to be accessed via a private connection within a cloud provider's network, reducing exposure to the public internet.

References:

Snowflake Documentation: PrivateLink Setup

asked 23/09/2024
John Hart
47 questions

Question 525

Report
Export
Collapse

Which command should be used to unload all the rows from a table into one or more files in a named stage?

COPY INTO
COPY INTO
GET
GET
INSERT INTO
INSERT INTO
PUT
PUT
Suggested answer: A

Explanation:

To unload data from a table into one or more files in a named stage, the COPY INTO <location> command should be used. This command exports the result of a query, such as selecting all rows from a table, into files stored in the specified stage. The COPY INTO command is versatile, supporting various file formats and compression options for efficient data unloading.

References:

Snowflake Documentation: COPY INTO Location

Topic 6, Exam pool F

asked 23/09/2024
Bas Vogel
41 questions

Question 526

Report
Export
Collapse

What type of account can be used to share data with a consumer who does have a Snowflake account?

Data provider
Data provider
Data consumer
Data consumer
Reader
Reader
Organization
Organization
Suggested answer: C

Explanation:

A Reader account in Snowflake can be used to share data with a consumer who does not have a Snowflake account. Reader accounts are a type of shared account provided by data providers to external data consumers, allowing them to access and query shared data using Snowflake's web interface without needing their own Snowflake account.

References:

Snowflake Documentation: Reader Accounts

asked 23/09/2024
Welton Harris
38 questions

Question 527

Report
Export
Collapse

Which privilege is needed for a SnowFlake user to see the definition of a secure view?

OWNERSHIP
OWNERSHIP
MODIFY
MODIFY
CREATE
CREATE
USAGE
USAGE
Suggested answer: A

Explanation:

To see the definition of a secure view in Snowflake, the minimum privilege required is OWNERSHIP of the view. Ownership grants the ability to view the definition as well as to modify or drop the view. Secure views are designed to protect sensitive data, and thus the definition of these views is restricted to users with sufficient privileges to ensure data security.

References:

Snowflake Documentation: Secure Views

asked 23/09/2024
Bianca Duizer
48 questions

Question 528

Report
Export
Collapse

Which function should be used to find the query ID of the second query executed in a current session?

Select LAST_QUERY_ID(-2)
Select LAST_QUERY_ID(-2)
Select LAST_QUERY_ID(2)
Select LAST_QUERY_ID(2)
Select LAST_QUERY_ID(1)
Select LAST_QUERY_ID(1)
Select LAST_QUERY_ID(2)
Select LAST_QUERY_ID(2)
Suggested answer: A

Explanation:

The correct function to find the query ID of the second query executed in the current session is SELECT LAST_QUERY_ID(-2). The LAST_QUERY_ID function returns the query ID for the most recent query executed in the session when called with no arguments. When used with an argument, it can retrieve the ID of previous queries within the same session, where -2 would reference the second most recent query executed.

References:

There's a clarification needed here; Snowflake's documentation indicates LAST_QUERY_ID() function does not accept arguments. It returns the ID of the last query executed in the session. To find the query ID of the second last executed query, users typically need to track query IDs manually or use session history views.

asked 23/09/2024
Jozsef Stelly
47 questions

Question 529

Report
Export
Collapse

Which command will unload data from a table into an external stage?

PUT
PUT
INSERT
INSERT
COPY INTO <location>
COPY INTO <location>
GET
GET
Suggested answer: C

Explanation:

In Snowflake, the COPY INTO <location> command is used to unload (export) data from a Snowflake table to an external stage, such as an S3 bucket, Azure Blob Storage, or Google Cloud Storage. This command allows users to specify the format, file size, and other options for the data being unloaded, making it a flexible solution for exporting data from Snowflake to external storage solutions for further use or analysis. References: Snowflake Documentation on Data Unloading

asked 23/09/2024
Alan Coutinho
42 questions

Question 530

Report
Export
Collapse

Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?

ACCOUNTADMIN
ACCOUNTADMIN
SECURITYADMIN
SECURITYADMIN
SYSADMIN
SYSADMIN
ORGADMIN
ORGADMIN
Suggested answer: A

Explanation:

The ACCOUNTADMIN role in Snowflake has the highest level of privileges, including the ability to manage accounts, users, roles, and all objects within the account. This role is specifically granted the permission to rename an account and specify whether the original URL can be used to access the renamed account. The ACCOUNTADMIN role encompasses broad administrative capabilities, ensuring that users assigned this role can perform critical account management tasks. References: Snowflake Documentation on Roles and Permissions

asked 23/09/2024
L Zsolt
38 questions
Total 716 questions
Go to page: of 72