Exam Questions Flashcards
External tables can be cloned. True or false?
False
External tables and internal named stages are never cloned.
Snowflake uses the following access control schemes: role based access control (RBAC) and _________.
- Imperative Access Control (IAC)
- Compulsory Access Control (CAC)
- Mandatory Access Control (MAC)
- Discretionary Access Control (DAC)
Discretionary Access Control (DAC)
User defined functions can NOT be executed in the context of another statement. For example, in a SELECT statement. True or false?
True
This command shows how we can execute a UDF in the context of another SQL statement: SELECT AREA_OF_CIRCLE(col1) FROM MY_TABLE;
Which sentence most accurately describes what a Virtual Warehouse is? Choose one correct value.
- A virtual warehouse is a way of logically grouping schemas.
- A virtual warehouse is a cluster of compute nodes the user sets up and maintains.
- A virtual warehouse is another name for the persistent storage layer.
- A virtual warehouse is a named abstraction for one or more compute nodes.
A virtual warehouse is a named abstraction for one or more compute nodes.
How many databases can a data provider add to a SHARE object? Choose one correct value.
1
Only one database can be added per share.
Which type of view bypasses some query optimizations to improve data security? Choose one correct value.
- Standard
- Recursive
- Protected
- Materialized
- Secure
Secure
This may result is poorer query performance than a standard view but makes the view more secure.
What is the function of the INITIALLY_SUSPENDED property of a Virtual Warehouse? Choose one correct value.
- Specifies the max threshold of queries after which point a virtual warehouse will be automatically suspended.
- Specifies whether to automatically resume a warehouse when a SQL statement is submitted to it.
- Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
- Specifies if a virtual warehouse should be suspended immediately after its created.
Specifies if a virtual warehouse should be suspended immediately after its created.
The COPY INTO <table> statement does NOT require a virtual warehouse to run. True or false?
False
The ACCOUNTADMIN can perform the same functions as the SECURITYADMIN, SYSADMIN & ORGAMIN. True or false?
False
ORGADMIN is for managing operation at an organization level and is not possible with the ACCOUNTADMIN role.
What attributes make Snowflake a SaaS solution? Choose two correct values.
- The ability to SSH into underlying compute instances.
- Snowflake can be installed on a local machine.
- The user must upgrade software.
- No hardware to manage.
- Pay for what you use pricing plan.
- No hardware to manage.
- Pay for what you use pricing plan.
In which state is a Virtual Warehouse billable? Choose one correct value.
- INITIATED
- RESUME
- SUSPENDED
- STARTED
STARTED
When a Virtual Warehouse is in the ‘STARTED’ state it will accrue Snowflake credits regardless of whether queries are being executed using it or not.
How many accounts can a data consumer share a shared database with? Choose one correct value.
0
Data consumers cannot re-share shared database objects.
Which table type does have the fail-safe feature? Choose one correct value.
- Permanent
- Temporary
- Transient
- External
Permanent
Every securable object is owned by a single role. True or false?
True
If enabled, periodic rekeying happens every ___ months. Choose one correct value.
12
“If periodic rekeying is enabled, then when the retired encryption key for a table is older than one year, Snowflake automatically creates a new encryption key and re-encrypts all data previously protected by the retired key using the new key. The new key is used to decrypt the table data going forward.” - https://docs.snowflake.com/en/user-guide/security-encryption-manage.html#periodic-rekeying
Which result from the APPROXIMATE_SIMILARITY estimation function would indicate two sets of rows overlap significantly but are not identical? Choose one correct value.
0.8
0 indicates no overlap and 1 indicates the two sets are identical. 0.8 would indicate two sets are very similar.
When is a table stage not appropriate to use for data loading? Select all that apply.
- When multiple users want to load data into a single table.
- When multiple users want to load data into multiple tables.
- When a single user wants to load data into multiple tables.
- When a single user wants to load data into a single table.
- When multiple users want to load data into multiple tables.
- When a single user wants to load data into multiple tables.
All objects are individually securable. True or false?
True
How many days is the query history maintained in the history tab of the classic UI? Choose one correct value.
14
What is the recommended compressed file size when loading data into Snowflake? Choose one correct value.
100-250mb
Which system function is called to retrieve clustering metadata for a column or columns? Choose one correct value.
- system$natural_clustering_information
- system$clustering_information
- system$allowlist
- system$clustering_metadata
- system$clustering_information
Snowflake provides a suite of powerful features that ensure the highest possible levels of data security. Which statements are correct regarding Snowflake? Select all that apply.
- Snowflake makes use of key-pair authentication for programmatic access.
-Snowflake support discretionary access control (DCA)
- Snowflake uses a hierarchical key model which is rooted in a hardware key.
- Tri-secure makes use of a composite key made up of a customer managed key and a Snowflake managed key.
- Snowflake makes use of key-pair authentication for programmatic access.
-Snowflake support discretionary access control (DCA) - Snowflake uses a hierarchical key model which is rooted in a hardware key.
- Tri-secure makes use of a composite key made up of a customer managed key and a Snowflake managed key.
What level of cardinality is it recommended a column have when selected in a query that makes use of a GROUP BY? Choose one correct value.
- Low cardinality
- High cardinality
- No cardinality
- Medium cardinality
Low cardinality
Having many distinct values can be a very memory-intensive operation, a lot of data will be spilled to disk and there will be high network usage.
You can execute commands as the ACCOUNTADMIN using the SnowSQL CLI tool. True or False?
True
You can execute commands using the SnowSQL CLI tool with any role you have the privileges to assume.
What is the definition of Tri-secret secure? Choose one correct value.
- The use of a hardware module to store a customer managed key.
- Rekeying of data every 14 days.
- The use of three passwords to log-in.
- A composite encryption key to encrypt data files made up a user provider key and a Snowflake key.
- A composite encryption key to encrypt data files made up a user provider key and a Snowflake key.
More information - https://docs.snowflake.com/en/user-guide/security-encryption-manage.html#tri-secret-secure
To reuse the results cache which of the following requirements must be met? Select all that apply.
- The new query exactly matches the cached query.
- The role new query must have the necessary access privileges for all the tables used in the cached query when executing a SELECT.
- The same user is used as in the cached query.
- The underlying table data has changed since the cached query.
- The new query exactly matches the cached query.
- The role new query must have the necessary access privileges for all the tables used in the cached query when executing a SELECT.
What is the behavior of the COPY INTO <table> command when the ON_ERROR option is set to CONTINUTE? Choose one correct value.
- Load the file if errors are found
- Skip file when error is found
- Abort load operation
- Skip a file when a certain number of errors is found.
- Load the file if errors are found
