Question 721 · 1323 in bank
What Snowflake function should be used to unload relational data to JSON?
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 Snowflake function should be used to unload relational data to JSON?
Answer: B
Floating point values are truncated when unloaded to which file format?
Answer: B
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately (15,9). The values are not truncated when unloading floating-point number columns to Parquet files.
Source: Adapted from community discussion — ShagunMittal
Which levels can apply network policies? (Choose two.)
Answer: AE
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
Answer: AC
What causes objects in a data share to become unavailable to a consumer account?
Answer: C
A. The DATA_RETENTION_TIME parameter in the consumer account determines how long data that is imported from a data share is retained in the account. If this parameter is set to 0, the data is immediately deleted after import. This parameter setting does not affect the availability of objects in the data share. B. The GRANT IMPORTED PRIVILEGES command is used to grant privileges on objects that are imported from a data share to a consumer account. Running this command every 24 hours does not affect the availability of objects in the data share. D. Private data exchange is a feature that allows two or more Snowflake accounts to exchange data privately, without going through the public internet. Acquiring a data share through a private data exchange does not affect the availability of objects in the data share.
Source: Adapted from community discussion — sjndds
How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?
Answer: D
https://docs.snowflake.com/en/user-guide/scim-intro Administrators can query the rest_event_history table to determine whether the identity provider is sending updates (i.e. SCIM API requests) to Snowflake.
Source: Adapted from community discussion — sjndds
A Snowflake user is writing a User-Defined Function (UDF) with some unqualified object names. How will those object names be resolved during execution?
Answer: B
In queries, unqualified object names are resolved through a search path. The SEARCH_PATH is not used inside views or Writing User-Defined Functions (UDFs). All unqualifed objects in a view or UDF definition will be resolved in the view’s or UDF’s schema only. https://docs.snowflake.com/en/sql-reference/name-resolution
Source: Adapted from community discussion — OTE
Why should a user select the economy scaling policy for a multi-cluster warehouse?
Answer: D
Economy Conserves credits by favoring keeping running clusters fully-loaded rather than starting additional clusters, which may result in queries being queued and taking longer to complete.
Source: Adapted from community discussion — bibisa
What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?
Answer: C
Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflake?
Answer: B
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 721. 1323 questions available.
Version 1.0.0. How we source questions