Latest Practice Tests

HOME
ALL EXAMS
SAP
Oracle
Microsoft
Cisco
Huawei
Amazon
CompTIA
Contact

Latest Practice Tests

HOME
ALL EXAMS
SAP
Oracle
Microsoft
Cisco
Huawei
Amazon
CompTIA
Contact

Updated Nov-2022 Exam Engine for COF-C01 Exam Free Demo & 365 Day Updates [Q46-Q66]

COF-C01 Snowflake

admin -

November 6, 2022

5/5 - (3 votes)

Updated Nov-2022 Exam Engine for COF-C01 Exam Free Demo & 365 Day Updates

Exam Passing Guarantee COF-C01 Exam with Accurate Quastions!

Q46. True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

True

False

Q47. True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

True

False

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

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

Q50. True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

True

False

Q51. What is the maximum compressed row size in Snowflake?

8KB

16MB

50MB

4000GB

Q52. As a best practice, clustering keys should only be defined on tables of which minimum size?

Multi-Kilobyte (KB) Range

Multi-Megabyte (MB) Range

Multi-Gigabyte (GB) Range

Multi-Terabyte (TB) Range

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

True

False

Q54. Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

Database

Tables

Warehouses

Worksheets

Q55. Which of the following statements is true of Snowflake micro-partitioning?

Micro-partitioning has been known to introduce data skew

Micro-partitioning: requires a partitioning schema to be defined up front

Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded

Micro-partitioning can be disabled within a Snowflake account

Q56. In which layer of its architecture does Snowflake store its metadata statistics?

Storage Layer

Compute Layer

Database Layer

Cloud Service Layer

Q57. True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

True

False

Q58. Which of the following items does the Cloud services Layer manage? Choose 4 answers

user authentication

Metadata

Query compilation and optimization

external blob storage

Data security

Q59. Which statement best describes ” clustering”?

Clustering represents the way data is grouped together and stored within snowflake’s micro-partitions

The database administrator must define the clustering methodology for each Snowflake table.

The clustering key must be included on the COPV command when loading data into Snowflake.

Clustering can be disabled within a Snowflake account.

Q60. Which are true of Snowflake roles?

All grants to objects are given to roles, and never to users

In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation

The public role controls at other roles

Roles are a subset of users and users own objects In Snowflake

Q61. True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

True

False

Q62. True or False: During data unloading, only JSON and CSV files can be compressed.

True

False

Q63. True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

True

False

Q64. True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

True

False

Q65. The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

Users

Tables

Databases

Internal Stages

Q66. Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? Choose 2 answers

Java

JavaScript

SQL

Python