Question 491 · 1323 in bank
Using variables in Snowflake is denoted by using which SQL character?
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
Using variables in Snowflake is denoted by using which SQL character?
Answer: C
Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)
Answer: CD
A,C - You need Grant Usage before Grant Select. Grant Select will give you access to all current and future tables (without needing to specify future). Granting future is only when you need to restrict access to current tables.).
Source: Adapted from community discussion — Jtravismiller
How can a user change which columns are referenced in a view?
Answer: C
Currently the only supported operations are: Renaming a view. Converting to (or reverting from) a secure view. Adding, overwriting, removing a comment for a view. Note that you cannot use this command to change the definition for a view. To change the view definition, you must drop the view and then recreate it. https://docs.snowflake.com/en/sql-reference/sql/alter-view.html#alter-view
Source: Adapted from community discussion — SV1122
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
Answer: D
C. Enterprise Edition. The Enterprise Edition of Snowflake offers advanced security features and capabilities that are designed to meet the stringent requirements of regulatory compliance. It includes features such as role-based access control (RBAC), encryption at rest and in transit, audit logging, fine-grained access controls, and data masking. These features help ensure the security and compliance of sensitive and protected data stored in Snowflake. While other editions of Snowflake, such as Standard and Premier, also provide security features, the Enterprise Edition is specifically tailored for organizations with higher compliance and security requirements. It offers additional features and capabilities that address the needs of regulated industries and data protection standards. Therefore, customers planning on storing protected information in Snowflake for regulatory compliance should consider the Enterprise Edition as a suitable option.
Source: Adapted from community discussion — shubtred
Which statement describes pruning?
Answer: A
Which SQL command can be used to see the CREATE definition of a masking policy?
Answer: C
This is the result of B https://docs.snowflake.com/en/sql-reference/sql/desc-masking-policy.html#example So B can't be the answer And this is the result of C https://docs.snowflake.com/en/sql-reference/functions/get_ddl.html#examples So C is the answer
Source: Adapted from community discussion — AS314
Which of the following is the Snowflake Account_Usage.Metering_History view used for?
Answer: A
The METERING_HISTORY view in the ACCOUNT_USAGE schema can be used to return the hourly credit usage for an account within the last 365 days (1 year). https://docs.snowflake.com/en/sql-reference/account-usage/metering_history.html
Source: Adapted from community discussion — SV1122
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Answer: A
Which of the following Snowflake objects can be shared using a secure share? (Choose two.)
Answer: DE
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
Answer: D
A clustering key is a subset of columns in a table (or expressions on a table) that are explicitly designated to co-locate the data in the table in the same micro-partitions. This is useful for very large tables where the ordering was not ideal (at the time the data was inserted/loaded) or extensive DML has caused the table’s natural clustering to degrade. https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html#benefits-of-defining-clustering-keys-for-very-large-tables
Source: Adapted from community discussion — SV1122
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 491. 1323 questions available.
Version 1.0.0. How we source questions