COF-C02 practice questions 661–670

1. Question 661 · 1323 in bank

   As a best practice, all custom roles should be granted to which system-defined role?

   • AACCOUNTADMIN
   • BORGADMIN
   • CSECURITYADMIN
   • DSYSADMIN

   Show answer

   Answer: D

   Explanation

   D--Sysadmin Role that has privileges to create warehouses and databases (and other objects) in an account. If, as recommended, you create a role hierarchy that ultimately assigns all custom roles to the SYSADMIN role, this role also has the ability to grant privileges on warehouses, databases, and other objects to other roles.

   Source: Adapted from community discussion — arpit_dataguy

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

2. Question 662 · 1323 in bank

   Which Snowflake object can be accessed in the FROM clause of a query, returning a set of rows having one or more columns?

   • AA User-Defined Table Function (UDTF)
   • BA Scalar User Defined Function (UDF)
   • CA stored procedure
   • DA task

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

3. Question 663 · 1323 in bank

   How are micro-partitions typically generated in Snowflake?

   • AAutomatically
   • BORDER BY [];
   • CPARTITION BY [];
   • DGROUP BY [];

   Show answer

   Answer: A

   Next question

4. Question 664 · 1323 in bank

   Select 2

   What does Snowflake recommend regarding database object ownership? (Choose two.)

   • ACreate objects with ACCOUNTADMIN and do not reassign ownership.
   • BCreate objects with SYSADMIN.
   • CCreate objects with SECURITYADMIN to ease granting of privileges later.
   • DCreate objects with a custom role and grant this role to SYSADMIN.
   • EUse only managed access schemas for objects owned by ACCOUNTADMIN.

   Show answer

   Answer: BD

   Explanation

   B and D are correct SYSADMIN - Role that has privileges to create warehouses and databases (and other objects) in an account. If, as recommended, you create a role hierarchy that ultimately assigns all custom roles to the SYSADMIN role, this role also has the ability to grant privileges on warehouses, databases, and other objects to other roles. https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

   Source: Adapted from community discussion — harshagc180

   References

   • Snowflake documentation

   Next question

5. Question 665 · 1323 in bank

   Select 2

   Other than ownership what privileges does a user need to view and modify resource monitors in Snowflake? (Choose two.)

   • AALTER
   • BMONITOR
   • CMODIFY
   • DCREATE
   • EDROP

   Show answer

   Answer: BC

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

6. Question 666 · 1323 in bank

   What technique does Snowflake recommend for determining which virtual warehouse size to select?

   • AAlways start with an X-Small and increase the size if the query does not complete in 2 minutes
   • BExperiment by running the same queries against warehouses of different sizes
   • CUse the default size Snowflake chooses
   • DUse X-Large or above for tables larger than 1 GB

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

7. Question 667 · 1323 in bank

   Which command should be used when loading many flat files into a single table?

   • APUT
   • BINSERT
   • CCOPY INTO
   • DMERGE

   Show answer

   Answer: C

   Next question

8. Question 668 · 1323 in bank

   How can a Snowflake user share data with another user who does not have a Snowflake account?

   • AShare the data by implementing User-Defined Functions (UDFs)
   • BCreate a reader account and create a share of the data
   • CGrant the READER privilege to the database that is going to be shared
   • DMove the Snowflake account to a region where data sharing is enabled

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

9. Question 669 · 1323 in bank

   Select 2

   Which semi-structured data formats can be loaded into Snowflake with a COPY command? (Choose two.)

   • ACSV
   • BEDI
   • CHTML
   • DORC
   • EXML

   Show answer

   Answer: DE

   References

   • Snowflake documentation

   Next question

10. Question 670 · 1323 in bank

    What is the recommended Snowflake data type to store semi-structured data like JSON?

    • AVARCHAR
    • BRAW
    • CLOB
    • DVARIANT

    Show answer

    Answer: D

    Next question

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

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