COF-C02 Free Practice Test

- (Topic 4)
A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.
Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

1. A. CREATE TABLE <table_name> LIKE TABLE_A;
2. B. CREATE VIEW AS SELECT * FROM TABLE_A;
3. C. CREATE TABLE AS SELECT * FROM TABLE_A;
   D. CREATE MATERIALIZED VIEW AS SELECT * FROM TABLE A;
   Reveal SolutionNext Question

   Correct Answer: C
   When a tag object is assigned to a table, using the statement CREATE TABLE <table_name> AS SELECT * FROM TABLE_A will automatically assign the TABLE_A tag to the newly created table2.

   QUESTION 32

   - (Topic 3)
   Which parameter prevents streams on tables from becoming stale?

   1. A. MAXDATAEXTENSIONTIMEINDAYS
   2. B. MTN_DATA_RETENTION_TTME_TN_DAYS
   3. C. LOCK_TIMEOUT
   4. D. STALE_AFTER

   Reveal Solution Next Question

   Correct Answer: A
   The parameter that prevents streams on tables from becoming stale is MAXDATAEXTENSIONTIMEINDAYS. This parameter specifies the maximum number of days for which Snowflake can extend the data retention period for the table to prevent streams on the table from becoming stale4.

   QUESTION 33

   - (Topic 1)
   The fail-safe retention period is how many days?

   1. A. 1 day
   2. B. 7 days
   3. C. 45 days
   4. D. 90 days

   Reveal Solution Next Question

   Correct Answer: B
   Fail-safe is a feature in Snowflake that provides an additional layer of data protection. After the Time Travel retention period ends, Fail-safe offers a non-configurable 7-day period during which historical data may be recoverable by Snowflake. This period is designed to protect against accidental data loss and is not intended for customer access. References: Understanding and viewing Fail-safe | Snowflake Documentation

   QUESTION 34

   - (Topic 6)
   Which DDL/DML operation is allowed on an inbound data share?

   1. A. ALTER TA3LE
   2. B. INSERT INTO
   3. C. MERGE
   4. D. SELECT

   Reveal Solution Next Question

   Correct Answer: D
   In Snowflake, an inbound data share refers to the data shared with an account by another account. The only DDL/DML operation allowed on an inbound data share is SELECT. This restriction ensures that the shared data remains read-only for the consuming account, maintaining the integrity and ownership of the data by the sharing account.
   References:
   ✑ Snowflake Documentation: Using Data Shares

   QUESTION 35

   - (Topic 3)
   How can a data provider ensure that a data consumer is going to have access to the required objects?

   1. A. Enable the data sharing feature in the account and validate the view.
   2. B. Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.
   3. C. Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.
   4. D. Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.

   Reveal Solution Next Question

   Correct Answer: A
   To ensure a data consumer has access to the required objects, a data provider can enable the data sharing feature and validate that the consumer can access the views or tables shared with them. References: Based on general data sharing practices in cloud services as of 2021.

   • 1
   • 2
   • 3
   • 4
   • 5
   • 6
   • 7
   • 8
   • 9
   • 10
   • 11
   • 12
   • 13
   • 14
   • 15
   • 16
   • 17
   • 18
   • 19
   • 20
   • 21
   • 22
   • 23
   • 24
   • 25
   • 26
   • 27
   • 28
   • 29
   • 30
   • 31
   • 32
   • 33
   • 34
   • 35
   • 36
   • 37
   • 38
   • 39
   • 40
   • 41
   • 42
   • 43
   • 44
   • 45
   • 46
   • 47
   • 48
   • 49
   • 50
   • 51
   • 52
   • 53

   Want to Unlock All Questions for this Exam?
   98.4% Pass Rate

   Full Exam Access

   Practice Test

   Use this for 1year and renew if you’re satisfied.

   $19.95

   Practice, PDF

   Go to Shop