Helpful COF-C01 Exam Dumps To Prepare SnowPro Core Certification Exam Well

Eleanor2022-05-13T08:26:29+00:00

By Eleanor Snowflake COF-C01, COF-C01 exam dumps 0 Comments

Since Snowflake added the services on Pearson VUE, candidates need to register COF-C01 exam to complete SnowPro Core Certification exam. And finishing SnowPro Core Certification COF-C01 exam using online study materials is highly recommend. ITPrepare has well-prepared the most helpful COF-C01 exam dumps with actual COF-C01 exam questions and answers. These most up-to-date Snowflake COF-C01 exam dumps are associated to the SnowPro Core Certification exam so you’ll be able to effectively accomplish the task of preparation.

Test COF-C01 Free Exam Dumps Below To Check How Helpful COF-C01 Exam Dumps Is

Page 1 of 6

1. What is the lowest Snowflake edition that offers Time Travel up to 90 days.

standard Edition

Premier Edition

Enterprise Edition

Business Critical Edition

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

3. Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy?

Account -> Schema -> Database -> Table

Account -> Database -> Schema -> Table

Database -> Schema -> Table -> Account

Database -> Table -> Schema -> Account

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

Delimited (CSV, TSV, etc.)

Avro

JSON

ORC

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

True

False

6. What is the most granular object that the Time Travel retention period can be defined on?

Account

Database

Schema

Table

7. Which of the following commands are not blocking operations?

Choose 2 answers

UPDATE

INSERT

MERGE

COPY

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

9. Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?

1 Hour

3 Hours

12 hours

24 hours

10. Snowflake is designed for which type of workloads? (Choose two.)

OLAP (Analytics) workloads

OLTP (Transactional) workloads

Concurrent workloads

On-premise workloads

Page 2 of 6

11. True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

True

False

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

True

False

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

True

False

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

True

False

15. Which of the following statements are true of Snowflake releases: (Choose two.)

They happen approximately weekly

They roll up and release approximately monthly, but customers can request early release application

During a release, new customer requests/queries/connections transparently move over to the newer version

A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

16. Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers

MIN(< < column value>>)

COPY

SUM(<< column value >>)

UPDATE

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

True

False

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

1 day

7 days

45 days

90 days

19. Select the different types of Internal Stages: (Choose three.)

Named Stage

User Stage

Table Stage

Schema Stage

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 6

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

True

False

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

100, but can be increased by contacting support

Unlimited

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

24. True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

True

False

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

26. True or False: Snowpipe via RFST API can only reference External Stages as source.

True

False

27. What happens when a Data Provider revokes privileges to a Share on an object in their source database?

The object immediately becomes unavailable for all Data Consumers

Any additional data arriving after this point in time will not be visible to Data Consumers

The Data Consumers stop seeing data updates and become responsible for storage charges for the object

A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts

28. Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

Is available to all Snowflake Editions

Is only available to customers with Business Critical Edition

Restricts or enables access to specific IP addresses

Is activated using an “ALTER DATABASE” command

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

Users

Tables

Databases

Internal Stages

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

Page 4 of 6

31. How a Snowpipe charges calculated?

Per-second/per Warehouse size

Per-second/per-core granularity

Number of Pipes in account

Total storage bucket size

32. Select the three types of tables that exist within Snowflake.

Choose 3 answers

Temporary

Transient

Provisioned

Permanent

33. What is the minimum duration charged when starting a virtual warehouse?

1 second

1 minute

1 hour

1 day

34. True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

True

False

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

Temporary

Translent

Provisional

Permanent

36. True or False: The COPY command must specify a File Format in order to execute.

True

False

37. Which of the following statements are true about Schemas in Snowflake? (Choose two.)

A Schema may contain one or more Databases

A Database may contain one or more Schemas

A Schema is a logical grouping of Database Objects

Each Schema is contained within a Warehouse

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

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

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

True

False

Page 5 of 6

41. Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers

SHOW TABLES;

SHOW STORAGE BY TABLE;

Information Schema -> TABLE_STORAGE_METRICS

Information Schema -> TASLE_HISTORY

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

8KB

16MB

50MB

4000GB

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

44. Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

Custom

Economy

Optimized

Standard

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

46. If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

All Snowflake sessions using the warehouse are terminated.

The last query using the warehouse completes.

There are no users loaned into Snowflake.

The Warehouse is inactive for a specified period of time.

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

True

False

48. True or False: Users are able to see the result sets of queries executed by other users that share their same role.

True

False

49. What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?

INITTIALLY_SUSPENDED = TRUE/FALSE

START_AFTCR_CREATE = TRUE/FALSE

START_TTIME = 60 // (seconds from now)

STAR

TIME = CURREN

DATE()

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

True

False

Page 6 of 6

51. Which of the following are options when creating a virtual Warehouse? Choose 2 answers

Auto-drop

Auto resize

Auto-resume

Auto-suspend

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

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

54. Which of the following statements is true of data loading?

Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast

The "deal file size for loading is 16MB to match micro-partition size

Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file

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

Joins

Fitters

Data type conversions

Column reordering

Aggregates

56. Which of the following statements about data sharing are true? choose 2 answers

New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts

All database objects can be included In a shared database

Reader Accounts are created and funded by Data Prowlers

Shared databases are read-only

57. What is the recommended method for loading data into Snowflake?

Load row by row

Load data in batch

Load data by writing it In the Snowflake Web Interface (UI)

Load data via frequent, angle row DML's

58. True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

True

False

59. 1.When a pipe is recreated using the CREATE on REPLAC PIPE command: Select one.

The Pipe load history is reset to empty

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

All of the above

60. When can a Virtual Warehouse start running queries?

12am-5am

Only during administrator defined time slots

When its provisioning is complete

After replication

Helpful COF-C01 Exam Dumps To Prepare SnowPro Core Certification Exam Well