Question 1141 · 1323 in bank
Select 2When data is loaded into Snowflake, what formats does Snowflake use internally to store the data in cloud storage? (Choose two.)
Show answer
Answer: BE
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
When data is loaded into Snowflake, what formats does Snowflake use internally to store the data in cloud storage? (Choose two.)
Answer: BE
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
Answer: BD
The answer to this is wrong. Consumption is based on the Size of the Warehouse, Number of Clusters and the amount of time the warehouse is running. The correct answer is therefore B&D
Source: Adapted from community discussion — jjordan
True or False: An active warehouse is required to run a COPY INTO statement.
Answer: A
Answer is A. Execute COPY INTO to load your staged data into the target table. Note that this command requires an active, running warehouse. https://docs.snowflake.com/en/user-guide/getting-started-tutorial-copy-into.html
Source: Adapted from community discussion — Sly007
What kind of authentication do Snowpipe REST endpoints use?
Answer: B
What do temporary and transient tables have in common in Snowflake? (Choose two.)
Answer: AB
What are the least privileges needed to view and modify resource monitors? (Choose two.)
Answer: CD
CD is correct roles that have been granted the following privileges on specific resource monitors can view and modify the resource monitor as needed using SQL: - MONITOR - MODIFY https://docs.snowflake.com/en/user-guide/resource-monitors
Source: Adapted from community discussion — gizzamo
When does a materialized view get suspended in Snowflake?
Answer: B
B ("If a base table is altered so that existing columns are changed or dropped, then all materialized views on that base table are suspended; the materialized views cannot be used or maintained. (This is true even if the modified or dropped column was not part of the materialized view.)")
Source: Adapted from community discussion — ASK_123
What happens when a Snowflake user changes the data retention period at the schema level?
Answer: B
Correct answer is B. -------------------------------------------------------- If you change the data retention period for a database or schema, the change only affects active objects contained within the database or schema. Any objects that have been dropped (for example, tables) remain unaffected. For example, if you have a schema s1 with a 90-day retention period and table t1 is in schema s1, table t1 inherits the 90-day retention period. If you drop table s1.t1, t1 is retained in Time Travel for 90 days. Later, if you change the schema’s data retention period to 1 day, the retention period for the dropped table t1 is unchanged. Table t1 will still be retained in Time Travel for 90 days. -------------------------------------------------------- https://docs.snowflake.com/en/user-guide/data-time-travel#specifying-the-data-retention-period-for-an-object:~:text=through%20Time%20Travel.-,Note,-If%20you%20change
Source: Adapted from community discussion — BobFar
Snowpark provides libraries for which programming languages? (Choose two.)
Answer: BC
How can a Snowflake user sample 10 rows from a table named SNOWPRO? (Choose two.)
Answer: BE
SELECT COUNT(*) FROM SNOWFLAKE_SAMPLE_DATA.TPCDS_SF100TCL.CALL_CENTER; --60 -- A - not correct -- showing different results each time -- 5, 8, 7 SELECT COUNT(*) FROM SNOWFLAKE_SAMPLE_DATA.TPCDS_SF100TCL.CALL_CENTER TABLESAMPLE SYSTEM (10); -- B - correct --10 SELECT COUNT(*) FROM SNOWFLAKE_SAMPLE_DATA.TPCDS_SF100TCL.CALL_CENTER TABLESAMPLE (10 ROWS); -- C - not correct --9,6,11 SELECT COUNT(*) FROM SNOWFLAKE_SAMPLE_DATA.TPCDS_SF100TCL.CALL_CENTER TABLESAMPLE BLOCK (10); -- D - not working --Sampling with a fixed size does not support using block sampling method. SELECT COUNT(*) FROM SNOWFLAKE_SAMPLE_DATA.TPCDS_SF100TCL.CALL_CENTER TABLESAMPLE BLOCK (10 ROWS); -- E - correct -- 10 SELECT COUNT(*) FROM SNOWFLAKE_SAMPLE_DATA.TPCDS_SF100TCL.CALL_CENTER TABLESAMPLE BERNOULLI (10 ROWS);
Source: Adapted from community discussion — 0e504b5
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1141. 1323 questions available.
Version 1.0.0. How we source questions