100% Pass Top-selling COF-C02 Exams – New 2023 Snowflake Pratice Exam [Q96-Q112]

NEW QUESTION 96
Which parameter prevents streams on tables from becoming stale?

NEW QUESTION 97
Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

NEW QUESTION 98
How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

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

NEW QUESTION 100
How does Snowflake handle the bulk unloading of data into single or multiple files?

NEW QUESTION 101
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

NEW QUESTION 102
A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

NEW QUESTION 103
Which of the following statements is true of data loading?

NEW QUESTION 104
Which statement about billing applies to Snowflake credits?

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

NEW QUESTION 106
For a multi-cluster Warehouse, the number of credits billed is calculated on:

NEW QUESTION 107
The fail-safe retention period is how many days?

NEW QUESTION 108
Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

NEW QUESTION 109
Snowflake is designed for which type of workloads? (Choose two.)

NEW QUESTION 110
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

NEW QUESTION 111
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

NEW QUESTION 112
The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?