Question 411 · 1323 in bank
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
Show answer
Answer: B
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
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
Answer: B
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table. How can this be accomplished?
Answer: B
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of queries is always queuing in the warehouse. According to recommended best practice, what should be done to reduce the queue volume? (Choose two.)
Answer: AD
Hi @Tapasgup007 from: https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance If the running query load is high or there’s queuing, consider starting a separate warehouse and moving queued queries to that warehouse. Alternatively, if you are using multi-cluster warehouses, you could change your multi-cluster settings to add additional clusters to handle higher concurrency going forward. To Increse the size of warehouse is the right answer if: If the running query load is low and query performance is slow, you could resize the warehouse to provide more compute resources. You would need to restart the query once all the new resources were fully provisioned to take advantage of the added resources But the question said that we have " high volume of queries". So the right answers are A,D
Source: Adapted from community discussion — BigDataBB
Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)
Answer: BC
Where can a user find and review the failed logins of a specific user for the past 30 days?
Answer: B
True or False: Data in fail-safe can be deleted by a user or the Snowflake team before it expires.
Answer: B
Fail-safe provides a (non-configurable) 7-day period during which historical data may be recoverable by Snowflake. No user operations allowed. https://docs.snowflake.com/en/user-guide/data-failsafe
Source: Adapted from community discussion — aemilka
What is the purpose of an External Function?
Answer: A
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
Answer: AC
Snowflake is a native 100% public cloud solution, you cannot host it on your OWN VPC. All data micro partitions are encrypted.
Source: Adapted from community discussion — psilvabr
A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions: 1. Runs a query that takes 3 minutes to complete 2. Leaves for 15 minutes 3. Returns and runs a query that takes 10 seconds to complete 4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?
Answer: C
I think it is 14 mins because: 3 Minutes for running first time (starting the WH and first execution) Leave for 15 minutes. WH will be iddle after 10 mins. ==> 10 + 3 New execuion = Minimal is 1 minute billed. so: 10+3+1 = 14
Source: Adapted from community discussion — stornati
What can be used to view warehouse usage over time? (Choose two.)
Answer: DE
WAREHOUSE_METERING_HISTORY View This Account Usage view can be used to return the hourly credit usage for a single warehouse (or all the warehouses in your account) within the last 365 days (1 year). https://docs.snowflake.com/en/sql-reference/account-usage/warehouse_metering_history.html Snowsight can be used to view complute cost https://docs.snowflake.com/en/user-guide/cost-exploring-compute.html
Source: Adapted from community discussion — BigDataBB
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 411. 1323 questions available.
Version 1.0.0. How we source questions