What are benefits of using reader accounts when sharing data in Snowflake? (Select TWO)
Correct Answer: C,D
Reader accounts are created by data providers for consumers who do not have their own Snowflake accounts. This allows providers to share data without requiring the consumer to create or pay for their own Snowflake account. While a consumer can access multiple shares via a single reader account , administrative functions (like resource monitors) are managed by the provider. Reference: Snowflake Docs: Data Sharing: Reader Accounts
Question 167
Which command can be used to stage local files from which Snowflake interface?
Correct Answer: A
SnowSQL is the command-line client for Snowflake that allows users to execute SQL queries and perform all DDL and DML operations, including staging files for bulk data loading. It is specifically designed for scripting and automating tasks. References: SnowPro Core Certification Exam Study Guide Snowflake Documentation on SnowSQL https://docs.snowflake.com/en/user-guide/snowsql-use.html
Question 168
Which command is used in Snowflake to manually refresh a directory table?
Correct Answer: B
The correct answer is B. ALTER STAGE . Directory tables are associated with stages. To manually refresh the metadata in a directory table, the stage is refreshed using the ALTER STAGE ... REFRESH command. Why B is correct: A directory table stores file-level metadata for files in a stage. Since the directory table is tied to the stage, the manual refresh operation is performed through the stage. Example: ALTER STAGE my_stage REFRESH; This refreshes the directory table metadata for the stage. Why the other options are incorrect: A). TRUNCATE STAGE is not the command used to refresh directory table metadata. C). ALTER TABLE is used to modify table properties, not refresh a directory table associated with a stage. D). ALTER VIEW is used to modify views, not directory tables. Official Snowflake documentation reference: Snowflake documentation explains that directory table metadata can be refreshed manually using ALTER STAGE ... REFRESH. Reference: Snowflake Documentation - Directory tables; Snowflake Documentation - ALTER STAGE; SnowPro Core Study Guide - Data Loading and Unloading. ==
Question 169
When does a materialized view get suspended in Snowflake?
Correct Answer: B
A materialized view in Snowflake gets suspended when structural changes that could impact the view's integrity are made to the base table, such as B. When a column is dropped from the base table. Dropping a column from the base table on which a materialized view is defined can invalidate the view's data, as the view might rely on the column that is being removed. To maintain data consistency and prevent the materialized view from serving stale or incorrect data, Snowflake automatically suspends the materialized view. Upon suspension, the materialized view does not reflect changes to the base table until it is refreshed or re-created. This ensures that only accurate and current data is presented to users querying the materialized view. References: Snowflake Documentation on Materialized Views: Materialized Views
Question 170
Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?
Correct Answer: A
Snowsight, Snowflake's user interface for exploring, analyzing, and visualizing data, supports a variety of chart types for creating dashboards and visualizations. One of the supported chart types in Snowsight is the Area Chart (A). Area charts are useful for representing quantities over time and can be used to highlight volume change and rate of change, as well as to compare multiple quantities. While Snowsight supports many types of visualizations to help users analyze their data effectively, including line charts, bar charts, and scatter plots, it's important to select the specific reference documentation or release notes for the most current list of supported chart types, as Snowflake continues to enhance and update Snowsight's capabilities. As of the last update, Box plots (B), Heat grids (C), and Pie charts (D) are types of visualizations that may be supported in various analytics and visualization tools, but for the specific context of Snowsight's currently confirmed features, Area charts are a verified option for users to visualize their data.
