Question 841 · 1323 in bank
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
Show answer
Answer: D
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
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
Answer: D
By definition, a secure view is exposed only to users with what privilege?
Answer: B
The correct answer is B. OWNERSHIP. A secure view is a view that is defined with the SECURITY DEFINER option. This means that the view definition and details are visible only to authorized users (i.e. users who are granted the role that owns the view). The other privileges listed are not sufficient to view the definition of a secure view.
Source: Adapted from community discussion — bee5k
What happens when a user exits Snowsight during a session that a query is running?
Answer: D
This article says: https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour When you exit Snowsight, Snowflake cancels any queries that you submitted during this session that are still running. However, like another user isolated_sniper said, it continued executing. I submitted a query, ended the session, came back, logged out, logged back in, the query continued executing. So D is correct. B is not correct based on testing. Documentation is not correct /up-to-date.
Source: Adapted from community discussion — 0e504b5
Which native data types are used for storing semi-structured data in Snowflake? (Choose two.)
Answer: BE
Snowflake provides built-in support for importing data from (and exporting data to) the following semi-structured data formats: JSON Avro ORC Parquet XML Snowflake provides native data types (ARRAY, OBJECT, and VARIANT) for storing semi-structured data.
Source: Adapted from community discussion — isolated_sniper
Which columns are available in the output of a Snowflake directory table? (Choose two.)
Answer: CD
RELATIVE_PATH TEXT Path to the files to access using the file URL. SIZE NUMBER Size of the file (in bytes). LAST_MODIFIED TIMESTAMP_LTZ Timestamp when the file was last updated in the stage. MD5 HEX MD5 checksum for the file. ETAG HEX ETag header for the file. FILE_URL TEXT Snowflake file URL to the file.
Source: Adapted from community discussion — [Removed]
What is used to diagnose and troubleshoot network connections to Snowflake?
Answer: A
What Snowflake object records Data Manipulation Language (DML) changes so that actions can be taken using the changed data?
Answer: B
By default, the COPY INTO [location] statement will separate table data into a set of output files to take advantage of which Snowflake feature?
Answer: C
Which command can be used to view the allowed and blocked IP list of a network policy?
Answer: C
. DESCRIBE NETWORK POLICY is correct DESC NETWORK POLICY mypolicy; -----------------+---------------+ name | value | -----------------+---------------+ ALLOWED_IP_LIST | 192.168.0.100 | BLOCKED_IP_LIST | 192.168.0.101 | -----------------+---------------+
Source: Adapted from community discussion — bee5k
Which file functions are non-deterministic? (Choose two.)
Answer: AD
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 841. 1323 questions available.
Version 1.0.0. How we source questions