Practice Tests COF-C02 - Mock Exam 4

Question 1

True or False

External tables are read-only.

Answer 1

True

Since external tables point to an external storage location, data manipulation language (DML) operations cannot be done on them. An external table can only be created against an external stage, which points to a cloud object storage location.

https://docs.snowflake.com/en/user-guide/tables-external-intro

Question 2

Views can be shared?

Answer 2

No

Standard and Materialized views cannot be shared.

Direct data sharing enables sharing of the following types of objects: Tables, External tables, Secure views, Secure materialized views, Secure UDFs.

https://docs.snowflake.com/en/user-guide/data-sharing-intro

Question 3

Is it possible to share data with a Snowflake customer whose Snowflake instance exists in a different region than the data provider?

Answer 3

Yes, but you must enable replication first to enable cross-region data sharing.

https://docs.snowflake.com/en/user-guide/secure-data-sharing-across-regions-plaforms

Question 4

True or False

The search optimization service requires an active virtual warehouse.

Answer 4

False

The search optimization service is a Snowflake-managed service; it executes in the background and doesn’t require a virtual warehouse. However, note that credit and storage costs are associated with Search optimization.

When the data in the table is changed (for example, by loading new data sets or performing their DML operations), the maintenance service updates the search access path to reflect the changes. The search optimization configuration on a table and the maintenance service are transparent to the users.

https://docs.snowflake.com/en/user-guide/search-optimization-service

Question 5

True or False

External Tables can be cloned

Answer 5

False

Cloning for an external table is not supported. The data for external tables sits outside Snowflake; therefore, cloning an external table does not work.

Named Internal Stages cannot be cloned.

When a database or schema is cloned, any Snowpipe that points to a Named Internal Stage is not cloned.

https://docs.snowflake.com/en/user-guide/object-clone

Question 6

True or False

A share object has information about the consumer(s)

Answer 6

True

A share acts as a container for objects that need to be shared. A share object encapsulates the database & the schema to be shared, the tables and secure views which will be shared, and the consumer account(s) to which the Share will be available. Sharing and consequently share objects are available to all Snowflake editions

Question 7

The expiry duration can be configured for Pre-signed or Scoped URL?

Answer 7

A file URL is a permanent Snowflake-hosted URL to a staged file. File URLs don’t expire.

A scoped URL is a temporary and encoded URL that allows temporary access to a staged file without requiring any privileges on the stage. A scoped URL expires after 24 hours.

A pre-signed URL is a simple HTTPS URL for accessing a file using a web browser. The expiry duration of a pre-signed URL is configurable and can be set to the required duration.

https://docs.snowflake.com/en/user-guide/unstructured-intro#types-of-urls-available-to-access-files

Question 8

True or False

Temporary and Transient tables allows Fail-safe

Answer 8

False

Transient and temporary tables don’t have fail-safe functionality; therefore, data in such tables goes through zero days of fail-safe storage. However, Transient and Temporary tables do have a maximum of 1 day of Time Travel.

Permanent tables also have time travel capability and can go up to 90 days of time travel depending on the configuration.

https://docs.snowflake.com/en/user-guide/tables-temp-transient

Question 9

True or False

External tables allows Time Travel

Answer 9

False

Transient and temporary tables don’t have fail-safe functionality; therefore, data in such tables goes through zero days of fail-safe storage. However, Transient and Temporary tables do have a maximum of 1 day of Time Travel.

Permanent tables also have time travel capability and can go up to 90 days of time travel depending on the configuration.

https://docs.snowflake.com/en/user-guide/tables-temp-transient

Question 10

Which view will give you the credit used by each virtual warehouse for the last 12 months?

METERING_HISTORY or WAREHOUSE_METERING_HISTORY ?

Answer 10

The WAREHOUSE_METERING_HISTORY view in the ACCOUNT_USAGE schema provides credit usage for each virtual warehouse in your system, broken down by hour. The view provides information from the last 365 days.

https://docs.snowflake.com/en/sql-reference/account-usage/warehouse_metering_history

Question 11

True or False

