Snowflake Test-3

Welcome to your Snowflake Test-3

Name

Phone

Q1. Snowflake Storage layer is a Cloud Storage layer. It depends on which cloud provider you are using. Select the current available cloud providers.

Select 3 option(s):

Azure Cloud

AWS Cloud

GCP

IBM Cloud

Oracle Cloud

Q2. Which view does behave like a table and get auto-refreshed?

Select 1 option(s):

None

Secured

Standard

Materialized

Q3. The BI group is complaining about their queries taking too long to run. Checking the virtual warehouse information shows the queued time is pretty high. What is the best way to fix this issue?

Select 1 option(s):

Increase the virtual warehouse MAX_CLUSTER_COUNT property

Provide a virtual warehouse for every user in the group

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS parameter to a low value to cancel those queries if they get in the queue

Determine which users have the high priority queries and set the other users

Increase the virtual warehouse MAXCONCURRENCY_LEVEL parameter

Increase the size of the virtual warehouse

Q4. Which is the correct syntax to disable fail safe on a table?

Select 1 option(s):

By default, fail safe is disabled on a table.

Fail safe can not be disabled on a table.

ALTER TABLE SET FAILSAFE_DAYS = 0;

ALTER TABLE DROP FAILSAFE;

ALTER TABLE SET ENABLE_FAILSAFE = FALSE;

Q5. What is the best use of Multi-Cluster Warehouse?

Select 1 option(s):

Best utilized for scaling resources to improve performance of slow-running queries.

Best utilized for scaling resources to improve concurrency for users/queries.

Q6. SNOWPIPE (REST) method only works with Internal Stages. (TRUE/FALSE)

Select 1 option(s):

TRUE

FALSE

Q7. What is the name of the Snowflake-produced Command Line Interface tool?

Select 1 option(s):

SnowCLI

SnowSQL

Snow Command

SnowConnect

Q8. Which of the following are Snowflake view types? (Select 3)

Select 3 option(s):

Transient

Secure

Permanent

Materialized

Standard

Q9. Federated Authentication is supported by:

Select 4 option(s):

VPS

Enterprise Edition

Business Critical

Standard Edition

Unattempted

Q10. What are the features of Column-level security? (Select 2)

Select 2 option(s):

Internal Tokenization

Dynamic Data Masking

Column Masking

External Tokenization

Q11. You create a Sequence in Snowflake with an initial value of 3 and an interval of 2. Which series of numbers do you expect to see?

Select 1 option(s):

3,6,9,12,15

3,4,5,6,7

3,5,7,9,11

2,5,8,11,14

Q12. Scaling Out is an automated process (e.g., Min clusters to max clusters)

Select 1 option(s):

TRUE

FALSE

Q13. Which layer is responsible for Data Security and Authentication?

Select 1 option(s):

Cloud Agnostic Layer

Cloud Services

Compute Layer

Storage Layer

Q14. STRIP_NULL_VALUE converts a JSON null value to a SQL NULL value. (TRUE / FALSE)

Select 1 option(s):

FALSE

TRUE

Q15. You have a dashboard that connects to Snowflake via JDBC. The dashboard is refreshed hundreds of times per day. The data is very stable, only changing once or twice per day. The query run by the dashboard connector user never changes. How will Snowflake manage changing and non-changing data? Mark all true statements.

Select 3 option(s):

Snowflake will spin up a warehouse only if the underlying data has changed

Snowflake will compile results cache data from all user results so no warehouse is needed

Snowflake will re-use data from the Results Cache as long as it is still the most up-to-date data available

Snowflake will show the most up-to-date data each time the dashboard is refreshed

Snowflake will spin up a warehouse each time the dashboard is refreshed

Q16. The compute resource used by Snowflake for data loading jobs can be provided by:

Select 1 option(s):

User managed virtual warehouse

Hardware provisioned by user directly from cloud providers

Snowflake managed service

All of these

