Question 281 · 1323 in bank
Which Snowflake virtual warehouse configuration enables horizontal scaling?
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
Which Snowflake virtual warehouse configuration enables horizontal scaling?
Answer: B
A team is developing a machine learning model by training on the latest Snowflake features. The training is taking much longer than expected to complete. Which step will accelerate the model training?
Answer: C
Un virtual warehouse optimisé pour Snowpark est spécifiquement conçu pour les charges de travail liées à Snowpark, comme l’entraînement de modèles d’apprentissage automatique. Cette optimisation maximise les ressources pour des calculs ML complexes, en rendant le processus plus rapide et plus efficace.
Source: Adapted from community discussion — ea2023
True or False: Fail-safe can be disabled within a Snowflake account.
Answer: B
False : Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature cannot be enabled or disabled from the user end .
Source: Adapted from community discussion — JustVicky
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
Answer: A
Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.
Source: Adapted from community discussion — arpit_dataguy
Which Snowflake objects use storage? (Choose two.)
Answer: AD
Which Snowflake multi-cluster virtual warehouse scaling policy or mode will MINIMIZE query queuing by prioritizing the startup of additional clusters?
Answer: B
Which default warehouse configuration has the highest precedence whenever a new session is created by a user?
Answer: C
Which type of query would benefit from enabling the query acceleration service on the virtual warehouse?
Answer: C
Which table function will return the output of a previously-run command?
Answer: D
How can a relational table be unloaded into a JSON file?
Answer: A
-- Unload the data to a file in a stage COPY INTO @mystage FROM (SELECT OBJECT_CONSTRUCT('id', id, 'first_name', first_name, 'last_name', last_name, 'city', city, 'state', state) FROM mytable) FILE_FORMAT = (TYPE = JSON); -- The COPY INTO location statement creates a file named data_0_0_0.json.gz in the stage.
Source: Adapted from community discussion — 37ceea2
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 281. 1323 questions available.
Version 1.0.0. How we source questions