Cost

Question 1

How does snowflake charge storage

Answer 1

Daily average size cost

Question 2

How does sf compute cost

Answer 2

Per sec basis
1st 60 sec charged fixed
Then as per 1sec

Question 3

Can scale up my compute

Answer 3

Yes
As they are decoupled we can do that independently

Question 4

Can 20k people access snowflake will it impact app

Answer 4

No
As it is hosted in cloud we can use it as it is

Question 5

Who is brian of sf

Answer 5

Cloud service layer

Question 6

My query is running on xs can shift to xxxl by creating it does it going to take time

Answer 6

No
Once you create it that will work immediately

Question 7

What is used as unit to charge in sf for running in s vm

Answer 7

Unit and its 1 unit per hour

Question 8

Unit to doller mapping

Answer 8

Based on sf edition
Remote area going to charge alot

Question 9

Can cache will share accross users

Answer 9

Yes

Question 10

What is secure view

Answer 10

It has security
It is best to use normal view as it uses internal optimization

Question 11

only for user and role management

Answer 11

useradmin

Question 12

which schema gives the detail regarding the storage and compute details

Answer 12

info schem

Question 13

how much should be clustering key

Answer 13

3 to 4

Question 14

udf can be used in sql statements ?

Answer 14

yes

Question 15

A task can execute any one of the following types of SQL code

Answer 15

single line statement , procedure and logic of procedure

Question 15

which is primary tool for loading the data in snowflake . a ) snowflake ui or b) snowSql

Answer 15

snowsql

Question 16

which is slowest pattern or internal file path

Answer 16

pattern

Question 17

which view give the detail usage of account access usage

Answer 17

account acess usage view

Question 18

which file functions help to crete the url for unnamed sturcture data

Answer 18

build stage file url

Question 19

search optimization is a which level property

Answer 19

table level and it looks for column for better optimization

Question 20

What is the expiration period of a File URL?

Answer 20

permanent

Question 21

Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:

Answer 21

External tables ,Secure views ,Secure materialized views ,Secure UDFs

Question 22

Tables and views protected by row access policies cannot be used with the Search Optimization Search.

Answer 22

truee

Question 23

Dynamic Data Masking is not supported by in which editions of snowflake

Answer 23

standard editions

Question 24

What are the two modes available for setting up a multi-cluster warehouse in Snowflake? Choose the correct options.

Answer 24

"Maximized mode" ensures all clusters are active, providing consistent performance for high-concurrency scenarios. "Auto-scaling mode"

Question 25

"Maximized mode" ensures all clusters are active, providing consistent performance for high-concurrency scenarios. "Auto-scaling mode"

Answer 25

parquet and json

Question 26

on clustering keys

Answer 26

Clustering keys are not for every table. Tables in the multi-terabyte range are good candidates for clustering keys. Both automatic clustering and reclustering consume credit. A single clustering key can contain one or more columns or expressions. Snowflake recommends a maximum of three or four columns (or expressions) per key for most tables. Adding more than 3-4 columns tends to increase costs more than benefits.

Question 27

Which algorithm does Snowflake use to estimate the approximate number of distinct values in a data set?

Answer 27

HyperLogLog

Question 28

At what frequency does Snowflake rotate the object keys?

Answer 28

30 Days