COF-C02 practice questions 1,201–1,210

1. Question 1201 · 1323 in bank

   What is the MINIMUM Snowflake edition required to use the query acceleration service?

   • AStandard
   • BEnterprise
   • CBusiness Critical
   • DVirtual Private Snowflake (VPS)

   Show answer

   Answer: B

   Next question

2. Question 1202 · 1323 in bank

   Which of the following statements is true of Snowflake?

   • AIt was built specifically for the cloud
   • BIt was built as an on-premises solution and then ported to the cloud
   • CIt was designed as a hybrid database to allow customers to store data either on premises or in the cloud
   • DIt was built for Hadoop architecture
   • EIt's based on an Oracle Architecture

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

3. Question 1203 · 1323 in bank

   Which data type can be used to load semi-structured data files directly, without explicitly describing the hierarchical structure of the data?

   • ATEXT
   • BVARIANT
   • CVARCHAR
   • DVARBINARY

   Show answer

   Answer: B

   Next question

4. Question 1204 · 1323 in bank

   The following settings are configured: THE MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level. THE DATA_RETENTION_TIME_IN_DAYS is set to 2 at the object level. For how many days will the data be retained at the object level?

   • A2
   • B3
   • C5
   • D7

   Show answer

   Answer: C

   Explanation

   If there is a minimum retention time set for the account, and a retention time explicitly set on an object, the effective retention time is the greater of the two: MAX(DATA_RETENTION_TIME_IN_DAYS, MIN_DATA_RETENTION_TIME_IN_DAYS). https://docs.snowflake.com/en/release-notes/bcr-bundles/2023_04/bcr-928?utm_source=legacy&utm_medium=serp&utm_term=MIN_DATA_RETENTION_TIME_IN_DAYS

   Source: Adapted from community discussion — Gudref

   References

   • Snowflake documentation

   Next question

5. Question 1205 · 1323 in bank

   Which key access control concept does Snowflake describe as a defined level of access to an object?

   • AGrant
   • BPrivilege
   • CRole
   • DSession

   Show answer

   Answer: B

   Explanation

   Privilege: A defined level of access to an object. Multiple distinct privileges may be used to control the granularity of access granted.

   Source: Adapted from community discussion — nexerSnow

   References

   • Snowflake documentation

   Next question

6. Question 1206 · 1323 in bank

   Select 2

   What actions will trigger a data pipe to load? (Choose two.)

   • AUse of an INSERT statement
   • BUse of a COPY INTO [table] statement
   • CUse of the insertFiles REST endpoint
   • DUse of the insertReport REST endpoint
   • ESet the pipe parameter to auto-ingest

   Show answer

   Answer: CE

   Next question

7. Question 1207 · 1323 in bank

   Which Snowflake object uses credits for maintenance?

   • ARegular table
   • BRegular view
   • CMaterialized view
   • DCached query result

   Show answer

   Answer: C

   Next question

8. Question 1208 · 1323 in bank

   How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?

   • A32
   • B64
   • C128
   • D256

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

9. Question 1209 · 1323 in bank

   A query is using more credits than expected. The Query Profile shows that a majority of the query execution is spent on remote disk I/O. How can this be prevented in the future?

   • AConvert the virtual warehouse to Maximized mode.
   • BIncrease the size of the virtual warehouse.
   • CIncrease the auto suspend time in the virtual warehouse.
   • DIncrease the number of clusters in the virtual warehouse.

   Show answer

   Answer: B

   Next question

10. Question 1210 · 1323 in bank

    What is the purpose of a Query Profile?

    • ATo profile how many times a particular query was executed and analyze its usage statistics over time.
    • BTo profile a particular query to understand the mechanics of the query, its behavior, and performance.
    • CTo profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.
    • DTo profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

    Show answer

    Answer: B

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

COF-C02 practice, question 1201. 1323 questions available.