Snowflake SnowPro Core Practice Test - Questions Answers, Page 19
List of questions
Related questions
Question 181

Which of the following accurately describes shares?
Explanation:
Shares in Snowflake are named objects that encapsulate all the information required to share databases, schemas, tables, secure views, and secure UDFs.These objects can be added to a share by granting privileges on them to the share via a database role
Question 182

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)
Explanation:
Best practices for using the ACCOUNTADMIN role include ensuring that all users with this role use Multi-factor Authentication (MFA) for added security.Additionally, it is recommended to assign the ACCOUNTADMIN role to at least two users to avoid delays in case of password recovery issues, but to as few users as possible to maintain strict control over account-level operations4.
Question 183

What is the minimum Snowflake edition required for row level security?
Explanation:
Row level security in Snowflake is available starting with the Enterprise edition.This feature allows for the creation of row access policies that can control access to data at the row level within tables and views
Question 184

The is the minimum Fail-safe retention time period for transient tables?
Explanation:
Transient tables in Snowflake have a minimum Fail-safe retention time period of 0 days.This means that once the Time Travel retention period ends, there is no additional Fail-safe period for transient tables
Question 185

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
Explanation:
When leveraging third-party data from the Snowflake Data Marketplace, the data is live, ready-to-query, and can be personalized.Additionally, the data is available without the need for copying or moving it to an individual Snowflake account, allowing for seamless integration with existing data
Question 186

What impacts the credit consumption of maintaining a materialized view? (Choose two.)
Explanation:
The credit consumption for maintaining a materialized view is impacted by how often the base table changes and whether the materialized view has a cluster key defined (D). Changes to the base table can trigger a refresh of the materialized view, consuming credits. Additionally, having a cluster key defined can optimize the performance and credit usage during the materialized view's maintenance.Reference:SnowPro Core Certification materialized view credit consumption
Question 187

What COPY INTO SQL command should be used to unload data into multiple files?
Explanation:
The COPY INTO SQL command with the optionSINGLE=FALSEis used to unload data into multiple files. This option allows the data to be split into multiple files during the unload process.Reference:SnowPro Core Certification COPY INTO SQL command unload multiple files
Question 188

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
Explanation:
When cloning a database containing stored procedures and regular views with fully qualified table references, the cloned views and stored procedures will reference the cloned tables in the cloned database (A). This ensures that the cloned database is a self-contained copy of the original, with all references pointing to objects within the same cloned database.Reference:SnowPro Core Certification cloning database stored procedures views
Question 189

When loading data into Snowflake, how should the data be organized?
Explanation:
When loading data into Snowflake, it is recommended to organize the data into single files with 100-250 MB of compressed data per file. This size range is optimal for parallel processing and can help in achieving better performance during data loading operations.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide
Question 190

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)
Explanation:
The UNDROP command in Snowflake can be used to directly restore Views and Tables. These objects, when dropped, are moved to a 'Recycle Bin' where they can be restored within a time limit before they are permanently deleted.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide
Question