COF-C02 practice questions 391–400

1. Question 391 · 1323 in bank

   A user has unloaded data from a Snowflake table to an external stage. Which command can be used to verify if data has been uploaded to the external stage named my_stage?

   • Aview @my_stage
   • Blist @my_stage
   • Cshow @my_stage
   • Ddisplay @my_stage

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

2. Question 392 · 1323 in bank

   Select 2

   Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

   • AManagement of metadata
   • BComputing the data
   • CMaintaining Availability Zones
   • DInfrastructure security
   • EParsing and optimizing queries

   Show answer

   Answer: AE

   References

   • Snowflake documentation

   Next question

3. Question 393 · 1323 in bank

   Select 2

   What is true about sharing data in Snowflake? (Choose two.)

   • AThe Data Consumer pays for data storage as well as for data computing.
   • BThe shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
   • CA Snowflake account can both provide and consume shared data.
   • DThe Provider is charged for compute resources used by the Data Consumer to query the shared data.
   • EThe Data Consumer pays only for compute resources to query the shared data.

   Show answer

   Answer: CE

   Explanation

   The answer key (B and E) given is again wrong per the below Snowflake user-guide. The correct answer should be C and E as per popular vote. With Secure Data Sharing, no actual data is copied or transferred between accounts. All sharing uses Snowflake’s services layer and metadata store. Shared data does not take up any storage in a consumer account and therefore does not contribute to the consumer’s monthly data storage charges. The only charges to consumers are for the compute resources (i.e. virtual warehouses) used to query the shared data. (https://docs.snowflake.com/en/user-guide/data-sharing-intro.html)

   Source: Adapted from community discussion — rneti

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

4. Question 394 · 1323 in bank

   True or False: It is possible to unload structured data to semi-structured formats such as JSON and Parquet.

   • ATrue
   • BFalse

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

5. Question 395 · 1323 in bank

   The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

   

   A user needs to extract the dealership information from the JSON. How can this be accomplished?

   • Aselect src:dealership from car_sales;
   • Bselect src.dealership from car_sales;
   • Cselect src:Dealership from car_sales;
   • Dselect dealership from car_sales;

   Show answer

   Answer: A

   Explanation

   Column name is case-insensitive but element names are case-sensitive. For example, in the following list, the first two paths are equivalent, but the third is not: src:salesperson.name SRC:salesperson.name SRC:Salesperson.Name

   Source: Adapted from community discussion — fellpond

   References

   • Snowflake documentation

   Next question

6. Question 396 · 1323 in bank

   Which of the following significantly improves the performance of selective point lookup queries on a table?

   • AClustering
   • BMaterialized Views
   • CZero-copy Cloning
   • DSearch Optimization Service

   Show answer

   Answer: D

   Explanation

   The search optimization service aims to significantly improve the performance of certain types of queries on tables, including: Selective point lookup queries on tables. A point lookup query returns only one or a small number of distinct rows. Use case examples include: Business users who need fast response times for critical dashboards with highly selective filters. Data scientists who are exploring large data volumes and looking for specific subsets of data. Data applications retrieving a small set of results based on an extensive set of filtering predicates.

   Source: Adapted from community discussion — BigDataBB

   References

   • Snowflake documentation

   Next question

7. Question 397 · 1323 in bank

   Which of the following accurately describes shares?

   • ATables, secure views, and secure UDFs can be shared
   • BShares can be shared
   • CData consumers can clone a new table from a share
   • DAccess to a share cannot be revoked once granted

   Show answer

   Answer: A

   Explanation

   Snowflake enables sharing of data through named Snowflake objects called shares which supports data sharing by sharing tables, secure views, and secure UDFs in our Snowflake database (Data Provider) with other Snowflake accounts (Data Consumer).

   Source: Adapted from community discussion — Lavpak

   References

   • Snowflake documentation

   Next question

8. Question 398 · 1323 in bank

   Select 2

   What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

   • AEnsure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
   • BAll users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
   • CThe ACCOUNTADMIN role must be granted to only one user.
   • DAssign the ACCOUNTADMIN role to at least two users, but as few as possible.
   • EAll users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

   Show answer

   Answer: AD

   Explanation

   All users assigned the ACCOUNTADMIN role should also be required to use multi-factor authentication (MFA) for login (for details, see Configuring Access Control). Assign this role to at least two users.

   Source: Adapted from community discussion — Lavpak

   References

   • Snowflake documentation

   Next question

9. Question 399 · 1323 in bank

   Select 2

   In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Choose two.)

   • ABytes scanned
   • BBytes sent over the network
   • CNumber of partitions scanned
   • DPercentage scanned from cache
   • EExternal bytes scanned

   Show answer

   Answer: AC

   Explanation

   A. Bytes scanned represents the amount of data scanned by the query. By minimizing the number of bytes scanned, query performance can be improved. C. Number of partitions scanned represents the number of partitions read during query execution. By minimizing the number of partitions scanned, query performance can be improved. B, D, and E are incorrect statements. Bytes sent over the network, percentage scanned from cache, and external bytes scanned may provide useful information for monitoring or troubleshooting, but they are not directly related to optimizing query performance.

   Source: Adapted from community discussion — bibisa

   References

   • Snowflake documentation

   Next question

10. Question 400 · 1323 in bank

    What is the minimum Snowflake edition required for row level security?

    • AStandard
    • BEnterprise
    • CBusiness Critical
    • DVirtual Private Snowflake

    Show answer

    Answer: B

    References

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    Next question

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

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