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