Q17. A query you initiated is taking too long. You‘ve gone into the History area to check whether this query (which usually runs every hour) is supposed to take a long time. Check all true statements.

Select 4 option(s):

Information in the History area can be filtered to show a single Warehouse

If you decide to end the query, you must return to the worksheet to Abort the query

Information in the History area can be filtered to show a single User

Information in the History area can be filtered to show a single Session

Information in the History area can help you visually compare query times

Q18. Which SQL command will give the list of all the warehouses in an account?

Select 1 option(s):

SHOW WAREHOUSES;

DISPLAY WAREHOUSE;

LIST WAREHOUSE;

SHOW WAREHOUSE;

LIST WAREHOUSES;

Q19. Each Snowflake account comes with two shared databases. One is a set of sample data and the other contains Account Usage information. Check all true statements about these shared databases.

Select 2 option(s):

SNOWFLAKE_SAMPLE_DATA contains a schema called ACCOUNT_USAGE

SNOWFLAKE contains a schema called ACCOUNT_USAGE

SNOWFLAKE contains a table called ACCOUNT_USAGE

ACCOUNT USAGE is a schema filled with secure views

ACCOUNT_USAGE is a schema filled with external tables

Q20. Which statement accurately describes the Snowflake Cloud Services layer?

Select 1 option(s):

A collection of independent, scalable, and stateless services providing crucial data management capabilities

A set of Cloud providers‘ general services made available to users via the internet

Managed and scaled by the user

A collection of tightly coupled database management features

Q21. If you are defining a multi-column clustering key of a table, the order in which the columns are specified in the CLUSTER BY clause is important. As general rule, Snowflake recommends:

Select 1 option(s):

Ordering the columns from highest cardinality to lowest cardinality

Ordering the columns from lowest cardinality to highest cardinality

Order doesn‘t matter

Q22. Is there any cost benefit of suspending a warehouse in less than 60 seconds?

Select 1 option(s):

YES

Q23. Which are the options available for SECURITYADMIN in Snowflake UI ribbon?(Choose all applicable)

Select 1 option(s):

Notifications

Warehouses

History

Account

Data Exchange

Q24. Which command will help you get the lists of pipes for which you have access privileges?

Select 1 option(s):

SELECT PIPE()

SHOW PIPE

SHOW PIPES()

LIST PIPE

LIST PIPES

Q25. All files stored in stages (for data loading/unloading) automatically encrypted (using either AES 256 standard or 512 strong encryption). (TRUE/FALSE)

Select 1 option(s):

TRUE

FALSE

Q26. In what order servers are removed when a warehouse is suspended or resized?

Select 1 option(s):

FIFO (“FIRST IN, FIRST OUT“)

FILO (“FIRST IN, LAST OUT“)

LIFO (“LAST IN, FIRST OUT“)

LILO (“LAST IN, LAST OUT“)

Q27. Which is not the Security function of cloud services layer?

Select 1 option(s):

Authentication

Encryption and key management

Pruning using metadata about micro-partitions

Access control for shares

Access control for users and roles

Q28. Two virtual warehouses can access the same data at the same time without causing contention issues

Select 1 option(s):

FALSE

TRUE

Q29. Which type of the object key is only used for decryption?

Select 1 option(s):

Retired Key

Active key

Destroyed key

None of these

Q30. What is the minimum billing charge for provisioning a warehouse?

Select 1 option(s):

No charge

60 Minutes

1 Minute

1 Second

Q31. Which all actions can you perform in a defined period of time using Time Travel?

Select 3 option(s):

Restores tables, schemas and databases that have been dropped

Query data in the past

Restore tables, schemas but not databases that have been dropped

Create clones of tables, schemas and databases

Q32. Which of the following industry compliance standards has Snowflake been audited and certified for?

Select 5 option(s):

HIPAA

FedRamp

PCI DSS

SOC1

Cloud GBDQ

SOC Type 2

Q33. What is the data size limit while loading data into VARIANT column?

Select 1 option(s):

10 MB - 100 MB compressed

