COF-C01 Dumps COF-C01 Braindumps

COF-C01 Real Questions COF-C01 Practice Test COF-C01 dumps free


SnowFlake


COF-C01


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.

  1. True

  2. False


Answer: B Explanation:

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.

  1. True

  2. False


Answer: B


Question: 50


For a multi-cluster Warehouse, the number of credits billed is calculated on: Select one.

  1. The number of queries that ran using the Warehouse.

  2. The size of the Warehouse and the number of clusters that ran within a given time period.

  3. The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.

  4. The number of users who accessed the Warehouse.


Answer: B


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.

  1. True

  2. False


Answer: A Explanation:

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.)

  1. Users

  2. Tables

  3. Databases

  4. Internal Stages


Answer: B,C,D


Question: 53


True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

  1. True

  2. False


Answer: B


Question: 54


When loading data into Snowflake, the COPY command supports: Choose 2 answers

  1. Joins

  2. Fitters

  3. Data type conversions

  4. Column reordering

  5. Aggregates


Answer: C,D


Question: 55


Which formats are supported for unloading data from Snowflake? Choose 2 answers

  1. Delimited (CSV, TSV, etc.)

  2. Avro

  3. JSON

  4. ORC


Answer: A,C Explanation:

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:

  1. Configure the Maximum Clusters setting to “Auto-Scale”

  2. Set the Warehouse type to “Auto”

  3. Set the Minimum Clusters and Maximum Clusters settings to the same value

  4. Set the Minimum Clusters and Maximum Clusters settings to the different values


Answer: D Explanation:

Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse


Question: 57


How a Snowpipe charges calculated?

  1. Per-second/per Warehouse size

  2. Per-second/per-core granularity

  3. Number of Pipes in account

  4. Total storage bucket size


Answer: B Explanation:

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):

  1. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN

  2. SECURITYADMIN ACCOUNTADMIN, SYSADMIN

  3. SECURITYADMIN, ACCOUNTADMIN

  4. ACCOUNTADMIN


Answer: D Explanation:

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.

  1. True

  2. False

Answer: B Explanation:

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.)

  1. Custom

  2. Economy

  3. Optimized

  4. Standard


Answer: B,D Explanation:

Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance