COF-C02 practice questions 1,291–1,300

1. Question 1291 · 1323 in bank

   What privilege is required to view the load statistics on a virtual warehouse?

   • AMODIFY
   • BOPERATE
   • CMONITOR
   • DUSAGE

   Show answer

   Answer: C

   Next question

2. Question 1292 · 1323 in bank

   How can a Snowflake user access near real-time metrics that can be used to identify queries affected by disk spilling?

   • AUse a load monitoring chart.
   • BReview the history section of the Query Profile.
   • CImplement a Snowsight dashboard.
   • DUse a worksheet.

   Show answer

   Answer: B

   Next question

3. Question 1293 · 1323 in bank

   When working with table MY_TABLE that contains 10 rows, which sampling query will always return exactly 5 rows?

   • ASELECT * FROM MY_TABLE SAMPLE SYSTEM (5);
   • BSELECT * FROM MY_TABLE SAMPLE BERNOULLI (5);
   • CSELECT * FROM MY_TABLE SAMPLE (5 ROWS);
   • DSELECT * FROM MY_TABLE SAMPLE SYSTEM (1) SEED (5);

   Show answer

   Answer: C

   Next question

4. Question 1294 · 1323 in bank

   Select 2

   How can files in a stage be loaded after the file metadata has expired? (Choose two.)

   • ASet the LOAD_UNCERTAIN_FILES option to TRUE.
   • BRemove the files from the stage and reload them.
   • CSet the FORCE parameter to TRUE.
   • DTruncate the target table and reload the files.
   • EUse the ALTER TABLE...REFRESH command

   Show answer

   Answer: AC

   Next question

5. Question 1295 · 1323 in bank

   What statement describes Snowflake data architecture?

   • ANoSQL warehouse as a service
   • BSingle-node, isolated data
   • CMulti-cluster, shared data
   • DCentralized data storage and processing

   Show answer

   Answer: C

   Next question

6. Question 1296 · 1323 in bank

   What privileges are required to activate a network policy for an individual user within a Snowflake account?

   • AA user with a role that has been granted the global ATTACH POLICY privilege
   • BA user with a role that has been granted the CREATE SESSION POLICY privilege
   • CA user with a role that has been granted the CREATE NETWORK POLICY privilege
   • DA user with a role that has been granted the OWNERSHIP privilege on both the user and the network policy

   Show answer

   Answer: D

   Next question

7. Question 1297 · 1323 in bank

   How does Snowflake use Multi-Factor Authentication (MFA)?

   • AMFA is an integrated feature powered by the Duo Security service.
   • BMFA is enabled by default for any user having the ACCOUNTADMIN role.
   • CAn MFA login is designed to log in to Snowflake only through Snowsight.
   • DMFA is enabled by default for each user and does not require activation.

   Show answer

   Answer: A

   Next question

8. Question 1298 · 1323 in bank

   Which command is used to download data from Snowflake to a client machine?

   • ACOPY INTO [location]
   • BPUT
   • CDROP
   • DGET

   Show answer

   Answer: D

   Next question

9. Question 1299 · 1323 in bank

   Which Snowflake data governance feature supports the tracking of sensitive data for compliance, discovery, protection, and resource usage?

   • ARow access policies
   • BData classification
   • CObject dependencies
   • DObject tagging

   Show answer

   Answer: D

   Next question

10. Question 1300 · 1323 in bank

    When an ACCOUNTADMIN gives a user a custom role, what privilege or privileges is the user granted by default?

    • AAll privileges that have been granted to the ACCOUNTADMIN
    • BAll privileges on objects allowed by the custom role
    • CAccess to the PUBLIC role
    • DAccess to all the objects owned by the USERADMIN role

    Show answer

    Answer: C

    Next question

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

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