Snowflake SnowPro Core Practice Test - Questions Answers, Page 7
Related questions
Question 61

Which data types does Snowflake support when querying semi-structured data? (Select TWO)
Explanation:
Snowflake supports querying semi-structured data using specific data types that are capable of handling the flexibility and structure of such data. The data types supported for this purpose are:
A) VARIANT: This is a universal data type that can store values of any other type, including structured and semi-structured types.It is particularly useful for handling JSON, Avro, ORC, Parquet, and XML data formats1.
B) ARRAY: An array is a list of elements that can be of any data type, including VARIANT, and is used to handle semi-structured data that is naturally represented as a list1.
These data types are part of Snowflake's built-in support for semi-structured data, allowing for the storage, querying, and analysis of data that does not fit into the traditional row-column format.
Snowflake Documentation on Semi-Structured Data
[COF-C02] SnowPro Core Certification Exam Study Guide
Question 62

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
Explanation:
Snowflake's architecture allows for flexibility in account hosting across different cloud vendors and regions. This means that within a single organization, different Snowflake accounts can be set up in various cloud environments, such as AWS, Azure, or GCP, and in different geographical regions. This allows organizations to leverage the global infrastructure of multiple cloud providers and optimize their data storage and computing needs based on regional requirements, data sovereignty laws, and other considerations.
https://docs.snowflake.com/en/user-guide/intro-regions.html
Question 63

Where would a Snowflake user find information about query activity from 90 days ago?
Explanation:
To find information about query activity from 90 days ago, a Snowflake user should use theaccount_usage.query_history_archiveview. This view is designed to provide access to historical query data beyond the default 14-day retention period found in the standardquery_historyview. It allows users to analyze and audit past query activities for up to 365 days after the date of execution, which includes the 90-day period mentioned.
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Account Usage Schema1
Question 64

Which Snowflake technique can be used to improve the performance of a query?
Explanation:
Clustering is a technique used in Snowflake to improve the performance of queries. It involves organizing the data in a table into micro-partitions based on the values of one or more columns. This organization allows Snowflake to efficiently prune non-relevant micro-partitions during a query, which reduces the amount of data scanned and improves query performance.
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Clustering
Question 65

User-level network policies can be created by which of the following roles? (Select TWO).
Explanation:
User-level network policies in Snowflake can be created by roles with the necessary privileges to manage security and account settings. The ACCOUNTADMIN role has the highest level of privileges across the account, including the ability to manage network policies. The SECURITYADMIN role is specifically responsible for managing security objects within Snowflake, which includes the creation and management of network policies.
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Network Policies1
Section 1.3 - SnowPro Core Certification Study Guide
Question 66

Which command can be used to load data into an internal stage?
Explanation:
The PUT command is used to load data into an internal stage in Snowflake. This command uploads data files from a local file system to a named internal stage, making the data available for subsequent loading into a Snowflake table using the COPY INTO command.
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Data Loading
Question 67

What happens when an external or an internal stage is dropped? (Select TWO).
Explanation:
When an external stage is dropped in Snowflake, the reference to the external storage location is removed, but the actual files within the external storage (like Amazon S3, Google Cloud Storage, or Microsoft Azure) are not deleted. This means that the data remains intact in the external storage location, and only the stage object in Snowflake is removed.
On the other hand, when an internal stage is dropped, any files that were uploaded to the stage are deleted along with the stage itself. These files are not recoverable once the internal stage is dropped, as they are permanently removed from Snowflake's storage.
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Stages
Question 68

How long is Snowpipe data load history retained?
Explanation:
Snowpipe data load history is retained for 64 days. This retention period allows users to review and audit the data load operations performed by Snowpipe over a significant period of time, which can be crucial for troubleshooting and ensuring data integrity.
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Snowpipe1
Question 69

In which use cases does Snowflake apply egress charges?
Explanation:
Snowflake applies egress charges in the case of database replication when data is transferred out of a Snowflake region to another region or cloud provider. This is because the data transfer incurs costs associated with moving data across different networks. Egress charges are not applied for data sharing within the same region, query result retrieval, or loading data into Snowflake, as these actions do not involve data transfer across regions.
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Data Replication and Egress Charges1
Question 70

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
Explanation:
To evaluate the details of dynamic data masking, thePOLICY_REFERENCESandACCESS_HISTORYviews in theaccount_usageschema are used. ThePOLICY_REFERENCESview provides information about the objects to which a masking policy is applied, and theACCESS_HISTORYview contains details about access to the masked data, which can be used to audit and verify the application of dynamic data masking policies.
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Dynamic Data Masking1
Question