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
When can a Virtual Warehouse start running queries?
Answer: C
its C as the warehouse start executing the query after the provisioning. there is not specific time slot and no provision when an accountadmin specify a time window as long as the warehouse is running and the user have right privilege
Source: Adapted from community discussion — Sumannc
What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
Answer: D
What aspect of an executed query is represented by the remote disk I/O statistic of the Query Profile in Snowflake?
Answer: D
What action can a user take to address query concurrency issues?
Answer: C
What does the client redirect feature in Snowflake enable?
Answer: B
Which Snowflake feature can be used to find sensitive data in a table or column?
Answer: B
Classification will let you find sensitive data. Masking policies are used to mask sensitive data after you found them. Dynamic Data Masking is a Column-level Security feature that uses masking policies to selectively mask plain-text data in table and view columns at query time https://docs.snowflake.com/en/user-guide/security-column-ddm-intro https://docs.snowflake.com/en/user-guide/governance-classify-concepts
Source: Adapted from community discussion — 0e504b5
Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?
Answer: A
At Snowflake, data governance is all about providing our customers native capabilities to easily and efficiently govern data at scale. Previously, we launched capabilities such as Object Tagging, Dynamic Data Masking, Row Access Policies, and Access History to help keep track of sensitive data by tagging it, assigning masking policies to protect columns with sensitive data from unauthorized access, and audit the access of sensitive columns using Access History. https://www.snowflake.com/blog/protect-sensitive-data-tag-based-masking/
Source: Adapted from community discussion — nexerSnow
Snowflake’s hierarchical key mode includes which keys? (Choose two.)
Answer: AC
Answer is A & C Snowflake’s hierarchical key model consists of four levels of keys: The root key Account master keys Table master keys File keys
Source: Adapted from community discussion — happykeieiekek
What can the Snowflake SCIM API be used to manage? (Choose two.)
Answer: DE
Snowflake is compatible with SCIM2.0, SCIM is an open standard for automating user provisioning. The SCIM API allows us to programmatically manage roles and users within the Snowflake platform, making it easier to automate identity and access management tasks.
Source: Adapted from community discussion — JG1984
Which privilege is required to use the search optimization service in Snowflake?
Answer: C
C correct https://docs.snowflake.com/en/user-guide/search-optimization-service What Access Control Privileges Are Needed For the Search Optimization Service?¶ To add, configure, or remove search optimization for a table, you must have the following privileges: You must have OWNERSHIP privilege on the table. You must have ADD SEARCH OPTIMIZATION privilege on the schema that contains the table. GRANT ADD SEARCH OPTIMIZATION ON SCHEMA TO ROLE
Source: Adapted from community discussion — ukpino
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 931. 1323 questions available.
Version 1.0.0. How we source questions