COF-C02 practice questions 561–570

1. Question 561 · 1323 in bank

   The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

   • AUSERADMIN
   • BPUBLIC
   • CORGADMIN
   • DSYSADMIN

   Show answer

   Answer: A

   Explanation

   A:UserAdmin https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html#using-the-accountadmin-role By default, when your account is provisioned, the first user is assigned the ACCOUNTADMIN role. This user should then create one or more additional users who are assigned the USERADMIN role. All remaining users should be created by the user(s) with the USERADMIN role or another role that is granted the global CREATE USER privilege

   Source: Adapted from community discussion — halol

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

2. Question 562 · 1323 in bank

   Which statement describes how Snowflake supports reader accounts?

   • AA reader account can consume data from the provider account that created it and combine it with its own data.
   • BA consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
   • CThe users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
   • DThe SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

   Show answer

   Answer: D

   Explanation

   SHOW MANAGED ACCOUNTS Lists the managed accounts created for your account. Currently used by data providers to create reader accounts for their consumers. https://docs.snowflake.com/en/sql-reference/sql/show-managed-accounts.html

   Source: Adapted from community discussion — SV1122

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

3. Question 563 · 1323 in bank

   How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

   • AThe data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.
   • BThe data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.
   • CThe data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.
   • DThe data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

4. Question 564 · 1323 in bank

   Select 3

   Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

   • ASchemas
   • BRoles
   • CSecure Views
   • DStored Procedures
   • ETables
   • FSecure User-Defined Functions (UDFs)

   Show answer

   Answer: CEF

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

5. Question 565 · 1323 in bank

   Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

   • ACOPY INTO
   • BCREATE PIPE
   • CINSERT INTO
   • DTABLE STREAM

   Show answer

   Answer: B

   Next question

6. Question 566 · 1323 in bank

   Which Snowflake partner specializes in data catalog solutions?

   • AAlation
   • BDataRobot
   • Cdbt
   • DTableau

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

7. Question 567 · 1323 in bank

   Which of the following can be executed/called with Snowpipe?

   • AA User Defined Function (UDF)
   • BA stored procedure
   • CA single COPY_INTO statement
   • DA single INSERT_INTO statement

   Show answer

   Answer: C

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

8. Question 568 · 1323 in bank

   Select 2

   Which snowflake objects will incur both storage and cloud compute charges? (Choose two.)

   • AMaterialized view
   • BSequence
   • CSecure view
   • DTransient table
   • EClustered table

   Show answer

   Answer: AE

   Explanation

   I think it is A and E. Clustered table needs to undergo clustering as the data changes and Materialized view also undergoes changes every time the underlying data changes or when the view is set to refresh.

   Source: Adapted from community discussion — SV1122

   Next question

9. Question 569 · 1323 in bank

   Select 3

   What file formats does Snowflake support for loading semi-structured data? (Choose three.)

   • ATSV
   • BJSON
   • CPDF
   • DAvro
   • EParquet
   • FJPEG

   Show answer

   Answer: BDE

   Explanation

   Snowflake can import semi-structured data from JSON, Avro, ORC, Parquet, and XML formats and store it in Snowflake data types designed specifically to support semi-structured data. And it stores in Array, Object, and Variant formats https://docs.snowflake.com/en/user-guide/semistructured-intro.html#:~:text=Snowflake%20can%20import%20semi%2Dstructured,to%20support%20semi%2Dstructured%20data.

   Source: Adapted from community discussion — SV1122

   References

   • Snowflake documentation

   Next question

10. Question 570 · 1323 in bank

    Select 2

    Which of the following statements about data sharing are true? (Choose two.)

    • ANew objects created by a Data Provider are automatically shared with existing Data Consumers and Reader Accounts.
    • BAll database objects can be included in a shared database.
    • CReader Accounts are created by Data Providers.
    • DShared databases are read-only.
    • EReader Accounts are charged for warehouse usage.

    Show answer

    Answer: CD

    References

    • Snowflake documentation

    Next question

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

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