COF-C02 practice questions 171–180

1. Question 171 · 1323 in bank

   True or False: Once created, a micro-partition will never be changed.

   • ATrue
   • BFalse

   Show answer

   Answer: A

   Explanation

   In reclustering context, reorganizing doesn't mean that anything changes in existing micro-partitions' structure - instead the new micro-partitions are created with the same keys as in old micro-partitions before reclustering but reorganized to fit the clustering requirements. Check this article for a reference: https://docs.snowflake.com/en/user-guide/tables-clustering-keys#reclustering Check the diagram from a provided example. New micro-partitions are called "new" for a reason, also the new numbering (micro-partition 5, 6, 7, 8) should give you a clue.

   Source: Adapted from community discussion — rogerek077

   References

   • Snowflake documentation

   Next question

2. Question 172 · 1323 in bank

   Which command is used to unload data from a Snowflake table into a Snowflake stage?

   • AGET
   • BCREATE STAGE
   • CCOPY INTO [location]
   • DPUT

   Show answer

   Answer: C

   Next question

3. Question 173 · 1323 in bank

   What should an account administrator do to help a user log into Snowflake, if the user cannot authenticate using Multi-Factor Authentication (MFA)?

   • ASet DISABLE_MFA to TRUE for the user.
   • BSet MINS_TO_BYPASS_MFA equal to 0 for the user.
   • CSet ALLOW_ID_TOKEN to FALSE for the user.
   • DSet ALLOW_CLIENT_MFA_CACHING to FALSE for the user.

   Show answer

   Answer: A

   Next question

4. Question 174 · 1323 in bank

   Which command can be executed from a reader account?

   • AINSERT
   • BCREATE SHARE
   • CSHOW PROCEDURES
   • DCOPY INTO [location]

   Show answer

   Answer: D

   Explanation

   "However, you can use the COPY INTO command with your connection credentials to unload data into a cloud storage location. Additionally, you cannot execute the following commands in a reader account: INSERT UPDATE DELETE MERGE CREATE IMAGE REPOSITORY COPY INTO CREATE MASKING POLICY CREATE PIPE CREATE ROW ACCESS POLICY CREATE SERVICE CREATE SHARE CREATE STAGE SHOW PROCEDURES" https://docs.snowflake.com/en/user-guide/data-sharing-reader-create

   Source: Adapted from community discussion — rsofia

   References

   • Snowflake documentation

   Next question

5. Question 175 · 1323 in bank

   Which command line parameter value can be pre-specified as an environment variable in SnowSQL?

   • AHOST
   • BVARIABLE
   • COPTION
   • DMFA-PASSCODE

   Show answer

   Answer: A

   Explanation

   "Currently, environment variables can only be used to pre-specify some command line parameter values such as password, host, and database" https://docs.snowflake.com/en/user-guide/snowsql-start#:~:text=Currently%2C%20environment%20variables%20can%20only%20be%20used%20to%20pre%2Dspecify%20some%20command%20line%20parameter%20values%20such%20as%20password%2C%20host%2C%20and%20database

   Source: Adapted from community discussion — theriderzone

   References

   • Snowflake documentation

   Next question

6. Question 176 · 1323 in bank

   Which command is used to determine the file name of each row of data from a staged file?

   • ASHOW FILE FORMATS
   • BSELECT METADATA$FILE_CONTENT_KEY
   • CSELECT METADATA$FILE_ROW_NUMBER
   • DSELECT METADATA$FILENAME

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

7. Question 177 · 1323 in bank

   Which Snowflake feature improves the performance of point lookup queries?

   • AMaterialized views
   • BAutomatic clustering
   • CQuery acceleration service
   • DSearch optimization service

   Show answer

   Answer: D

   Next question

8. Question 178 · 1323 in bank

   Select 2

   What is the impact of selecting one Snowflake edition over another? (Choose two.)

   • AThe edition will impact the unit costs for storage.
   • BThe edition will impact which regions can be accessed by the accounts.
   • CThe edition will determine the unit costs for the compute credits.
   • DThe edition will impact the total allowed storage space.
   • EThe edition will set a limit on the number of compute credits that can be consumed.

   Show answer

   Answer: AC

   References

   • Snowflake documentation

   Next question

9. Question 179 · 1323 in bank

   Select 3

   What services does Snowflake automatically provide for customers that they may have been responsible for with their on-premise system? (Choose all that apply.)

   • AInstalling and configuring hardware
   • BPatching software
   • CPhysical security
   • DMaintaining metadata and statistics

   Show answer

   Answer: ABD

   Explanation

   The are not on prem though as you noted and the question refers to On-Prem. I'd argue all are correct as sometimes organizations do set up their own data centers and ensure security along with other operational aspects like electricity, water etc for cooling and maintenance

   Source: Adapted from community discussion — Sonny22

   References

   • Snowflake documentation

   Next question

10. Question 180 · 1323 in bank

    Which command should be used to drop files from an internal or external stage?

    • ADELETE
    • BDROP
    • CREMOVE
    • DTRUNCATE

    Show answer

    Answer: C

    Next question

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

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