10 MB - 100 MB uncompressed

16 MB (uncompressed)

16 MB (compressed)

1 GB Compressed

Q34. What is Clustering Depth?

Select 2 option(s):

It can be used to determine whether a large table would benefit from explicitly defining a clustering key

The depth of the overlapping micro-partitions

The bigger the average depth, the better clustered the table

It is the total number of micro-partitions that comprise the table

Q35. To change the warehouse that will be used to run a SQL command within a specific worksheet (for example, changing the worksheet so that it uses LARGE), what two options are available?

Select 2 option(s):

Run a SQL Command like “USE WAREHOUSE LARGE_WH;“

Go to Worksheet properties page and set the Warehouse field to LARGE_WH

Run a SQL command like “SET WAREHOUSE CONTEXT=LARGE_WH“

Update the Warehouse field in the Context Menu located above the worksheet.

Q36. Which Snowflake editions have maximum 90 days of Time-Travel retention period?

Select 3 option(s):

Business Critical

Standard

VPS

All the editions

Enterprise

Q37. How much data each of the micro-partition contain in uncompressed form? Select the

Select 1 option(s):

16 MB

Between 10 MB to 40 MB

Between 50 MB to 500 MB

1 GB

Q38. Which of the following Snowflake Editions automatically store data in an encrypted state?

Select 3 option(s):

Enterprise

Business Critical

Standard

Unattempted

Q39. What data structure types can be ingested into a VARIANT column in a Snowflake table? (Check all that apply)

Select 5 option(s):

PARQUET

AVRO

ORC

XML

JSON

Unattempted

Q40. Snowflake is best suited for OLAP solutions.

Select 1 option(s):

TRUE

FALSE

Q41. Semi-Structured data must be transformed prior to loading the data into a Snowflake table. (TRUE / FALSE)

Select 1 option(s):

TRUE

FALSE

Q42. Snowflake data warehouse is not built on an existing database or big data software platform such as Hadoop.

Select 1 option(s):

TRUE

FALSE

Q43. A Snowflake account can be hosted on any of the many cloud platforms. Please select all the correct answers.

Select 3 option(s):

Dropbox

Oracle Cloud

Google Cloud (GCP)

Azure

AWS

Q44. Which cache type runs on a 24 hour “clock“?

Select 1 option(s):

Results Cache

Metadata Cache

Warehouse Cache

Q45. Snowflake maintains detailed metadata for each table into which data is loaded. For how long Snowflake keeps the metadata active?

Select 1 option(s):

64 Days

31 Days

16 Days

32 Days

24 Hours

Q46. You create a new worksheet in the WebUI. You want to set the user role, warehouse, database, and schema context that will be used when running the SQL code. Which of the options listed here are valid?

Select 2 option(s):

Run four “USE“ commands, setting each context with a separate statement.

Use the Context drop menu in the upper right corner of the worksheet.

Run the SET_CONTEXT(role,warehouse,database,schema) command.

Use fully qualified references to the role and warehouse in each select statement

Q47. The best method to assist pruning on a large table is to:

Select 1 option(s):

Create a CLUSTERED INDEX on the table

Define a PARTITIONING KEY on the table

Define a HASH TABLE for the table

Define a CLUSTER KEY for the table

Create a DENSE INDEX on the table

Q48. Monica mistakenly dropped a table T1 last week. The database has Time-Travel retention period set to 90 days. How can Monica recover the table which she dropped last week.

Select 1 option(s):

Monica should contact Salesforce support to get it done

Monica cant recover it from TIME-TRAVEL as the table T1 moved to Fail-safe

Monica can use the UI > ACCOUNT menu to recover the table T1

Monica can execute UNDROP TABLE T1 command after setting up the right context for Database and schema

Q49. The columns in the query history include the QueryID, the SQL Text, the Warehouse name, the Warehouse Size, the Session ID and others. Which column is a good indicator of whether a Warehouse was used (and Compute costs incurred) by a query?

Select 1 option(s):

