Which command can be used to list all the file formats for which a user has access privileges?
Correct Answer: D
The command to list all the file formats for which a user has access privileges in Snowflake isSHOW FILE FORMATS. This command provides a list of all file formats defined in the user ' s current session or specified database/schema, along with details such as the name, type, and creation time of each file format. It is a valuable tool for users to understand and manage the file formats available for data loading and unloading operations. References: Snowflake Documentation: SHOW FILE FORMATS
Question 272
What information does the Query Profile provide?
Correct Answer: B
The Query Profile in Snowflake provides a graphical representation and statistics for each component of the query ' s execution plan. This includes details such as the execution time, the number of rows processed, and the amount of data scanned for each operation within the query. The Query Profile is a crucial tool for understanding and optimizing the performance of queries, as it helps identify potential bottlenecks and inefficiencies. References: Snowflake Documentation: Understanding the Query Profile
Question 273
What is the primary purpose of a directory table in Snowflake?
Correct Answer: D
A directory table in Snowflake is used to store file-level metadata about the data files in a stage. It is conceptually similar to an external table and provides information such as file size, last modified timestamp, and file URL. References: [COF-C02] SnowPro Core Certification Exam Study Guide
Question 274
Which property or parameter can be used to temporarily disable Multi-Factor Authentication (MFA) for a Snowflake user?
Correct Answer: C
Question 275
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. Reference: Snowflake Documentation on Snowsight (https://docs.snowflake.com/en/user-guide/ui-snowsight. html)
