True or False: It is possible for a user to run a query against the query result cache without requiring
an active Warehouse.
A
Explanation:
Query result cache is all about fetching the data from cloud services layer and saving the cost by not
running the virtual warehouse.
True or False: Fail-safe can be disabled within a Snowflake account.
B
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/data-failsafe.html
Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a
system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature
cannot be enabled or disabled from the user end .
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
AC
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/data-sharing-provider.html
True or False: When you create a custom role, it is a best practice to immediately grant that role to
ACCOUNTADMIN.
B
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
True or False: A Virtual Warehouse can be resized while suspended.
A
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-
suspended-warehouse
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
B
Explanation:
By default, COPY INTO location statements separate table data into a set of output files to take
advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy
option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The
maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure
stages. To unload data to a single output file (at the potential cost of decreased performance), specify
the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the
path.
True or False: Reader Accounts are able to extract data from shared data objects for use outside of
Snowflake.
B
Explanation:
A reader account can only consume data from the provider account that created it.
What is the default File Format used in the COPY command if one is not specified?
A
Explanation:
Reference:
https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html
The Information Schema and Account Usage Share provide storage information for which of the
following objects? (Choose three.)
ABC
How would you determine the size of the virtual warehouse used for a task?
C
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small
Warehouse.
A
Explanation:
You can experiment the same with snowflake UI.
The fail-safe retention period is how many days?
B
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/data-failsafe.html
True or False: Data Providers can share data with only the Data Consumer.
B
True or False: During data unloading, only JSON and CSV files can be compressed.
B
Explanation:
Reference:
https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
B
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html