Exam Questions Flashcards

1
Q

External tables can be cloned. True or false?

A

False

External tables and internal named stages are never cloned.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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)
A

Discretionary Access Control (DAC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

User defined functions can NOT be executed in the context of another statement. For example, in a SELECT statement. True or false?

A

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;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A virtual warehouse is a named abstraction for one or more compute nodes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How many databases can a data provider add to a SHARE object? Choose one correct value.

A

1

Only one database can be added per share.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which type of view bypasses some query optimizations to improve data security? Choose one correct value.

  • Standard
  • Recursive
  • Protected
  • Materialized
  • Secure
A

Secure

This may result is poorer query performance than a standard view but makes the view more secure.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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.
A

Specifies if a virtual warehouse should be suspended immediately after its created.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

The COPY INTO <table> statement does NOT require a virtual warehouse to run. True or false?

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

The ACCOUNTADMIN can perform the same functions as the SECURITYADMIN, SYSADMIN & ORGAMIN. True or false?

A

False

ORGADMIN is for managing operation at an organization level and is not possible with the ACCOUNTADMIN role.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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.
A
  • No hardware to manage.
  • Pay for what you use pricing plan.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

In which state is a Virtual Warehouse billable? Choose one correct value.

  • INITIATED
  • RESUME
  • SUSPENDED
  • STARTED
A

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 well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How many accounts can a data consumer share a shared database with? Choose one correct value.

A

0

Data consumers cannot re-share shared database objects.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which table type does have the fail-safe feature? Choose one correct value.

  • Permanent
  • Temporary
  • Transient
  • External
A

Permanent

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Every securable object is owned by a single role. True or false?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

If enabled, periodic rekeying happens every ___ months. Choose one correct value.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which result from the APPROXIMATE_SIMILARITY estimation function would indicate two sets of rows overlap significantly but are not identical? Choose one correct value.

A

0.8

0 indicates no overlap and 1 indicates the two sets are identical. 0.8 would indicate two sets are very similar.

17
Q

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.

A
  • When multiple users want to load data into multiple tables.
  • When a single user wants to load data into multiple tables.
18
Q

All objects are individually securable. True or false?

A

True

19
Q

How many days is the query history maintained in the history tab of the classic UI? Choose one correct value.

A

14

20
Q

What is the recommended compressed file size when loading data into Snowflake? Choose one correct value.

A

100-250mb

21
Q

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

A
  • system$clustering_information
22
Q

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.

A
  • 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.
23
Q

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

A

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.

24
Q

You can execute commands as the ACCOUNTADMIN using the SnowSQL CLI tool. True or False?

A

True

You can execute commands using the SnowSQL CLI tool with any role you have the privileges to assume.

25
Q

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
  • 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

26
Q

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.

A
  • 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.
27
Q

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.

A
  • Load the file if errors are found