Course contents

SnowPro Core COF-C03 Study GuidePart 5: Data protection and sharingPractice Questions: Part 5

Practice Questions: Part 5

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.

Practice questions

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

    1. Run RESTORE SCHEMA analytics.reporting AT (OFFSET => -3600);
    2. Run UNDROP SCHEMA analytics.reporting; and Snowflake renames the clone automatically
    3. Rename the cloned schema, then run UNDROP SCHEMA analytics.reporting;
    4. Open a Snowflake Support case to recover the schema from Fail-safe
  2. 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?

    1. Grant USAGE on database DEV_DB to ANALYST
    2. Grant USAGE on every schema in DEV_DB to ANALYST
    3. Nothing, because every grant is copied to the clone
    4. Grant SELECT on every table in DEV_DB to ANALYST
  3. 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?

    1. All 12 files are skipped because the clone has the source's load history
    2. All 12 files are loaded again, duplicating the rows in SALES_DEV
    3. The statement fails because SALES_DEV already holds those rows
    4. Only files staged after the clone was created are loaded
  4. Which statements describe transient tables? (Choose two.)

    1. They're visible only to the session that created them
    2. They support up to 90 days of Time Travel on Enterprise
    3. They have a 7-day Fail-safe period
    4. They exist until someone explicitly drops them
    5. Their Time Travel retention can be 0 or 1 day
  5. A company on Standard edition wants 30 days of Time Travel on its permanent ORDERS table. What has to happen?

    1. Set DATA_RETENTION_TIME_IN_DAYS = 30 on ORDERS
    2. Recreate ORDERS as transient, then set retention to 30
    3. Set MIN_DATA_RETENTION_TIME_IN_DAYS = 30 on the account
    4. Move to Enterprise edition, then set retention to 30
  6. On 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?

    1. 2 days, because the minimum covers only tables created after it
    2. 5 days, because the account minimum acts as a floor
    3. 2 days, because the table-level setting is more specific
    4. 0 days, because the two settings conflict
  7. 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?

    1. CREATE TABLE orders_fix CLONE orders AT (STATEMENT => '<query_id>');
    2. UNDROP TABLE orders BEFORE (STATEMENT => '<query_id>');
    3. CREATE TABLE orders_fix CLONE orders BEFORE (STATEMENT => '<query_id>');
    4. CREATE TABLE orders_fix CLONE orders AT (OFFSET => 1200);
  8. Which queries return table EVENTS as it was 30 minutes ago? (Choose two.)

    1. SELECT * FROM events AT (MINUTES => -30);
    2. SELECT * FROM events AT (OFFSET => 1800);
    3. SELECT * FROM events AT (OFFSET => -1800);
    4. SELECT * FROM events BEFORE (STATEMENT => -1800);
    5. SELECT * FROM events AT (TIMESTAMP => DATEADD(minute, -30, CURRENT_TIMESTAMP()));
  9. 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?

    1. UNDROP TABLE customers;
    2. ALTER TABLE customers UNDO TRUNCATE;
    3. A Snowflake Support request to restore the rows from Fail-safe
    4. INSERT INTO customers SELECT * FROM customers BEFORE (STATEMENT => '<id>');
  10. 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?

    1. Raise the retention to 30 days, then query with AT (TIMESTAMP => ...)
    2. Run UNDROP TABLE with the FAILSAFE option
    3. Open a case with Snowflake Support to request recovery from Fail-safe
    4. Query the table with AT (OFFSET => ...) using the ACCOUNTADMIN role
  11. A provider sets up a reader account for a distributor that has no Snowflake account. Which statements about the reader account are correct? (Choose two.)

    1. The provider creates, owns and manages the reader account
    2. Its users can load their own files into it with COPY INTO
    3. It can consume data only from the provider that created it
    4. Resource monitors can't be set on its warehouses
    5. It can also consume shares from other Snowflake providers
  12. 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?

    1. Set DATA_RETENTION_TIME_IN_DAYS = 0 on the table
    2. Turn on automatic clustering for the table
    3. Recreate it as a temporary table
    4. Recreate it as a transient table
  13. Table 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?

    1. The table dropped on Wednesday is restored
    2. Both versions are restored, the older one renamed
    3. The table dropped on Monday is restored
    4. It fails until the older version is purged
  14. 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?

    1. Ask the consumer to replicate the database into its own account
    2. Add the eu-west-1 consumer account to its existing direct share
    3. Replicate the database and share to its own eu-west-1 account
    4. Create a reader account for the consumer in us-east-1 and share to it
  15. 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?

    1. Nothing, because a clone always reads the source's data
    2. 2 TB after 24 hours, when the clone is materialized
    3. 2 TB, because the clone copies every micro-partition
    4. Only the micro-partitions that the UPDATE rewrote
  16. 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.)

    1. The external stage EXT_STG
    2. The internal named stage INT_STG
    3. Table EVENTS, with an empty table stage
    4. The staged files from EVENTS's table stage
    5. The pipe that loads from INT_STG
  17. Which statements about Time Travel retention are correct? (Choose two.)

    1. Setting retention to 0 also removes Fail-safe from a permanent table
    2. DATA_RETENTION_TIME_IN_DAYS can be set on the account, databases, schemas and tables
    3. Raising retention brings back data that already left Time Travel
    4. Lowering retention keeps existing history until the old period ends
    5. Setting retention to 0 turns off Time Travel for that object
  18. 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?

    1. Enterprise
    2. Business Critical
    3. Virtual Private Snowflake
    4. Standard
  19. 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?

    1. ALTER DATABASE prod_db PRIMARY;
    2. UNDROP DATABASE prod_db;
    3. ALTER DATABASE prod_db REFRESH;
    4. ALTER DATABASE prod_db ENABLE REPLICATION TO ACCOUNTS ...;
  20. 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?

    1. Account B for compute; transfer inside one organization is free
    2. Account A, which owns the primary database
    3. Account A for data transfer, account B for compute
    4. Account B, the target of the replication
  21. 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?

    1. Clone the users, roles and warehouses into the target account
    2. Create a reader account in the second region
    3. Stay on Enterprise and add them to a replication group
    4. Upgrade to Business Critical and use a failover group
  22. A company runs on Standard edition. Which features can it use without upgrading? (Choose two.)

    1. Promoting a secondary database to primary
    2. Keeping 30 days of Time Travel on permanent tables
    3. Sharing tables with another account through a direct share
    4. Replicating a database to another account in its organization
    5. Replicating users and roles to another account
  23. 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?

    1. The provider pays the storage and the consumer's compute
    2. The provider pays the storage; the consumer pays its compute
    3. Both accounts split the storage by how much they query
    4. The consumer pays for its own 3 TB copy and its compute
  24. A consumer creates database PARTNER_DB from a direct share. Which actions can the consumer perform? (Choose two.)

    1. Join PARTNER_DB tables with tables in its own databases
    2. Clone PARTNER_DB into an editable copy
    3. Grant IMPORTED PRIVILEGES on PARTNER_DB to other roles
    4. Insert corrected rows into a PARTNER_DB table
    5. Query a PARTNER_DB table AT (OFFSET => -3600)
  25. 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?

    1. The provider and the supplier, split evenly
    2. The supplier, through a contract the provider sets up
    3. The provider account that created the reader account
    4. The supplier, billed directly by Snowflake
  26. 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?

    1. A secure view that applies the filter
    2. The CUSTOMERS table with a column masking policy
    3. A standard view that applies the filter
    4. The table, with a WHERE clause in the GRANT to the share
  27. Which objects can a provider add to a share? (Choose three.)

    1. Secure UDFs
    2. Virtual warehouses
    3. Resource monitors
    4. Secure views
    5. Tables
  28. 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?

    1. A direct share that names the consumer accounts
    2. Replication of the database to an account in each region
    3. A listing with Cross-Cloud Auto-Fulfillment
    4. A reader account created for each consumer
  29. 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?

    1. A Data Exchange for its existing partners
    2. A private listing shared with named accounts
    3. A paid listing on the Snowflake Marketplace
    4. Direct shares set up for each new customer
  30. 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?

    1. A public listing on the Snowflake Marketplace
    2. One reader account shared by all subsidiaries
    3. Direct shares from the parent to each subsidiary
    4. A Data Exchange that the company administers