Warehouse Name

Session ID

QueryID

Size

Q50. Clustering keys are not intended for all tables. (TRUE / FALSE)

Select 1 option(s):

FALSE

TRUE

Q51. Snowflake calculates usage of data stored in the system for:

Select 4 option(s):

Cloud storage used in External Stage

Files staged for bulk data loading/unloading

Fail-safe for database tables

Clones of database tables that reference data deleted in the table that owns the clones

Database tables, including historical data for Time Travel

Q52. Snowflake compute costs depend on which of the following? (Select 2)

Select 1 option(s):

The sizes of running warehouses.

The number of rows returned in queries.

The amount of time warehouses have run.

The total number of warehouses in the account.

Q53. Snowflake can query the data from External Tables. (TRUE / FALSE)

Select 1 option(s):

TRUE

FALSE

Q54. Snowflake does not begin executing SQL statements submitted to a warehouse until all of the servers for the warehouse are successfully provisioned. If any server fails to provision, Snowflake attempts to repair the failed server. The warehouse starts processing statement once 100% of the requested servers are successfully provisioned.

Select 1 option(s):

TRUE

FALSE

Q55. Compute can be scaled up, down, out, or in and there is no effect on storage used.

Select 1 option(s):

FALSE

TRUE

Q56. Temporary and Transient Tables has 1 day of Fail-safe available. (True/False)

Select 1 option(s):

TRUE

FALSE

Q57. Increasing the size of a warehouse always improves data loading performance.

Select 1 option(s):

FALSE

TRUE

Q58. Which are the types of Virtual Warehouses in Snowflake?

Select 2 option(s):

Enterprise

Standard

Premier

Multi-Cluster

Q59. How much is the Time-Travel retention period of Temporary Table?

Select 1 option(s):

7 days

90 days

0 days

1 day

Q60. Each time the persisted result for a query is reused, Snowflake resets the 24-hour retention period for the result, up to a maximum of 31 days from the date and time that the query was first executed.(TRUE / FALSE)

Select 1 option(s):

FALSE

TRUE

Q61. A multi-cluster warehouse is using an ECONOMY scaling policy, how long will queries back up in the queue before another cluster is started?

Select 1 option(s):

8 Minutes

2 Minutes

1 minute

6 Minutes

It will start immediately

Snowflake Test-3

Q1. Snowflake Storage layer is a Cloud Storage layer. It depends on which cloud provider you are using. Select the current available cloud providers.

Q2. Which view does behave like a table and get auto-refreshed?

Q3. The BI group is complaining about their queries taking too long to run. Checking the virtual warehouse information shows the queued time is pretty high. What is the best way to fix this issue?

Q4. Which is the correct syntax to disable fail safe on a table?

Q5. What is the best use of Multi-Cluster Warehouse?

Q6. SNOWPIPE (REST) method only works with Internal Stages. (TRUE/FALSE)

Q7. What is the name of the Snowflake-produced Command Line Interface tool?

Q8. Which of the following are Snowflake view types? (Select 3)

Q9. Federated Authentication is supported by:

Q10. What are the features of Column-level security? (Select 2)

Q11. You create a Sequence in Snowflake with an initial value of 3 and an interval of 2. Which series of numbers do you expect to see?

Q12. Scaling Out is an automated process (e.g., Min clusters to max clusters)

Q13. Which layer is responsible for Data Security and Authentication?

Q14. STRIP_NULL_VALUE converts a JSON null value to a SQL NULL value. (TRUE / FALSE)

Q16. The compute resource used by Snowflake for data loading jobs can be provided by:

Q17. A query you initiated is taking too long. You‘ve gone into the History area to check whether this query (which usually runs every hour) is supposed to take a long time. Check all true statements.

Q18. Which SQL command will give the list of all the warehouses in an account?

Q19. Each Snowflake account comes with two shared databases. One is a set of sample data and the other contains Account Usage information. Check all true statements about these shared databases.

