Pass SnowPro Core Recertification Exam: Real COF-R02 Study Materials with Actual Questions and Answers

Eleanor2024-10-14T15:12:22+00:00

By Eleanor Snowflake, SnowPro Core Recertification

The SnowPro Core Recertification exam is available for candidates with an expiring SnowPro Core Certification. If you are looking to pass the COF-R02 SnowPro Core Recertification exam, then you are in the right place. We provide real COF-R02 study materials with actual questions and answers to help you master the study materials and pass the exam. Our study materials provide an in-depth look at the exam topics, and the questions are real to reflect the newest version of the exam. With the real COF-R02 study materials of ITPrepare, you can be confident that you have the tools and knowledge to pass the SnowPro Core Recertification exam and extend your certification status for 2 more years.

Come to check the free Snowflake COF-R02 exam demo questions first:

Page 1 of 10

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

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

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

Compute

Tri-Secret Secure

Storage

Cloud Services

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

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

True

False

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

True

False

6. How would you determine the size of the virtual warehouse used for a task?

Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

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

8. How a Snowpipe charges calculated?

Per-second/per Warehouse size

Per-second/per-core granularity

Number of Pipes in account

Total storage bucket size

9. When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A single join node uses more than 50% of the query time

Partitions scanned is equal to partitions total

An AggregateOperacor node is present

The query is spilling to remote storage

10. When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

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

Page 2 of 10

11. The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers

The complexity of each query

The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

The size of the data required for each query

The tool that s executing the query

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

13. Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

The validation_mode option is used when creating an Internal Stage

validation_mode=return_all_errors is a parameter of the copy command

The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

14. The PUT command: (Choose two.)

Automatically creates a File Format object

Automatically uses the last Stage created

Automatically compresses files using Gzip

Automatically encrypts files

15. When can a Virtual Warehouse start running queries?

12am-5am

Only during administrator defined time slots

When its provisioning is complete

After replication

16. What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Standard

Premier

Enterprise

Business Critical Edition

17. Which of the following are true of multi-cluster Warehouses? Select all that apply below.

A multi-cluster Warehouse can add clusters automatically based on query activity

A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

A multi-cluster Warehouse can scale down when query activity slows

A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

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

Named Stage

User Stage

Table Stage

Schema Stage

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

20. Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

SCIM

Federated authentication

TLS 1.2

Key-pair authentication

OAuth

OCSP authentication

Page 3 of 10

21. What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

On-premise availability

Simplicity

Open source based

Concurrency

Performance

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

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

Temporary

Translent

Provisional

Permanent

24. What feature can be used to reorganize a very large table on one or more columns?

Micro-partitions

Clustering keys

Key partitions

Clustered partitions

25. Which copy INTO command outputs the data into one file?

SINGLE=TRUE

MAX_FILE_NUMBER=1

FILE_NUMBER=1

MULTIPLE=FAISE

26. 1.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.

27. A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

The primary cluster in the virtual warehouse

The entire virtual warehouse

The database in which the virtual warehouse resides

The Queries currently being run on the virtual warehouse

28. A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

The tables are now orphaned

The user that deleted the role

SYSADMIN

The assumed role that dropped the role

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

Tables

Schemas

Databases

Stages

30. Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

JDBC

SnowSQL

Snowflake Web Interface (UI)

ODBC

Python

Page 4 of 10

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

True

False

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

True

False

33. What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Data is hashed by the cluster key to facilitate fast searches for common data values

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

Smaller micro-partitions are created for common data values to allow for more parallelism

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

34. True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

True

False

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

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

True

False

37. True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

True

False

38. In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

Bytes scanned

Bytes sent over the network

Number of partitions scanned

Percentage scanned from cache

External bytes scanned

39. What is the default File Format used in the COPY command if one is not specified?

CSV

JSON

Parquet

XML

40. True or False: It is possible to load data into Snowflake without creating a named File Format object.

True

False

Page 5 of 10

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

True

False

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

Custom

Economy

Optimized

Standard

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

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

True

False

45. Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Number of users

Warehouse size

Amount of data processed

# of clusters for the Warehouse

46. Which of the following objects can be cloned? (Choose four.)

Tables

Named File Formats

Schemas

Databases

Users

47. True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

True

False

48. Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

ROLES

POLICY_REFERENCES

QUERY_HISTORY

RESOURCE_MONIT ORS

ACCESS_HISTORY

49. If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

128

50. Which of the following terms best describes Snowflake’s database architecture?

Columnar shared nothing

Shared disk

Multi-cluster, shared data

Cloud-native shared memory

Page 6 of 10

51. Which interfaces can be used to create and/or manage Virtual Warehouses?

The Snowflake Web Interface (UI)

SQL commands

Data integration tools

All of the above

52. A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option

What does the STRIP_OUTER_ARRAY file format do?

It removes the last element of the outer array.

It removes the outer array structure and loads the records into separate table rows,

It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

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

OLAP (Analytics) workloads

OLTP (Transactional) workloads

Concurrent workloads

On-premise workloads

54. Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?

Select one.

More micro-partitions

Better query scheduling

Double the numbers of servers In the compute duster

Higher storage costs

55. A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data.

Will the developer be able to modify the table to read the masked data?

Yes, because a table owner has full control and can unset masking policies.

Yes, because masking policies only apply to cloned tables.

No, because masking policies must always reference specific access roles.

No, because ownership of a table does not include the ability to change masking policies

56. What happens when a cloned table is replicated to a secondary database? (Select TWO)

A read-only copy of the cloned tables is stored.

The replication will not be successful.

The physical data is replicated

Additional costs for storage are charged to a secondary account

Metadata pointers to cloned tables are replicated

57. Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)

Growth of storage and compute are tightly coupled together

Storage expands without the requirement to add more compute

Compute can be scaled up or down without the requirement to add more storage

Multiple compute clusters can access stored data without contention

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

True

False

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

Auto-suspend

Auto-resume

Local SSD size

User count

60. Which command can be used to load data into an internal stage?

LOAD

copy

GET

PUT

Page 7 of 10

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

62. Which feature is only available in the Enterprise or higher editions of Snowflake?

Column-level security

SOC 2 type II certification

Multi-factor Authentication (MFA)

Object-level access control

63. What can be used to view warehouse usage over time? (Select Two).

The load HISTORY view

The Query history view

The show warehouses command

The WAREHOUSE_METERING__HISTORY View

The billing and usage tab in the Snowflake web Ul

64. A user has an application that writes a new Tile to a cloud storage location every 5 minutes.

What would be the MOST efficient way to get the files into Snowflake?

Create a task that runs a copy into operation from an external stage every 5 minutes

Create a task that puts the files in an internal stage and automate the data loading wizard

Create a task that runs a GET operation to intermittently check for new files

Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

65. Which Snowflake technique can be used to improve the performance of a query?

Clustering

Indexing

Fragmenting

Using INDEX__HINTS

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

True

False

67. True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

True

False

68. A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days.

Which of the following statements will return the required information?

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAG

USERS;

SELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user())

SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAG

ACCESS_HISTORY;

SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAG

LOGIN_HISTORY;

69. Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Load files that are approximately 25 MB or smaller.

Remove all dates and timestamps.

Load files that are approximately 100-250 MB (or larger)

Avoid using embedded characters such as commas for numeric data types

Remove semi-structured data types

70. What features does Snowflake Time Travel enable?

Querying data-related objects that were created within the past 365 days

Restoring data-related objects that have been deleted within the past 90 days

Conducting point-in-time analysis for Bl reporting

Analyzing data usage/manipulation over all periods of time

Page 8 of 10

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

72. What happens when a virtual warehouse is resized?

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

Users who are trying to use the warehouse will receive an error message until the resizing is complete

73. True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

True

False

74. Which of the following DML commands isn’t supported by Snowflake?

UPSERT

MERGE

UPDATE

TRUNCATE TABLE

75. True or False: An active warehouse is required to run a COPY INTO statement.

True

False

76. What are the default Time Travel and Fail-safe retention periods for transient tables?

Time Travel - 1 day. Fail-safe - 1 day

Time Travel - 0 days. Fail-safe - 1 day

Time Travel - 1 day. Fail-safe - 0 days

Transient tables are retained in neither Fail-safe nor Time Travel

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

78. True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

True

False

79. Which of the following statements would be used to export/unload data from Snowflake?

COPY INTO @stage

EXPORT TO @stage

INSERT INTO @stage

EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

80. True or False: A Virtual Warehouse can be resized while suspended.

True

False

Page 9 of 10

81. Will data cached in a warehouse be lost when the warehouse is resized?

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

Yes. because the compute resource is replaced in its entirety with a new compute resource.

No. because the size of the cache is independent from the warehouse size

Yes. became the new compute resource will no longer have access to the cache encryption key

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

True

False

83. True or False: Snowflake supports federated authentication in all editions.

True

False

84. What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Informatica

Power Bl

Adobe

Data Robot

85. In which use cases does Snowflake apply egress charges?

Data sharing within a specific region

Query result retrieval

Database replication

Loading data into Snowflake

86. A user has unloaded data from Snowflake to a stage

Which SQL command should be used to validate which data was loaded into the stage?

list @file__stage

show @file__stage

view @file__stage

verify @file__stage

87. Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

The user has the appropriate privileges on the objects associated with the query

Micro-partitions have been reclustered since the query was last run

The new query is run using the same virtual warehouse as the previous query

The query includes a User Defined Function (UDF)

The query has been run within 24 hours of the previously-run query

88. When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse

According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Use multi-clustered warehousing to scale out warehouse capacity.

Scale up the warehouse size to allow Queries to execute faster.

Stop and start the warehouse to clear the queued queries

Migrate some queries to a new warehouse to reduce load

Limit user access to the warehouse so fewer queries are run against it.

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

True

False

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

True

False

Page 10 of 10

91. True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

True

False

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

True

False

93. When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

Concurrency

Performance

94. Which of the following are benefits of micro-partitioning? (Select TWO)

Micro-partitions cannot overlap in their range of values

Micro-partitions are immutable objects that support the use of Time Travel.

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

Rows are automatically stored in sorted order within micro-partitions

Micro-partitions can be defined on a schema-by-schema basis

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

True

False

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

97. Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

An FTP server with TLS encryption

An HTTPS server with WebDAV

A Google Cloud storage bucket

A Windows server file share on Azure

98. Which statement about billing applies to Snowflake credits?

Credits are billed per-minute with a 60-minute minimum

Credits are used to pay for cloud data storage usage

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

Credits are consumed based on the warehouse size and the time the warehouse is running

99. The Query History in the Snowflake Web Interface (UI) is kept for approximately:

60 minutes

24 hours

14 days

30 days

1 year

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

True

False

Pass SnowPro Core Recertification Exam: Real COF-R02 Study Materials with Actual Questions and Answers

Pass SnowPro Core Recertification Exam: Real COF-R02 Study Materials with Actual Questions and Answers

Come to check the free Snowflake COF-R02 exam demo questions first:

Share this post

Author

Related Posts