Question 731 · 1323 in bank
Snowflake Partner Connect is limited to users with a verified email address and which role?
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
Snowflake Partner Connect is limited to users with a verified email address and which role?
Answer: C
What unit of storage supports efficient query processing in Snowflake?
Answer: D
What is the difference between a stored procedure and a User-Defined Function (UDF)?
Answer: A
Which URL type does Snowflake recommend to use when providing unstructured data to other accounts through a share?
Answer: C
Scoped URL Ideal for use in custom applications, for providing unstructured data to other accounts through a share, or for downloading and analysis of unstructured data in Snowsight. https://docs.snowflake.com/en/user-guide/unstructured-intro#:~:text=Ideal%20for%20use%20in%20custom%20applications%2C%20for%20providing%20unstructured%20data%20to%20other%20accounts%20through%20a%20share%2C%20or%20for%20downloading%20and%20analysis%20of%20unstructured%20data%20in%20Snowsight.
Source: Adapted from community discussion — aemilka
True or False: Snowflake charges additional fees to Data Providers for each Share they create.
Answer: B
According to the documentation sited: "The costs for sharing data with Snowflake are minimal and straightforward. Data providers simply pay Snowflake for the data they store, and data consumers pay for the compute resources their queries consume."
Source: Adapted from community discussion — jjordan
What is the MAXIMUM Time Travel retention period for a transient table?
Answer: B
What is the advantage of using a reader account?
Answer: A
What command is used to export or unload data from Snowflake?
Answer: C
A Snowflake user wants to share data with someone who does not have a Snowflake account. How can the Snowflake user share the data?
Answer: B
A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?
Answer: A
Check this: https://docs.snowflake.com/en/user-guide/security-access-control-configure#:~:text=The%20following%20diagram%20shows%20an%20example%20role%20hierarchy%20and%20the%20privileges%20granted%20to%20each%20role%3A Clearly shows that procedure of adding additional privileges to the system-defined roles is by granting the additional privileges to a custom role which is than assigned to SYSADMIN role. And we know that Snowflake recomends assigning custom roles to SYSADMIN role - which is what this trick questions is all about.
Source: Adapted from community discussion — Hrvo77
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 731. 1323 questions available.
Version 1.0.0. How we source questions