- (Topic 1)
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip outer_array file format option
What does the STRIP_OUTER_ARRAY file format do?

1. A. It removes the last element of the outer array.
2. B. It removes the outer array structure and loads the records into separate table rows,
3. C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
4. D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Correct Answer: B
The STRIP_OUTER_ARRAY file format option in Snowflake is used when loading JSON documents that are composed of a large array containing multiple records. When this option is enabled, it removes the outer array structure, which allows each record within the array to be loaded as a separate row in the table. This is particularly useful for efficiently loading JSON data that is structured as an array of records1.
References:
✑ Snowflake Documentation on JSON File Format
✑ [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 6)
What is the purpose of the use of the VALIDATE command?

1. A. To view any queries that encountered an error
2. B. To verify that a SELECT query will run without error
3. C. To prevent a put statement from running if an error occurs
4. D. To see all errors from a previously run COPY INTO <table> statement

Correct Answer: D
TheVALIDATEcommand in Snowflake is used to check for errors that occurred during the execution of aCOPY INTO <table>statement. This command helps users identify and
resolve data loading issues.
✑ Run the COPY INTO Statement:Execute theCOPY INTO <table>command to load data from a stage into a table.
COPY INTO my_table FROM @my_stage
FILE_FORMAT = (FORMAT_NAME = 'my_format');
✑ Validate the Load:Use theVALIDATEfunction to see if there were any errors during the data load.
SELECT *
FROM TABLE(VALIDATE(my_table, JOB_ID => 'my_copy_job_id'));
✑ Review Errors:TheVALIDATEfunction will return details about any errors that occurred, such as parsing errors or data type mismatches.
References:
✑ Snowflake Documentation: Validating Data Loads
✑ Snowflake Documentation: COPY INTO <table>

- (Topic 2)
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

1. A. There is no need to have a Snowflake account in the target region, a share will be created for each user.
2. B. The listing is replicated into all selected regions automatically, the data is not.
3. C. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
4. D. Shares attached to listings in remote regions can be viewed from any account in an organization.
5. E. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

Correct Answer: BC
When publishing a Snowflake Data Marketplace listing into a remote region, it??s important to note that while the listing is replicated into all selected regions automatically, the data itself is not.Therefore, the data must be replicated separately. Additionally, the user must have the ORGADMIN role in at least one account to manage the replication of accounts1.

- (Topic 1)
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

1. A. Each Snowflake account can be hosted in a different cloud vendor and region.
2. B. Each Snowflake account must be hosted in a different cloud vendor and region
3. C. All Snowflake accounts must be hosted in the same cloud vendor and region
4. D. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

Correct Answer: A
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

- (Topic 3)
What is the MAXIMUM size limit for a record of a VARIANT data type?

1. A. 8MB
2. B. 16MB
3. C. 32MB
4. D. 128MB

Correct Answer: B
The maximum size limit for a record of a VARIANT data type in Snowflake is 16MB. This allows for storing semi-structured data types like JSON, Avro, ORC, Parquet, or XML within a single VARIANT column. References: Based on general database knowledge as of 2021.