Practice Tests COF-C02 - Mock Exam 4 Flashcards
True or False
External tables are read-only.
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
Views can be shared?
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
Is it possible to share data with a Snowflake customer whose Snowflake instance exists in a different region than the data provider?
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
True or False
The search optimization service requires an active virtual warehouse.
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
True or False
External Tables can be cloned
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
True or False
A share object has information about the consumer(s)
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
The expiry duration can be configured for Pre-signed or Scoped URL?
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
True or False
Temporary and Transient tables allows Fail-safe
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
True or False
External tables allows Time Travel
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
Which view will give you the credit used by each virtual warehouse for the last 12 months?
METERING_HISTORY or WAREHOUSE_METERING_HISTORY ?
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
True or False
Multi-factor authentication, or MFA, is enabled by default for all Snowflake accounts.
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
True/False
As the size of the virtual warehouse increases, the amount of Snowflake credit consumed per second increases.
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
What is the minimum Snowflake built-in role that can be used to enforce a network policy on a Snowflake account?
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
What objects are created when a new trial account is created for a partner using Partner Connect?
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
True/False
Snowflake automatically clusters data as it is inserted into a table.
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
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.
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
True or False
Multi-factor authentication (MFA) is enabled by default for all users; however, users must enroll themselves in MFA manually.
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
True or False
Only Snowflake’s Web Interface and SnowSQL allow multi-factor authentication.
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
True or False
A resource monitor can NOT control the cost of Serverless Compute
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
True or False
Multi-cluster virtual warehouses are serverless features provided by Snowflake
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.
True/False
Snowflake credits are billed on a per-second basis.
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.
True or False
The maximum number of days a query result cache can be retained is 31.
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
True or False.
You can use expressions in the clustering key definition to reduce a column’s cardinality.
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
True or False
Additional compute resources are added to a virtual warehouse when scaling up.
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