Multi-factor authentication, or MFA, is enabled by default for all Snowflake accounts.

Answer 11

True

MFA is enabled by default for all Snowflake accounts and is available in all Snowflake editions. https://docs.snowflake.com/en/user-guide/security-mfa

Question 12

True/False

As the size of the virtual warehouse increases, the amount of Snowflake credit consumed per second increases.

Answer 12

True

The number of Snowflake credits consumed depends on the size of the virtual warehouse, the duration while it is in a running state, and how many virtual warehouses you have created.

As the size of a virtual warehouse increases, the number of credits consumed per hour or second also increases.

https://docs.snowflake.com/en/user-guide/warehouses-considerations#how-are-credits-charged-for-warehouses

Question 13

What is the minimum Snowflake built-in role that can be used to enforce a network policy on a Snowflake account?

Answer 13

The SECURITYADMIN role is the minimum Snowflake built-in role allowed to enforce a network policy at an account level.

https://docs.snowflake.com/en/sql-reference/sql/desc-user#usage-notes

Question 14

What objects are created when a new trial account is created for a partner using Partner Connect?

Answer 14

While connecting to a Partner application, Snowflake automatically creates several objects, such as an empty database, virtual warehouse, default user, and custom role. When the partner app reads or writes to your account, it uses these objects.

https://docs.snowflake.com/en/user-guide/ecosystem-partner-connect#connecting-with-a-snowflake-partner

Question 15

True/False

Snowflake automatically clusters data as it is inserted into a table.

Answer 15

True

Snowflake automatically clusters the data as it is inserted into a table.

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions#what-is-data-clustering

Question 16

True or False

An administrator must grant explicit privileges on a cloned database as the cloning does not copy the privileges of the source database.

Answer 16

True

A cloned object does not inherit any privileges from its source object; for instance, a cloned table does not inherit any privileges from its source table.

However, if a database or schema is cloned, privileges are inherited by the child objects in the database. The database doesn’t inherit any privileges.

https://docs.snowflake.com/en/user-guide/object-clone#access-control-privileges-for-cloned-objects

Question 17

True or False

Multi-factor authentication (MFA) is enabled by default for all users; however, users must enroll themselves in MFA manually.

Answer 17

True

Multi-factor authentication (MFA) is enabled by default for all Snowflake accounts, and any Snowflake user can enroll themselves in MFA through the Snowflake web interface.

An administrator can disable a user’s MFA enrolment; in this case, the user must re-enroll to access the MFA features and functionality. An administrator with the SECURITYADMIN or above role can disable MFA for a user.

https://docs.snowflake.com/en/user-guide/security-mfa

Question 18

True or False

Only Snowflake’s Web Interface and SnowSQL allow multi-factor authentication.

Answer 18

False

All Snowflake client tools, including the web interface, SnowSQL, and the various connectors and drivers, support MFA.

https://docs.snowflake.com/en/user-guide/security-mfa

Question 19

True or False

A resource monitor can NOT control the cost of Serverless Compute

Answer 19

True

Resource monitors cannot control the credit usage of serverless features such as Snowpipe, Automatic Reclustering, and Materialized View maintenance. So, resource monitors can only manage virtual warehouses created by the customer, and their resource monitors can only suspend virtual warehouses operated by the user.

Any Snowflake-managed compute resource, such as Snowpipe, Serverless tasks, etc., can not be tracked or managed by resource monitors. In addition, a Resource Monitor can not control the costs of cloud services.

A warehouse-level resource monitor can monitor credit usage by Cloud Services, but the resource monitor can not suspend the cloud services. https://docs.snowflake.com/en/user-guide/resource-monitors#assignment-of-resource-monitors

Question 20

True or False

Multi-cluster virtual warehouses are serverless features provided by Snowflake

Answer 20

False

Snowpipe is a serverless service for continuous data loads. Automatic clustering is a serverless Snowflake-managed service that maintains micro-partitions for tables according to the defined clustering key.

Question 21

True/False

Snowflake credits are billed on a per-second basis.

Answer 21

True

