Question 1221 · 1323 in bank
How does Snowflake define its approach to Discretionary Access Control (DAC)?
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
How does Snowflake define its approach to Discretionary Access Control (DAC)?
Answer: C
A single cluster virtual warehouse has no free resources. What will happen to new queries that are run against this warehouse?
Answer: C
Which command is used to take away staged files from a Snowflake stage after a successful data ingestion?
Answer: C
The Snowflake VARIANT data type imposes a 16 MB size limit on what?
Answer: A
Use of what parameter will allow files to be loaded even if the file metadata has expired?
Answer: D
Which Snowflake feature records changes made to a table so actions can be taken using that change data capture?
Answer: C
Which system-defined, read-only view displays information on column lineage that specifies how data flows from source to target in a SQL write operation?
Answer: A
Who can create network policies within Snowflake? (Choose two.)
Answer: CD
Who can grant object privileges in a regular schema?
Answer: A
https://docs.snowflake.com/en/user-guide/security-access-control-configure#label-managed-access-schemas Managed access schemas improve security by locking down privilege management on objects. In regular (i.e. non-managed) schemas, object owners (i.e. a role with the OWNERSHIP privilege on an object) can grant access on their objects to other roles, with the option to further grant those roles the ability to manage object grants. 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 — CCC1234
Which command can be used to list all the file formats for which a user has access privileges?
Answer: D
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1221. 1323 questions available.
Version 1.0.0. How we source questions