COF-C01 Dumps COF-C01 Braindumps
COF-C01 Real Questions COF-C01 Practice Test COF-C01 dumps free
SnowPro Core Certification
https://killexams.com/pass4sure/exam-detail/COF-C01
Question: 48
True or False: A single database can exist in more than one Snowflake account.
True
False
Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html
Question: 49
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
True
False
Question: 50
For a multi-cluster Warehouse, the number of credits billed is calculated on: Select one.
The number of queries that ran using the Warehouse.
The size of the Warehouse and the number of clusters that ran within a given time period.
The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.
The number of users who accessed the Warehouse.
Question: 51
True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.
True
False
Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html
Question: 52
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
Users
Tables
Databases
Internal Stages
Question: 53
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
True
False
Question: 54
When loading data into Snowflake, the COPY command supports: Choose 2 answers
Joins
Fitters
Data type conversions
Column reordering
Aggregates
Question: 55
Which formats are supported for unloading data from Snowflake? Choose 2 answers
Delimited (CSV, TSV, etc.)
Avro
JSON
ORC
Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html
Question: 56
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
Configure the Maximum Clusters setting to “Auto-Scale”
Set the Warehouse type to “Auto”
Set the Minimum Clusters and Maximum Clusters settings to the same value
Set the Minimum Clusters and Maximum Clusters settings to the different values
Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse
Question: 57
How a Snowpipe charges calculated?
Per-second/per Warehouse size
Per-second/per-core granularity
Number of Pipes in account
Total storage bucket size
Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html
Question: 58
Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
SECURITYADMIN ACCOUNTADMIN, SYSADMIN
SECURITYADMIN, ACCOUNTADMIN
ACCOUNTADMIN
Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html
Question: 59
True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.
True
False
Reference: https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/
Question: 60
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
Custom
Economy
Optimized
Standard
Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance