Snowflake Test-7

The Snowflake SnowPro Core COF-C02 mock test is an excellent way to validate your knowledge of Snowflake’s cloud data platform. It demonstrates your ability to manage data storage, security, and performance optimization. Employers respect certifications, but they expect more than exam readiness. To get hired, you need proficiency in visualization tools like Power BI and Tableau, querying languages like SQL, and statistical platforms such as SAS. Data engineering skills in Snowflake, Databricks, and PySpark are critical for managing pipelines. On top of that, data science and AI expertise in TensorFlow, PyTorch, LLMs, and Generative AI are increasingly required. Modern roles blend data analysis, engineering, and AI, demanding versatility.

The SynergisticIT Data Science Job Placement Program ensures you go beyond certification, equipping you with advanced skills, project work, and interview preparation. Explore more opportunities through the SynergisticIT Job Placement Program.

Welcome to your Snowflake Test-7

Name

Phone

Q1. Multiple streams can be created on a single table

Select 1 option(s):

TRUE

FALSE

Q2. In Snowflake Enterprise edition, the maximum retention period for a permanent table is?

Select 1 option(s):

7 days

90 days

365 days

1 day

Q3. What is the default time limit on a single run of a task

Select 1 option(s):

30 min

60 min

10 min

There is no limit as such

Q4. Data retention period of database is set to 2 days. Data retention period of schema inside that database is set to 4 days. Data retention of a table inside the schema is set to 7 days. Now if the database is dropped, the table that was present in that database can be restored back within how many days?

Select 1 option(s):

7 days

2 days

4 days

Since the Database itself is dropped, the underlying objects cannot be restored

Q5. After dropping an object, creating an object with the same name does not restore the object. Instead, it creates a new version of the object. The original, dropped version is still available and can be restored.

Select 1 option(s):

TRUE

FALSE

Q6. Which of the following currently uses user - specified warehouse, but eventually run in a serverless environment using Snowflake-supplied compute resources

Select 1 option(s):

Tasks

Snowpipe

Streams

Stored Procedure

Q7. Which command can be executed to get the version history of table “Test1“ in schema “mytestdb.myschema“ within the time travel period in snowflake?

Select 1 option(s):

show history of table like ‘Test1‘ in mytestdb.myschema;

show version of table like ‘Test1‘ in mytestdb.myschema;

show tables version like ‘Test1‘ in mytestdb.myschema;

show tables history like ‘Test1‘ in mytestdb.myschema;

Q8. Which of the following parameters are provided by Snowflake to be used with AT & BEFORE clause to pinpoint the exact historical data you wish to access

Select 1 option(s):

All options are correct

STATEMENT (identifier for statement, e.g. query ID)

OFFSET (time difference in seconds from the present time)

TIMESTAMP

Q9. If you have a table with a 10-day retention period and increase the period to 20 days, then what happens to the data that is currently in time travel for past 2 days.

Select 1 option(s):

The data will moved to fail safe immediately

The table will lose all time travel data, and the new time travel retention period will be applied going forward

The data would moved to fail safe as per previous retention period only i.e. will move to fail safe after 10 days of time travel

The data would moved to fail safe as per new retention period i.e. will move to fail safe after 20 days of time travel

Q10. select * from my_table before(statement => ‘8e5d0ca9-005e-44e6-b858-a8f5b37c5726‘); This query will select historical data from “my_table“ up to, but not including any changes made by the specified statement

Select 1 option(s):

FALSE

TRUE

Q11. Currently, streams cannot track changes in materialized views.

Select 1 option(s):

TRUE

FALSE

Q12. Snowflake supports which of the following file formats for data loading? Select all that apply.

Select 3 option(s):

Parquet

CSV

PDF

ORC

Q13. When a table data changes (for e.g. few records are updated and few are deleted) and the table is within the time travel retention period, which of the following statement is true?

Select 1 option(s):

Snowflake maintains only the information pertaining to these changed records (i.e. updated & deleted ones)

Snowflake takes a full copy of the table every time any change is made to the table

Q14. Which two table types can have a maximum retention period of 1 day?

Select 2 option(s):

MATERIALIZED

PERMANENT

TEMPORARY

TRANSIENT

Q15. Storage fees are incurred for maintaining historical data during both the Time Travel and Fail-safe periods

Select 1 option(s):

FALSE

TRUE

Q16. Snowflake Tasks can be event based as well along with time based?

Select 1 option(s):

FALSE

TRUE

Q17. A table named “MY_TABLE“ has a retention period of 7 days. The table is dropped, and a new table with the same name “MY_TABLE“ has been created. The new table that is created is also dropped. Now retrieving the original version (i.e. the 1st version) of the table is not possible. This is True or False?

Select 1 option(s):

FALSE

TRUE

Q18. Which file format is an open-source data serialization and RPC framework originally developed for use with Apache Hadoop

Select 1 option(s):

XML

ORC

JSON

PARQUET

AVRO

Q19. You can view the amount of storage used by failsafe under the Account->Billing & Usage section

Select 1 option(s):

TRUE

FALSE

Q20. After the retention period for an object has passed and the object has been purged, it is no longer displayed in the SHOW HISTORY output.

Select 1 option(s):

TRUE

FALSE

Q21. Changing the time travel retention period for your account or individual objects changes the value for all lower-level objects that do not have a retention period explicitly set

Select 1 option(s):

FALSE

TRUE

Q22. Which two SQL Extension clause are provided by Snowflake to support time travel?

Select 2 option(s):

PRIOR

BEFORE

DURING

Q23. Within a transaction multiple SQL statements will see the same set of records in a stream

Select 1 option(s):

TRUE

FALSE

Q25. The data retention period for a database, schema, or table cannot be changed after they are created.

Select 1 option(s):

FALSE

TRUE

Q25. The cron expression in a task definition supports specifying a time zone

Select 1 option(s):

FALSE

TRUE

Q26. Which parameter is used to set the time travel retention period?

Select 1 option(s):

DATA_RETENTION_TIME

DATA_RETENTION_TIME_IN_HOURS

DATA_RETENTION_TIME_IN_WEEKS

DATA_RETENTION_TIME_IN_DAYS

Q27. When the owner role of a given task (i.e. the role with the OWNERSHIP privilege on the task) is deleted, what happens?

Select 1 option(s):

The tasks is suspended immediately, and the task will not have any owner till explicitly assigned

The tasks is also dropped

The task is re-possessed by the role that dropped the owner role

The roles granted to any task cannot be dropped unless all associated tasks are dropped

Q28. In Snowflake Enterprise edition, the maximum retention period for a transient or temporary table is?

Select 1 option(s):

7 days

1 day

90 days

Transient & Temporary table cannot be configured for time travel

Q29. What are the different types of streams available?

Select 3 option(s):

Append-Only

Insert-Only

Standard

Update-Only

Native

Q30. What is the default table type when a CREATE TABLE is executed?

Select 1 option(s):

PERMANENT

TRANSIENT

MATERIALIZED

TEMPORARY

Q31. A stream object records data manipulation language (DML) changes made to tables, including inserts and updates but cannot record deletes made to tables

Select 1 option(s):

TRUE

FALSE

Q32. If multiple DML statements change a row, the stream records all the action taken on that row.

Select 1 option(s):

TRUE

FALSE

Q33. The CDC records returned when querying a stream rely on a combination of –

Select 2 option(s):

Offset stored in Table

Offset Stored in Stream

Change Tracking Metadata Stored in Stream

The change tracking metadata stored in the table

Q34. Snowflake minimizes the amount of storage required for historical data by maintaining only the information required to restore the individual table rows that were updated or deleted

Select 1 option(s):

FALSE

TRUE

Q35. Which is the default encoding considered in COPY command while loading delimited files like CSV, TSV?

Select 1 option(s):

UCS-2

ANSI

UTF-16

UTF-8

Q36. Snowflake maintains detailed metadata for each table into which data is loaded, including:

Select 4 option(s):

Etag for the file

Name of each file from which data was loaded

Number of Columns

Column Names

Number of rows parsed in the file

File Size

Q37. We have few clone tables in a database. Now for the database, replication is setup. In the secondary (target) database, the clone object will not be physically copied, and hence no storage cost will be incurred for them. True or False?

Select 1 option(s):

FALSE

TRUE

Q38. When a copy command cannot definitively determine whether a file has been loaded already, then what is the default behaviour?

Select 1 option(s):

The file load is skipped

Error message is generated, that load metadata for the file for given table doesnât exists

The file is loaded

Q39. Which of the following tables cannot be cloned as permanent table?

Select 2 option(s):

Temporary Tables

Transient Tables

Permanent Tables

Q40. A stream allows querying and consuming a set of changes to a table, at the row level, between two transactional points of time

Select 1 option(s):

TRUE

FALSE

Q41. If the TIMESTAMP, OFFSET, or STATEMENT specified in the AT | BEFORE clause falls outside the data retention period for the table, the query fails and returns an error.