Q20. Which statement accurately describes the Snowflake Cloud Services layer?

Q21. If you are defining a multi-column clustering key of a table, the order in which the columns are specified in the CLUSTER BY clause is important. As general rule, Snowflake recommends:

Q22. Is there any cost benefit of suspending a warehouse in less than 60 seconds?

Q23. Which are the options available for SECURITYADMIN in Snowflake UI ribbon?(Choose all applicable)

Q24. Which command will help you get the lists of pipes for which you have access privileges?

Q25. All files stored in stages (for data loading/unloading) automatically encrypted (using either AES 256 standard or 512 strong encryption). (TRUE/FALSE)

Q26. In what order servers are removed when a warehouse is suspended or resized?

Q27. Which is not the Security function of cloud services layer?

Q28. Two virtual warehouses can access the same data at the same time without causing contention issues

Q29. Which type of the object key is only used for decryption?

Q30. What is the minimum billing charge for provisioning a warehouse?

Q31. Which all actions can you perform in a defined period of time using Time Travel?

Q32. Which of the following industry compliance standards has Snowflake been audited and certified for?

Q33. What is the data size limit while loading data into VARIANT column?

Q34. What is Clustering Depth?

Q35. To change the warehouse that will be used to run a SQL command within a specific worksheet (for example, changing the worksheet so that it uses LARGE), what two options are available?

Q36. Which Snowflake editions have maximum 90 days of Time-Travel retention period?

Q37. How much data each of the micro-partition contain in uncompressed form? Select the

Q38. Which of the following Snowflake Editions automatically store data in an encrypted state?

Q39. What data structure types can be ingested into a VARIANT column in a Snowflake table? (Check all that apply)

Q40. Snowflake is best suited for OLAP solutions.

Q41. Semi-Structured data must be transformed prior to loading the data into a Snowflake table. (TRUE / FALSE)

Q42. Snowflake data warehouse is not built on an existing database or big data software platform such as Hadoop.

Q43. A Snowflake account can be hosted on any of the many cloud platforms. Please select all the correct answers.

Q44. Which cache type runs on a 24 hour “clock“?

Q45. Snowflake maintains detailed metadata for each table into which data is loaded. For how long Snowflake keeps the metadata active?

Q46. You create a new worksheet in the WebUI. You want to set the user role, warehouse, database, and schema context that will be used when running the SQL code. Which of the options listed here are valid?

Q47. The best method to assist pruning on a large table is to:

Q48. Monica mistakenly dropped a table T1 last week. The database has Time-Travel retention period set to 90 days. How can Monica recover the table which she dropped last week.

Q49. The columns in the query history include the QueryID, the SQL Text, the Warehouse name, the Warehouse Size, the Session ID and others. Which column is a good indicator of whether a Warehouse was used (and Compute costs incurred) by a query?

Q50. Clustering keys are not intended for all tables. (TRUE / FALSE)

Q51. Snowflake calculates usage of data stored in the system for:

Q52. Snowflake compute costs depend on which of the following? (Select 2)

Q53. Snowflake can query the data from External Tables. (TRUE / FALSE)

Q55. Compute can be scaled up, down, out, or in and there is no effect on storage used.

Q56. Temporary and Transient Tables has 1 day of Fail-safe available. (True/False)

Q57. Increasing the size of a warehouse always improves data loading performance.

Q58. Which are the types of Virtual Warehouses in Snowflake?

Q59. How much is the Time-Travel retention period of Temporary Table?

Q60. Each time the persisted result for a query is reused, Snowflake resets the 24-hour retention period for the result, up to a maximum of 31 days from the date and time that the query was first executed.(TRUE / FALSE)

Q61. A multi-cluster warehouse is using an ECONOMY scaling policy, how long will queries back up in the queue before another cluster is started?

Q14. STRIP_NULL_VALUE converts a JSON null value to a SQL NULL value. (TRUE / FALSE)

Q42. Snowflake data warehouse is not built on an existing database or big data software platform such as Hadoop.