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.
Question 532
Which parameter prevents streams on tables from becoming stale?
Correct Answer: A
The parameter that prevents streams on tables from becoming stale is MAXDATAEXTENSIONTIMEINDAYS. This parameter specifies the maximum number of days for whichSnowflake can extend the data retention period for the table to prevent streams on the table from becoming stale4.
Question 533
How can a 5 GB table be downloaded into a single file MOST efficiently?
Correct Answer: C
To download a 5 GB table into a single file most efficiently in Snowflake, you should set the SINGLE parameter to TRUE. This parameter ensures that the COPY INTO command outputs the result into a single file, regardless of the file size. This approach is more efficient than relying on the default MAX_FILE_SIZE setting, which would split the output into multiple files. Reference: Snowflake Documentation: COPY INTO <location>
Question 534
Which command will create an ARRAY output from inputs 'a' and 'b'?
Correct Answer: D
Question 535
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