Snowflake credits are billed on a per-second usage basis, which means if a virtual warehouse ran for 1 minute 45 seconds, you would be charged for 105 seconds (60 + 45). However, a minimum of 60 seconds of billing applies, so if a virtual warehouse were started and shut down within the first 1st minute, a minimum of 60-second credit usage would apply.

Question 22

True or False

The maximum number of days a query result cache can be retained is 31.

Answer 22

True

The query result cache is valid for 24 hours. If a new query matching a previous query is made within those 24 hours, the results are retrieved from the query result cache.

The query result cache is maintained in the cloud services layer and can be utilized by any user to return query results. The result cache of a query is initially valid for 24 hours, but it is extended for another 24 hours when a new query uses it. This extension can last up to 31 days before being removed. It is purged if the query result cache is not used for 24 hours.

https://docs.snowflake.com/en/user-guide/querying-persisted-results

Question 23

True or False.

You can use expressions in the clustering key definition to reduce a column’s cardinality.

Answer 23

True

If you need to use a column with high cardinality in a clustering key, you can define the key as an expression, which can help lower the cardinality by lowering the number of distinct values.

For example, if a table has a timestamp column you want to use in a clustering key, you can convert the timestamp to a date to reduce the cardinality. This approach will help improve partition pruning.

https://docs.snowflake.com/en/user-guide/tables-clustering-keys#strategies-for-selecting-clustering-keys

Question 24

True or False

Additional compute resources are added to a virtual warehouse when scaling up.

Answer 24

True

It is possible to resize a virtual warehouse to suit changing workloads. Assume a customer began with a small virtual warehouse which may no longer be sufficient to meet increased query complexity.

Scaling up the virtual warehouse can accommodate the increasing work complexity. When a virtual warehouse is scaled up, more nodes are added to the compute cluster.

https://docs.snowflake.com/en/user-guide/warehouses-tasks

Question 25

True or False

In a VARIANT column, the NULL values are stored as a literal string “null”

Answer 25

True

NULL values are stored as a literal string “null” in a VARIANT column.

https://docs.snowflake.com/en/user-guide/semistructured-considerations#null-values

Question 26

How does Snowflake enforce network policy when an IP address is included in both the block list and the authorized list of the policy?

Answer 26

Snowflake first applies the blocked list, guaranteeing that the IP address is denied access regardless of whether it is also defined in the allow list.

A network policy comprises of three components: a name, a list of approved IP addresses, and a list of blocked IP addresses. Snowflake applies the blocked list first if both the authorized and blocked lists are populated.

https://docs.snowflake.com/en/user-guide/network-policies

Question 27

What value does the CURRENT_CLIENT function return when called from an application using a JDBC driver to connect?

Answer 27

The version of the JDBC driver

The CURRENT_CLIENT function returns the client’s version from where the query was executed. When called from a query executed by an application using JDBC or ODBC driver, the version of the driver is returned.

For example, Calling CURRENT_CLIENT in Snowsight returns ‘Go 1.1.5’ since it uses the Go Driver. CURRENT_CLIENT in Classic Web UI returns ‘Snowflake UI 20230324175929’ since the Classic Web UI connects directly without a driver. Calling CURRENT C_CLIENT in SnowSQL returns ‘SnowSQL 1.2.24’.

https://docs.snowflake.com/en/sql-reference/functions/current_client

Question 28

Which ACCOUNT_USAGE view can be used to view roles granted to users?

Answer 28

The GRANTS_TO_USERS view can be used to view information about roles that have been granted to users. This view also contains historical information (up to 365 days), so roles that have been granted and revoked in the last 365 days will also be shown.

https://docs.snowflake.com/en/sql-reference/account-usage/grants_to_users

Question 29

PUBLIC role is available out of the box in Snowflake?

Answer 29

Yes

Built-in Snowflake roles include ORGADMIN, ACCOUNTADMIN, USERADMIN, SECURITYADMIN, SYSADMIN, and PUBLIC.

https://docs.snowflake.com/en/user-guide/security-access-control-overview#system-defined-roles.