- (Topic 3)
How many resource monitors can be assigned at the account level?

1. A. 1
2. B. 2
3. C. 3
4. D. 4

Correct Answer: A
Snowflake allows for only one resource monitor to be assigned at the account level. This monitor oversees the credit usage of all the warehouses in the account. References: Snowflake Documentation

- (Topic 6)
What causes objects in a data share to become unavailable to a consumer account?

1. A. The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.
2. B. The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every 24 hours.
3. C. The objects in the data share are being deleted and the grant pattern is not re-applied systematically.
4. D. The consumer account acquires the data share through a private data exchange.

Correct Answer: C
Objects in a data share become unavailable to a consumer account if the objects in the data share are deleted or if the permissions on these objects are altered without re- applying the grant permissions systematically. This is because the sharing mechanism in Snowflake relies on explicit grants of permissions on specific objects (like tables, views, or secure views) to the share. If these objects are deleted or if their permissions change without updating the share accordingly, consumers can lose access. TheDATA_RETENTION_TIME_IN_DAYSparameter does not directly affect the availability of shared objects, as it controls how long Snowflake retains historical data for time travel and does not impact data sharing permissions.
Running theGRANT IMPORTED PRIVILEGEScommand in the consumer account is not related to the availability of shared objects; this command is used to grant privileges on imported objects within the consumer's account and is not a routine maintenance command that would need to be run regularly.
Acquiring a data share through a private data exchange does not inherently make objects unavailable; issues would only arise if there were problems with the share configuration or if the shared objects were deleted or had their permissions altered without re-granting access to the share.
Reference: Snowflake Documentation on Managing Access to Shared Data
(https://docs.snowflake.com/en/user-guide/data-sharing-consuming.html#managing-access-to-shared-data)

- (Topic 6)
What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO

1. A. It flattens multiple arrays into a single array.
2. B. It removes the outer array structure and loads separate rows of data
3. C. It transforms a pivoted table into an array.
4. D. It tokenizes each data string using the defined delimiters.

Correct Answer: B
The STRIP_OUTER_ARRAY parameter in the COPY INTO <table> command is used when loading data from a JSON file into a table. This parameter removes the outer array structure from the JSON data and loads separate rows of data into the table.
✑ Understanding the STRIP_OUTER_ARRAY Parameter:
✑ How It Works:
✑ Example Usage: FROM @my_stage/file.json
FILE_FORMAT = (TYPE = 'JSON' STRIP_OUTER_ARRAY = TRUE);
✑ uk.co.certification.simulator.questionpool.PList@6ef05806
✑ Benefits:
References:
✑ Snowflake Documentation: COPY INTO <table>
✑ Snowflake Documentation: JSON File Format Options