Question 741 · 1323 in bank
Select 2How does Snowflake store a table's underlying data? (Choose two.)
Show answer
Answer: AB
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
How does Snowflake store a table's underlying data? (Choose two.)
Answer: AB
What is the MAXIMUM number of days a Snowflake-managed encryption key can be used before it gets automatically rotated?
Answer: C
Which user object property requires contacting Snowflake Support in order to set a value for it?
Answer: C
correct answer C It is possible to temporarily bypass a network policy for a set number of minutes by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY, which can be viewed by executing DESCRIBE USER. Only Snowflake can set the value for this object property. Please contact Snowflake Support to set a value for this property.
Source: Adapted from community discussion — qiyan1982
How does Snowflake handle the bulk unloading of data into single or multiple files?
Answer: A
from doc: Bulk Unloading into Single or Multiple Files The COPY INTO command provides a copy option (SINGLE) for unloading data into a single file or multiple files. The default is SINGLE = FALSE (i.e. unload into multiple files). Snowflake assigns each file a unique name. The location path specified for the command can contain a filename prefix that is assigned to all the data files generated. If a prefix is not specified, Snowflake prefixes the generated filenames with data_.
Source: Adapted from community discussion — bibisa
What information is included in the display in the Query Profile? (Choose two.)
Answer: DE
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
Answer: D
Answer is correct. "Which holds the results of every query executed in the past 24 hours. These are available across virtual warehouses, so query results returned to one user is available to any other user on the system who executes the same query, provided the underlying data has not changed."
Source: Adapted from community discussion — moon2351
A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently. What should the user do?
Answer: C
When using the ALLOW_CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
Answer: C
MFA token caching can help to reduce the number of prompts that must be acknowledged while connecting and authenticating to Snowflake, especially when multiple connection attempts are made within a relatively short time interval. A cached MFA token is valid for up to four hours.
Source: Adapted from community discussion — bibisa
When unloading data, which file formats are supported by the COPY INTO [location] command? (Choose two.)
Answer: BD
A JSON object is loaded into a column named data using a Snowflake variant datatype. The root node of the object is BIKE. The child attribute for this root node is BIKEID. Which statement will allow the user to access BIKEID?
Answer: C
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 741. 1323 questions available.
Version 1.0.0. How we source questions