Question 151 · 1323 in bank
Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?
Show answer
Answer: C
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
Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?
Answer: C
Which security models are used in Snowflake to manage access control? (Choose two.)
Answer: AD
It's the same response from Gemini, GPT and Claude ;-) Be careful, because they often give different answers. They fail a lot of these tests
Source: Adapted from community discussion — NachoPrendes
Which Snowflake governance feature allows users to assign metadata labels to improve data governance and database access control?
Answer: C
True or False: Data Providers can share data with only the Data Consumer.
Answer: B
Question itself is tricky. Usually Data providers provides the data to data Consumers. But a provider can also become a consumer. So can anyone please comment what should be the right answer . I think it should be False, as Data providers can share data with consumer and other providers as well
Source: Adapted from community discussion — Sid460545
What is the MINIMUM Snowflake edition that supports database replication?
Answer: A
Which Snowflake function and command combination should be used to convert rows in a relational table to a single VARIANT column, and unload the rows into a file in JSON format? (Choose two.)
Answer: CE
Which privilege grants the ability to set a column-level security masking policy on a table or view column?
Answer: A
When sharing data in Snowflake, what privileges does a Provider need to grant along with a share? (Choose two.)
Answer: CD
GRANT USAGE ON DATABASE sales_db TO SHARE sales_s; GRANT USAGE ON SCHEMA sales_db.aggregates_eula TO SHARE sales_s; GRANT SELECT ON TABLE sales_db.aggregates_eula.aggregate_1 TO SHARE sales_s;
Source: Adapted from community discussion — MSIDDIQUI18
Which data type can be used for floating-point numbers without losing precision?
Answer: D
Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?
Answer: D
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 151. 1323 questions available.
Version 1.0.0. How we source questions