Question 251 · 1323 in bank
At what level is the ALLOW_CLIENT_MFA_CACHING parameter configurable in Snowflake?
Show answer
Answer: C
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
At what level is the ALLOW_CLIENT_MFA_CACHING parameter configurable in Snowflake?
Answer: C
A size X-Small virtual warehouse ran for 90 seconds, and was shut down. The warehouse was then run for another 30 seconds before being shut down again. How many seconds will be billed?
Answer: C
The answer is C as anytime less then the first min is billed to the first min and then anytime beyond that is billed to second. https://docs.snowflake.com/en/user-guide/cost-understanding-overall
Source: Adapted from community discussion — c561a14
Which virtual warehouse configuration is recommended specifically for a steady workload that has no execution lag?
Answer: B
Per Snowflake docs - Setting AUTO_SUSPEND to 0 or NULL is not recommended, unless your query workloads require a continually running warehouse. Note that this can result in significant consumption of credits (and corresponding charges), particularly for larger warehouses. In this case it would be reasonable to do as the scenario calls out a continuous query load. https://docs.snowflake.com/en/sql-reference/sql/create-warehouse
Source: Adapted from community discussion — c561a14
Which role allows a Snowflake user to view table-level storage utilization information from the TABLE_STORAGE_METRICS view by default?
Answer: A
This statement is run: SELECT { 'key' : { 'subkey': 'value' }} mycolumn; What notations will retrieve the 'value' from the VARIANT column? (Choose two.)
Answer: CE
Which multi-cluster virtual warehouse setting will help process queued queries as quickly as possible?
Answer: B
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
Answer: B
https://docs.snowflake.com/en/user-guide/security-access-control-overview#roles "When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN." B is correct according to that article
Source: Adapted from community discussion — rogerek077
Which Snowflake tool provides detailed execution statistics of a query with no cost to the user?
Answer: B
Looking for other opinions. The fact that in the question it is mentioned "without any cost to the user, worries me. WE know that for Query Profile, we have to execute the query. This will consume compute credits. Query history, does not require a new execution of the query. I am not sure, about the answer. Maybe, it is B.
Source: Adapted from community discussion — 37ceea2
Which table type is used in the file processing pipeline to process unstructured data in Snowflake?
Answer: B
Which metrics in the QUERY_HISTORY Account _Usage View can be used to assess the pruning efficiency of a query? (Choose two.)
Answer: BE
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 251. 1323 questions available.
Version 1.0.0. How we source questions