Download SnowPro Core Certification COF-C01 Real Questions

test2022-07-14T05:50:39+00:00

By test COF-C01 free dumps, COF-C01 practice exam, COF-C01 Real Questions, SnowPro Core Certification 0 Comments

You must pass the COF-C01 test if you want to obtain SnowPro Core Certification. FreeTestShare is the place to go if you want to acquire all of the COF-C01 Real Questions. The COF-C01 practice exam contain actual exam questions and answers, ensuring that you pass the exam on your first attempt. If you want to pass the SnowPro Core Certification exam fast and efficiently, contact FreeTestShare for the complete COF-C01 Real Questions! 100% pass guaranteed.Take the entire COF-C01 Real Questions for a single success to evaluate your preparation.

To discover how prepared you are, take this sample exam first!

Page 1 of 5

1. Account-level storage usage can be monitored via:

The snowflake wet Interface (UI) in the Databases section.

The Snowflake web interface (UI) in the Account -> Billing a usage section

The Information Schema -> ACCOUNT_USAGE_HISTORY View

The Account usage Schema - > ACCOUNT_USAGE_METRICS View

2. What are the three layers that make up Snowflake’s architecture? Choose 3 answer

Compute

Tri-Secret Secure

Storage

Cloud Services

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

Joins

Fitters

Data type conversions

Column reordering

Aggregates

4. Which of the following statement is true of Snowflake?

It was built specifically for the cloud

it was built as an on-premises solution and then potted to the cloud

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

It was built for Hadoop architecture

It's based on an Oracle Architecture

5. Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

To accommodate more queries

To accommodate more users

To accommodate fluctuations in workload

To accommodate a more complex workload

6. True or False: Data Providers can share data with only the Data Consumer.

True

False

7. Which of the following are options when creating a Virtual Warehouse?

Auto-suspend

Auto-resume

Local SSD size

User count

8. Which item in the Data Warehouse migration process does not apply in Snowflake>

Migrate Users

Migrate Schemas

Migrate Indexes

Build the Data pipeline

9. True or False: Pipes can be suspended and resumed.

True

False

10. Which object allows you to limit the number of credits consumed within a Snowflake account?

Account usage Tracking

Resource Monitor

Warehouse Limit Parameter

Credit Consumption Tracker

Page 2 of 5

11. Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

Scaling rhythmically

Scaling max

Scaling out

Scaling Up

12. Which of the following roles is recommended to be used to create and manage users and roles?

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

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

Delimited (CSV, TSV, etc.)

Avro

JSON

ORC

14. What privileges are required to create a task?

The global privilege create task is required to create a new task.

Tasks are created at the Application level and can only be created by the Account Admin role.

Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.

The role must have access to the target schema and the create task privilege on the schema itself.

15. Snowflake provides a mechanism for its customers to override its clustering algorithms.

This method is:

Micro-partitions

Clustering keys

Key partitions

Clustered partitions

16. Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Customers can change the size of the Warehouse after creation

A Warehouse can be resized while running

A Warehouse can be configured to suspend after a period of inactivity

A Warehouse can be configured to auto-resume when new queries are submitted

17. True or False: A single database can exist in more than one Snowflake account.

True

False

18. Which type of table corresponds to a single Snowflake session?

Temporary

Translent

Provisional

Permanent

19. True or False: You can query the files in an External Stage directly without having to load the data into a table.

True

False

20. Which of the following commands sets the Virtual Warehouse for a session?

COPT WAREHOUSE FROM <<Config file> ;

SET warehouse = <<warehouse name>>;

USE WAREHOUSE <<warehouse name>>;

USE VIRTUAL_WAREHOUSE <<warehouse name>>;

Page 3 of 5

21. How many shares can be consumed by single Data Consumer?

100, but can be increased by contacting support

Unlimited

22. Which of the following statements is true of Snowflake?

It was built specifically for the cloud

It was built as an on-premises solution and then ported to the cloud

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

It was built for Hadoop architecture

It's based on an Oracle Architecture

23. True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

True

False

24. A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

The primary duster in the virtual warehouse

The entire Virtual Warehouse

The database the Virtual Warehouse resides in

The queries currently being run by the Virtual Warehouse

25. What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.

Installing and configuring hardware

Patching software

Physical security

Maintaining metadata and statists

26. True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.

True

false:

27. The fail-safe retention period is how many days?

1 day

7 days

45 days

90 days

28. Which of the following statements is true of zero-copy cloning?

Zero-copy clones objects inherit

All zero-copy clone objects inherit the privileges of their original objects

Zero-copy coning is licensed as an additional Snowflake feature

At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.

29. True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

True

False

30. True or False: Snowflake charges a premium for storing semi-structured data.

True

False

Page 4 of 5

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

32. When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:

Concurrency

Performance

33. What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

Standard

Premier

Enterprise

Business Critical Edition

34. Which of the following objects is not covered by Time Travel?

Tables

Schemas

Databases

Stages

35. True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

True

False

36. True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

True

False

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

38. True or False: You can resize a Virtual Warehouse while queries are running.

True

False

39. True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

True

False

40. Which statement best describes Snowflake tables?

Snowflake tables are logical representations of underlying physical data

Snowflake tables ate the physical instantiation of data loaded Into Snowflake

Snowflake tables require that clustering keys be defined to perform optimally

Snowflake tables are owned by a user

Page 5 of 5

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

Storage Layer

Compute Layer

Database Layer

Cloud Service Layer