Select 1 option(s):

TRUE

FALSE

Q42. If the role that a running task is executing under is dropped while the task is running, the task completes processing under the dropped role.

Select 1 option(s):

TRUE

FALSE

Q43. Which type of table stream tracks all DML changes to the source table including inserts, updates, deletes and also truncate?

Select 1 option(s):

Insert-Only

Multifunction

Standard

Native

Append-Only

Q44. Which of the following roles can use SQL to view the task history within a specified date range

Select 3 option(s):

Accountadmin

Task owner (i.e. role that has the OWNERSHIP privilege on a task)

Public

Any role that has the global MONITOR EXECUTION privilege

Any role can view

Q44. You are a developer with in one company running a Snowflake data warehouse. You required to load JSON based data into a table. What is the best way to do it in snowflake?

Select 1 option(s):

Ask the source team to send data into CSV instead of JSON

Write a program in Java or Python to convert the JSON into tabular format and then load in Snowflake table

Create a table with variant column and load the json data into that table

Q46. Tasks cannot be chained together for successive execution to support more complex periodic processing

Select 1 option(s):

TRUE

FALSE

Q47. Table stream also contains actual table data

Select 1 option(s):

TRUE

FALSE

Q48. If you change the data retention period for a table, the new retention period impacts all data that is active, as well as any data currently in Time Travel

Select 1 option(s):

TRUE

FALSE

Q49. Under what circumstances would Fail-Safe NOT be an effective method for data recovery?

Select 1 option(s):

As a means for accessing historical data after the Time Travel retention period has ended

To recover data that may have been lost or damaged due to extreme operational failures

To protect data in the event of a system failure or other catastrophic event e.g. a hardware failure or security breach

Q50. Account parameters are also replicated, when a databse replication is setup

Select 1 option(s):

TRUE

FALSE

Q51. A single tasks in snowflake can execute multiple SQL Statements

Select 1 option(s):

TRUE

FALSE

Q52. select * from my_table at(offset => -60*5); This query will select historical data from “my_table“ as of –

Select 1 option(s):

5 days ago

5 seconds ago

5 minutes ago

5 hours ago

Q53. What is the maximum number of child tasks, a given task can have?

Select 1 option(s):

100

10000

1000

Unlimited

Q54. Restoring tables and schemas is only supported in the current schema or current database, even if a fully-qualified object name is specified.

Select 1 option(s):

FALSE

TRUE

Q55. Storage fees are incurred for maintaining historical data during the Time Travel but not during Fail-safe periods as Fail safe is managed by Snowflake

Select 1 option(s):

TRUE

FALSE

Q56. When a task is created, it is in resumed state by default?

Select 1 option(s):

TRUE

FALSE

Q57. What is the full form of ORC?

Select 1 option(s):

Optimized Read Columnar

Optimized Row Columnar

Object Row Columnar

Object Read Class

Q58. Using Time Travel, you can perform which of the following actions within a defined period of time (i.e. within the time travel period of the object)

Select 1 option(s):

Restore tables, schemas, and databases that have been dropped

Create clones of entire tables, schemas, and databases at or before specific points in the past

Query data in the past that has since been updated or deleted

All options are correct

Q59. Which semi structure data types are available in Snowflake

Select 3 option(s):

ARRAY

OBJECT

SEMI STRUCTURE

STRING

VARIANT

Q60. Which of the following Snowflake Object is used for a schedule execution of SQL statement?

Select 1 option(s):

Stored Procedure

Streams

Snowpipe

Tasks

Q61. For which table type the retention period ends as soon as the the table is dropped or the session in which the table was created ends.

Select 1 option(s):

TEMPORARY

MATERIALIZED

PERMANENT

TRANSIENT

Q62. Fail Safe is not supported in Standard Snowflake edition

Select 1 option(s):

TRUE

FALSE

Q63. What is the column datatype used for ingesting semi-structured data?

Select 1 option(s):

VARCHAR

DATETIME

BINARY

STRING

VARIANT

Q64. DATA_RETENTION_TIME_IN_DAYS paramete is defined as 1 day at account level, and the same parameter is set as 7 days at Database level. Now a table is created inside the given database without specifying any explicit DATA_RETENTION_TIME_IN_DAYS parameter. What would be the data retention period for table in this case?

Select 1 option(s):

1 day

0 day

7 days

Q65. Which of the following is a common case for Cloning in Snowflake? (Select all that apply)

Select 3 option(s):

Data Encryption Protection

“Point in Time“ Snapshot

Agile Release and Development

Data Life Cycle Management