Practice Questions · Part 5
Thirty questions in the exam's format: single choice and multiple select, no topic hints. Answer each one, then read the explanation even when you got it right.
SnowPro Core COF-C03 Study GuidePart 5: Data protection and sharingPractice Questions: Part 5
Thirty questions in the exam's format: single choice and multiple select, no topic hints. Answer each one, then read the explanation even when you got it right.
An hour ago a developer ran CREATE OR REPLACE SCHEMA analytics.reporting CLONE analytics.staging; by mistake. It replaced a schema another team was using. The database has a 7-day Time Travel retention. What restores the original REPORTING schema with all its tables?
RESTORE SCHEMA analytics.reporting AT (OFFSET => -3600);UNDROP SCHEMA analytics.reporting; and Snowflake renames the clone automaticallyUNDROP SCHEMA analytics.reporting;An administrator runs CREATE DATABASE dev_db CLONE prod_db;. In PROD_DB, role ANALYST has USAGE on the database, USAGE on its schemas and SELECT on its tables. What must the administrator do so that ANALYST can query the tables in DEV_DB?
Table SALES was loaded from 12 staged files with COPY INTO, and the files are still in the stage. A data engineer clones SALES to SALES_DEV and runs the same COPY INTO statement against SALES_DEV, without the FORCE option. What happens?
Which statements describe transient tables? (Choose two.)
A company on Standard edition wants 30 days of Time Travel on its permanent ORDERS table. What has to happen?
DATA_RETENTION_TIME_IN_DAYS = 30 on ORDERSMIN_DATA_RETENTION_TIME_IN_DAYS = 30 on the accountOn an Enterprise account, ACCOUNTADMIN sets MIN_DATA_RETENTION_TIME_IN_DAYS = 5. A table owner then sets DATA_RETENTION_TIME_IN_DAYS = 2 on table T. How many days of Time Travel does T get?
Twenty minutes ago an analyst ran a DELETE with the wrong WHERE clause on ORDERS. The query ID of that DELETE is known. Which statement creates a copy of ORDERS as it was just before the DELETE ran?
CREATE TABLE orders_fix CLONE orders AT (STATEMENT => '<query_id>');UNDROP TABLE orders BEFORE (STATEMENT => '<query_id>');CREATE TABLE orders_fix CLONE orders BEFORE (STATEMENT => '<query_id>');CREATE TABLE orders_fix CLONE orders AT (OFFSET => 1200);Which queries return table EVENTS as it was 30 minutes ago? (Choose two.)
SELECT * FROM events AT (MINUTES => -30);SELECT * FROM events AT (OFFSET => 1800);SELECT * FROM events AT (OFFSET => -1800);SELECT * FROM events BEFORE (STATEMENT => -1800);SELECT * FROM events AT (TIMESTAMP => DATEADD(minute, -30, CURRENT_TIMESTAMP()));A developer accidentally runs TRUNCATE TABLE customers;. The table has 1 day of Time Travel retention, and the TRUNCATE's query ID is known. What gets the rows back?
UNDROP TABLE customers;ALTER TABLE customers UNDO TRUNCATE;INSERT INTO customers SELECT * FROM customers BEFORE (STATEMENT => '<id>');The Time Travel retention of a permanent table ended three days ago, and the team now needs data from before that point. What can they do?
AT (TIMESTAMP => ...)UNDROP TABLE with the FAILSAFE optionAT (OFFSET => ...) using the ACCOUNTADMIN roleA provider sets up a reader account for a distributor that has no Snowflake account. Which statements about the reader account are correct? (Choose two.)
A 10 TB permanent table is truncated and fully reloaded from source files every night. Analysts query it all day from their own sessions. Its billed storage is several times its active size. The data can be reloaded from source at any time. Which change cuts the storage cost the most?
DATA_RETENTION_TIME_IN_DAYS = 0 on the tableTable T was dropped on Monday. On Tuesday a new table named T was created, and it was dropped on Wednesday. Both drops are inside the retention period, and no table named T exists now. An administrator runs UNDROP TABLE t; once. What's the result?
A provider in AWS us-east-1 must share a database with one consumer account in AWS eu-west-1 that belongs to another company. The provider doesn't want to publish a listing. What should it do?
A team clones a 2 TB table with CREATE TABLE dev_orders CLONE prod_orders; and then runs an UPDATE that touches a few percent of the rows in DEV_ORDERS. What new storage does DEV_ORDERS add?
An administrator runs CREATE DATABASE raw_dev CLONE raw_db; with no other clauses. RAW_DB contains table EVENTS with files in its table stage, an internal named stage INT_STG, an external stage EXT_STG, and a pipe that loads from INT_STG. What does RAW_DEV contain? (Choose two.)
Which statements about Time Travel retention are correct? (Choose two.)
A company replicates its production database to an account in another region. It now wants to be able to promote that secondary database to primary during a regional outage. What is the minimum edition?
During a regional outage, an administrator on a Business Critical account must make the secondary database PROD_DB in the disaster-recovery account writable. Which statement, run in that account, does this?
ALTER DATABASE prod_db PRIMARY;UNDROP DATABASE prod_db;ALTER DATABASE prod_db REFRESH;ALTER DATABASE prod_db ENABLE REPLICATION TO ACCOUNTS ...;A company replicates a database from account A in us-east-1 to account B in eu-west-1 and refreshes it every hour. Which account is billed for the refresh compute and the data transfer?
A company on Enterprise edition replicates its databases to a second region. For disaster recovery it also needs its users, roles and warehouses to exist in the second account and stay in sync. What does it need?
A company runs on Standard edition. Which features can it use without upgrading? (Choose two.)
A provider shares a 3 TB table with a consumer account in the same region through a direct share. The consumer queries it all month with its own warehouse. Which statement about cost is correct?
A consumer creates database PARTNER_DB from a direct share. Which actions can the consumer perform? (Choose two.)
AT (OFFSET => -3600)A provider creates a reader account for a supplier that has no Snowflake account. The supplier runs queries on the shared data every day. Who pays for the credits those queries use?
A provider must share only the rows of CUSTOMERS where region = 'EU', and consumers must not be able to see the filter logic. What should the provider put in the share?
Which objects can a provider add to a share? (Choose three.)
A provider on AWS us-east-1 wants to offer a dataset to many consumer accounts in several Azure regions. Snowflake must handle the copies in the consumers' regions; the provider won't set up or run replication itself. What should the provider use?
A weather-data company wants any Snowflake customer to be able to find its dataset, try it and pay for it, with Snowflake handling the billing. Which option fits?
A holding company wants an invitation-only hub where its subsidiaries join as members, publish data listings and find each other's data. Nothing may be visible to the public. What fits?
Finish this set to count it as done.