Question 511 · 1323 in bank
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
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
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
Answer: D
In which use case does Snowflake apply egress charges?
Answer: C
Snowflake charges a per-byte fee for data egress when users transfer data from a Snowflake account into a different region on the same cloud platform or into a completely different cloud platform. Data transfers within the same region are free. https://docs.snowflake.com/en/user-guide/cost-understanding-data-transfer.html
Source: Adapted from community discussion — BigDataBB
Which of the following compute resources or features are managed by Snowflake? (Choose two.)
Answer: CD
- Snowpipe uses Snowflake-supplied compute resources. - Automatic Clustering is the Snowflake service that seamlessly and continually manages all reclustering, as needed, of clustered tables.
Source: Adapted from community discussion — BigDataBB
A materialized view should be created when which of the following occurs? (Choose two.)
Answer: BE
"The query consumes a lot of resources. Typically, this means that the query consumes a lot of processing time or credits, but it could also mean that the query consumes a lot of storage space for intermediate results." This is why it is not D
Source: Adapted from community discussion — cgapperi
What privilege should a user be granted to change permissions for new objects in a managed access schema?
Answer: C
With managed access schemas, object owners lose the ability to make grant decisions. Only the schema owner (i.e. the role with the OWNERSHIP privilege on the schema) or a role with the MANAGE GRANTS privilege can grant privileges on objects in the schema, including future grants, centralizing privilege management.
Source: Adapted from community discussion — ravuri_rk
True or False: Snowpipe via REST API can only reference External Stages as source.
Answer: B
Statement is False. Answer B is correct. Snowpipe via rest API can refer both external as well as internal stages. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest-overview.html
Source: Adapted from community discussion — Tapsinha
What happens when a Data Provider revokes privileges to a share on an object in their source database?
Answer: A
Answer correct Revokes access privileges for databases and other supported database objects (schemas, tables, and views) from a share. Revoking privileges on these objects effectively removes the objects from the share, disabling access to the objects granted via the database role in all consumer accounts that have created a database from the share.
Source: Adapted from community discussion — AravindhTN
Which command can be used to load data into an internal stage?
Answer: D
I think it's ambiguous question B or D It depends on the data source COPY unloads the data from table into stage PUT uploads a file from local file system into a stage https://docs.snowflake.com/en/user-guide/data-unload-overview https://docs.snowflake.com/en/sql-reference/sql/put
Source: Adapted from community discussion — 0e504b5
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
Answer: A
Which stage type can be altered and dropped?
Answer: B
The answer is correct as we cannot drop the stage associated with a table or user; only named stages (internal or external) can be dropped.
Source: Adapted from community discussion — halol
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 511. 1323 questions available.
Version 1.0.0. How we source questions