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
True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.
Answer: B
The question is regarding the assignment of ownership, not the assignment of the role. B is still correct though since the role is not initially owned by the user but rather by the role the user used during creation.
Source: Adapted from community discussion — Badenhop
Which SQL commands should be used to write a recursive query if the number of levels is unknown? (Choose two.)
Answer: AE
CONNECT BY , the recursive CTE portion of the WITH command , Working with CTEs (Common Table Expressions) , Tabular SQL UDFs (UDTFs)
Source: Adapted from community discussion — MultiCloudIronMan
What information is stored in the ACCESS_HISTORY view?
Answer: C
What privilege does a user need in order to receive or request data from the Snowflake Marketplace?
Answer: C
C There are several ways of sharing data on Snowflake, such as: - Direct share - Listings (Snowflake Marketplace) - Data exchange The question is asking about Snowflake Marketplace, where you can have listings The question is NOT asking about data shares or data exchanges. https://other-docs.snowflake.com/en/collaboration/consumer-becoming#set-up-required-privileges Get a listing for your account, then grant the IMPORTED PRIVILEGES privilege on the database created from the listing to a role on your account. This lets you access the data in the listing without having access to get any listing on the Snowflake Marketplace or privately. The answer should be C. IMPORT SHARE privileges to a role on your account allows you get access to listings and therefore, receive and request data from Snowflake Marketplace. Once you do get listing for your account, then you would need IMPORTED PRIVILEGES to access it.
Source: Adapted from community discussion — 0e504b5
Which Snowflake database object can be shared with other accounts?
Answer: C
from doc: https://docs.snowflake.com/en/user-guide/data-sharing-intro You can share the following Snowflake database objects: Tables External tables Secure views Secure materialized views Secure UDFs
Source: Adapted from community discussion — bibisa
Which identity providers are valid type values for federated authentication on the SAML_IDENTITY_PROVIDER parameter? (Choose two.)
Answer: BD
A Snowflake user wants to share data using my_share with account xy12345. Which command should be used?
Answer: C
ALTER SHARE [ IF EXISTS ] { ADD | REMOVE } ACCOUNTS = [ , , ... ] [ SHARE_RESTRICTIONS = { TRUE | FALSE } ] ALTER SHARE [ IF ALTER SHARE [ IF EXISTS ] SET { [ ACCOUNTS = [ , ... ] ]
Source: Adapted from community discussion — MultiCloudIronMan
What role is required to use Partner Connect?
Answer: A
Partner Connect is limited to account administrators (i.e. users with the ACCOUNTADMIN role) who have a verified email address in Snowflake: To use Partner Connect, you must switch to the ACCOUNTADMIN role or contact someone in your organization who has the role.
Source: Adapted from community discussion — bibisa
How can a Snowflake user configure a virtual warehouse to support over 100 users if their company has Enterprise Edition?
Answer: C
How is table data compressed in Snowflake?
Answer: A
COLUMNAR FORMAT When data is loaded into Snowflake, Snowflake reorganizes that data into its internal optimized, compressed, columnar format. Snowflake stores this optimized data in cloud storage. Snowflake manages all aspects of how this data is stored — the organization, file size, structure, compression, metadata, statistics, and other aspects of data storage are handled by Snowflake. The data objects stored by Snowflake are not directly visible nor accessible by customers; they are only accessible through SQL query operations run using Snowflake.
Source: Adapted from community discussion — bibisa
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 801. 1323 questions available.
Version 1.0.0. How we source questions