Question 231 · 1323 in bank
The CUSTOMER table in the T1 database is accidentally dropped. Which privileges are required to restore this table? (Choose two.)
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
The CUSTOMER table in the T1 database is accidentally dropped. Which privileges are required to restore this table? (Choose two.)
Answer: B
A stream object will advance its offset when it is used in which statement?
Answer: B
What does an integration between Snowflake and Microsoft Private Link or AWS PrivateLink support?
Answer: D
Which type of URL gives permanent access to files in cloud storage?
Answer: D
Which Snowflake data governance feature supports resource usage monitoring?
Answer: D
True or False: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.
Answer: B
Snowflake supports defining and maintaining constraints, but does not enforce them, except for NOT NULL constraints, which are always enforced.
Source: Adapted from community discussion — BigDataBB
Which functions can be used to identify the data type stored in a VARIANT column? (Choose two.)
Answer: AB
Snowflake does not have an IS_XML function. While Snowflake can store XML-like structures in VARIANT columns, the format isn't natively checked as XML.
Source: Adapted from community discussion — pieterjacobi1
How can data be shared between two users who have different Snowflake accounts?
Answer: B
A user executed a SELECT query in Snowsight which returned a 1 GB result set. The user then downloads the files. What will occur?
Answer: B
Which command can be used to unload data into an external named stage in Snowflake?
Answer: CD
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 231. 1323 questions available.
Version 1.0.0. How we source questions