COF-C02 practice questions 291–300

1. Question 291 · 1323 in bank

   True or False: When Snowflake is configured to use Single Sign-On (SSO), Snowflake receives the usernames and credentials from the SSO service and loads them into the customer's Snowflake account.

   • ATrue
   • BFalse

   Show answer

   Answer: B

   Explanation

   No. it does not save any credentials in an Account. Purpose of Federated and SSO is to authenticate the User and pass the authorization to SSO/Snowflake. user authentication is separated from user access through the use of one or more external entities that provide independent authentication of user credentials. The authentication is then passed to one or more services, enabling users to access the services through SSO. A federated environment consists of the following components: Service provider (SP): In a Snowflake federated environment, Snowflake serves as the SP. Identity provider (IdP): The external, independent entity responsible for providing the following services to the SP: Creating and maintaining user credentials and other profile information. Authenticating users for SSO access to the SP.

   Source: Adapted from community discussion — Rajivnb

   References

   • Snowflake documentation

   Next question

2. Question 292 · 1323 in bank

   Select 2

   Which JSON paths are considered to be equivalent in Snowflake? (Choose two.)

   • Asrc['customer']['EMAIL']
   • Bsrc['CUSTOMER']['Email']
   • CSRC:Customer.Email
   • Dsrc:customer.email
   • ESRC:customer.email

   Show answer

   Answer: DE

   Next question

3. Question 293 · 1323 in bank

   What happens when a table or schema with a standard retention period is dropped?

   • AThe object is immediately removed from the system.
   • BThe object is instantaneously moved to Fail-safe.
   • CThe object is retained but all associated data is immediately purged.
   • DThe object is retained for the data retention period.

   Show answer

   Answer: D

   Next question

4. Question 294 · 1323 in bank

   When cloning tables, which INFORMATION_SCHEMA view will show different columns for owned storage and referenced storage?

   • ADATABASE_STORAGE_USAGE_HISTORY
   • BSTAGE_STORAGE_USAGE_HISTORY
   • CTABLE_STORAGE_METRICS
   • DSTORAGE_USAGE

   Show answer

   Answer: C

   Next question

5. Question 295 · 1323 in bank

   Select 2

   Based on a review of a Query Profile, which scenarios will benefit the MOST from the use of a data clustering key? (Choose two.)

   • AA column that appears most frequently in ORDER BY operations
   • BA column that appears most frequently in WHERE operations
   • CA column that appears most frequently in GROUP BY operations
   • DA column that appears most frequently in AGGREGATE operations
   • EA column that appears most frequently in JOIN operations

   Show answer

   Answer: BC

   Next question

6. Question 296 · 1323 in bank

   When working with dimension tables that change frequently, what is the recommended way to manage costs?

   • AKeep the Time Travel retention period for the dimension tables to 7 days or less.
   • BMake the dimension tables transient with a retention period of 0 days, and backup the table daily to a permanent table. Delete all but the latest backup.
   • CMake the dimension tables transient and back-up the data daily into a permanent table using cloning.
   • DMake the dimension tables permanent with a retention period of 7 days. Replicate the database to a secondary database once a week.

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

7. Question 297 · 1323 in bank

   What Snowflake privilege should be granted to allow a non-ACCOUNTADMIN access to billing information?

   • AOPERATE
   • BMONITOR USAGE
   • COWNERSHIP
   • DUSAGE

   Show answer

   Answer: B

   Next question

8. Question 298 · 1323 in bank

   Select 3

   Which of the following are best practices for loading data into Snowflake? (Choose three.)

   • AAim to produce data files that are between 100 MB and 250 MB in size, compressed.
   • BLoad data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
   • CEnclose fields that contain delimiter characters in single or double quotes.
   • DSplit large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
   • EWhen planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
   • FPartition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

   Show answer

   Answer: ACD

   Explanation

   A, C, D https://docs.snowflake.com/en/user-guide/data-load-considerations.html A. To optimize the number of parallel operations for a load, we recommend aiming to produce data files roughly 100-250 MB (or larger) in size compressed. C. Fields that contain delimiter characters should be enclosed in quotes (single or double). If the data contains single or double quotes, then those quotes must be escaped. D. Split larger files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

   Source: Adapted from community discussion — Manocs

   References

   • Snowflake documentation

   Next question

9. Question 299 · 1323 in bank

   What virtual warehouse feature or setting will reduce the performance impact when running larger-than-average queries, by offloading portions of the query processing work to shared compute resources?

   • AUsing a multi-cluster virtual warehouse
   • BUsing the query acceleration service
   • CUsing the search optimization service
   • DDisabling auto-suspend

   Show answer

   Answer: B

   Next question

10. Question 300 · 1323 in bank

    Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?

    • AAlerts
    • BExternal tables
    • CSecure views
    • DMaterialized views

    Show answer

    Answer: A

    References

    • Snowflake documentation

    Next question

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

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