Snowflake SnowPro Core COF-C02 mock test 6

Welcome to your Snowflake Test-6

Name

Email

Phone

Q1. In auto scale mode, if new_min_clusters < running clusters, then excess clusters shut down when they finish executing statements and the scaling policy conditions are met

Select 1 option(s):

FALSE

TRUE

Q2. In a multi cluster warehouse, auto-suspend and auto-resume apply only to the entire warehouse and not to the individual clusters in the warehouse

Select 1 option(s):

FALSE

TRUE

Q3. Out of below four options, which options require a running warehouse when retrieving data from them?

Select 2 option(s):

Local Disk Cache

Results Cache

Metadata Cache

Warehouse Cache

Q4. In a multi cluster warehouse, auto-suspending a running warehouse due to inactivity, does not apply to individual clusters, but rather the entire warehouse.

Select 1 option(s):

FALSE

TRUE

Q5. Maximum number of clusters that can be added in multi cluster warehouse is?

Select 1 option(s):

20

10

5

15

Q6. When the warehouse is resized (scaled up or out), then the additional servers that get added will also improve the performance of already running queries

Select 1 option(s):

FALSE

TRUE

Q7. A warehouse was started and it was up and running for 40 seconds. For how many seconds will the warehouse be billed for?

Select 1 option(s):

No charge would be applied as it was up for less than 1 minute

40 seconds

60 seconds

Q8. A warehouse was started and it was up and running for 62 seconds. For how many seconds will the warehouse be billed for?

Select 1 option(s):

60 seconds

62 seconds

120 seconds

70 seconds

Q9. Which of the following are options when creating a Virtual Warehouse?

Select 2 option(s):

Auto Resume

Auto Suspend

Storage Size

Cache Size

Q10. Snowflake Credit Charges for a virtual warehouse is calculated based on:

Select 3 option(s):

The number of servers per cluster (determined by warehouse size).

The length of time each server in each cluster runs.

The number of clusters (if using multi-cluster warehouses).

Number of queries getting executed

Number of Users running the queries concurrently

Q11. In auto scale multi-cluster warehouse same value is specified for both maximum & minimum clusters (except for the value 1)

Select 1 option(s):

TRUE

FALSE

Q12. A medium size warehouse runs in Auto-scale mode for 3 hours with a resize from Medium (4 servers per cluster) to Large (8 servers per cluster). Warehouse is resized from Medium to Large at 1:30 hours, Cluster 1 runs continuously, Cluster 2 runs continuously for the 2nd and 3rd hours, Cluster 3 runs for 15 minutes in the 3rd hour. How many total credits will be consumed

Select 1 option(s):

34

32

30

40

Q13. Which scaling policy, prevents/minimizes queuing by favoring starting additional clusters over conserving credits?

Select 1 option(s):

Standard

None

Legacy

Economy

Q14. There is no benefit to stopping a warehouse before the first 60-second period is over because the credits have already been billed for that period

Select 1 option(s):

FALSE

TRUE

Q15. How many credits will be consumed if a Medium-size warehouse (4 servers per cluster) with 3 clusters runs in Auto Scale mode for 2 hours, where Cluster 1 runs continuously for 2 hours, Cluster 2 runs continously for 2nd hour only, Cluster 3 runs for 30 minutes only during 2nd hour

Select 1 option(s):

12

16

14

24

Q16. A Snowflake session can have multiple current warehouse at a time

Select 1 option(s):

TRUE

FALSE

Q17. How is the query load calculated, which is displayed on the “Warehouse Load over Time“ chart in Snowflake Web UI

Select 1 option(s):

Execution time + Queued Time (in seconds) of all queries in an interval by the total time (in seconds) for the interval

The formula is not known to the users, and its internally computed by snowflake only

Number of queries running in the given interval divided by the number of seconds in the interval

(Number of queries running + Number of queries in queue) in the given interval divided by the number of seconds in the interval

Q18. When configuring a Warehouse using a Snowflake edition that has Elastic Data Warehousing enabled, what facets or components will you need to configure that are not needed in accounts where Elastic Data Warehousing is not enabled?

Select 2 option(s):

Scaling Policy

Minimum and Maximum Servers

Auto-Suspend

Minimum and Maximum Clusters

Auto-Resume

Q19. Which type of stage can store files that are staged and managed by one or more users and loaded into one or more tables

Select 1 option(s):

User

Table

Named

Q20. Replication operations use Snowflake-provided compute resources to copy data between accounts across regions.

Select 1 option(s):

FALSE

TRUE

Q21. Which all permissions snowflake requires on a S3 bucket and folder to be able to access files in the folder (and subfolders)

Select 3 option(s):

s3:GetObject

s3:ListBucket

s3:GetObjectVersion

s3:ReadObject

Q22. Copy options set in multiple locations are cumulative. Individual options set in one place override the same option set lower in the order of precedence.

Select 1 option(s):

FALSE

TRUE

Q23. What is the default compression of the output files generated by Snowflake when unloading data

Select 1 option(s):

brotli

gzip

Zstandard

bzip2

Q24. When database replication is setup, then querying tables and views in a secondary database using Time Travel will always produce exact same results as that of when executing the same query in the primary database.

Select 1 option(s):

FALSE

TRUE

Q25. Which file formats are supported in the COPY command?

Select 4 option(s):

Unstructured

CSV

JSON

TSV

Avro

Q26. Resource monitors provide control over virtual warehouse credit usage; however, you cannot use them to control credit usage for the Snowflake-provided warehouses, including the SNOWPIPE warehouse

Select 1 option(s):

FALSE

TRUE

Q27. Which of the transformations are supported while loading data into table using the COPY command

Select 4 option(s):

Column Reordering

Casts

Aggregations

Column Omission

Truncating text strings that exceed the target column length

Q28. Which types of database objects are currently supported while doing database replication?

Select 3 option(s):

Stored Procedures

Streams

Stages

File Formats

Materialized Views

Tasks

Q29. Which of the following stages cannot be altered or dropped?

Select 1 option(s):

User

Table

Named External Stage

Named Internal Stage

Q30. Bulk loading relies on the user-provided virtual warehouses

Select 1 option(s):

FALSE

TRUE

Q31. Which of the following is a separate database object?

Select 1 option(s):

Table Stage

Named Stage

User Stage

Q32. In a VARIANT column, NULL values are stored as a string containing the word ânull,â not the SQL NULL value.

Select 1 option(s):

FALSE

TRUE

Q33. Which Snowflake object records DML changes made to tables, including inserts, updates, deletes as well as metadata about each change, so that actions can be taken using the changed data

Select 1 option(s):

Snowpipe

Stream

Task

Kafka

Q34. In snowflake, while processing a query, the number of rows in the tables being queried has more impact than the overall size of the tables

Select 1 option(s):

TRUE

FALSE

Q35. Which of the following are true of Multi-Cluster warehouses? Select all that apply.

Select 2 option(s):

Scales In when query activity slows

Adds clusters automatically based on query activity

Sizes each cluster optimally based on the queries

Multi-cluster warehouses will never auto-suspend

Q36. A warehouse can be started at any time, excluding the initial creation time

Select 1 option(s):

FALSE

TRUE

Q37. Which scaling policy, conserves credits by favoring keeping running clusters fully-loaded rather than starting additional clusters, which may result in queries being queued and taking longer to complete?

Select 1 option(s):

Economy

None

Standard

Legacy

Q38. In auto scale mode, if new_min_clusters > running clusters, then additional clusters immediately started to meet the minimum.

Select 1 option(s):

TRUE

FALSE

Q39. Multi-cluster warehouses is only available in Enterprise Edition and above

Select 1 option(s):

FALSE

TRUE

Q40. Scaling a warehouse OUT will increase the number of servers. (e.g. Min to Max)

Select 1 option(s):

FALSE

TRUE

Q41. How many credits will be consumed if a Small-size warehouse (2 servers per cluster) with 3 clusters runs in Maximized mode for 2 hours

Select 1 option(s):

18

36

12

24

Q42. Scaling in is a manual process (e.g. Max Clusters to min clusters)

Select 1 option(s):

TRUE

FALSE

Q43. What can be the maximum credits consumed by a medium size warehouse with 3 clusters in one hour?

Select 1 option(s):

24

12

6

8

Q44. How many credits will be consumed if a Medium-size warehouse (4 servers per cluster) with 3 clusters runs in Auto-scale mode for 3 hours, in which Cluster 1 runs continuously, Cluster 2 runs continuously for the entire 2nd hour and 30 minutes in the 3rd hour, Cluster 3 runs for 30 minutes in the 3rd hour

Select 1 option(s):

20

24

18

16

Q45. How many credits will be consumed if a Medium-size warehouse (4 servers per cluster) with 3 clusters runs in Maximized mode for 2 hours

Select 1 option(s):

18

36

24

12

Q46. Scaling out is an automated process (e.g. Min clusters to max clusters)

Select 1 option(s):

FALSE

TRUE

Q47. In a multi cluster warehouse, for each cluster there is a way we can specify different warehouse sizes

Select 1 option(s):

TRUE

FALSE

Q48. When a warehouse is suspended, the idle servers in that warehouse are immediately shut down, but any servers that are executing queries are allowed to run until the queries are completed. Such servers that are waiting to shut down are considered to be in which mode?

Select 1 option(s):

Quiet

Quiesce

Suspending

Shutting Down

Q49. Scaling out of a warehouse can be done only in Enterprise edition and higher

Select 1 option(s):

FALSE

TRUE

Q50. Which of the following terms are associated with the Compute/Warehouse Layer?

Select 1 option(s):

Query Processing

Query Planning

Query Optimization

Query Compilation

Query Design

Q51. If a multi-cluster warehouse is resized, the new size applies to all the clusters for the warehouse, including clusters that are currently running and any clusters that are started after the warehouse is resized

Select 1 option(s):

FALSE

TRUE

Q52. In auto scale mode, if new_max_clusters > running clusters, then no changes happen until additional clusters are needed

Select 1 option(s):

TRUE

FALSE

Q53. Scaling a warehouse DOWN will decrease the number of servers. (e.g. Medium to Small)

Select 1 option(s):

TRUE

FALSE

Q54. In maximized mode, what happens if the number of clusers are increased? (e.g. previously min & max was 2, but now min & max cluster size is changed to 4)

Select 1 option(s):

There will not be any immediate impact, and the additional clusters will start only when the query workload demands

Specified number of clusters (in this case 4) would start immediately

Specified number of clusters would start after current queries that are executed are completed

The number of clusters in maximized mode cannot be changed

Q55. In maximized multi-cluster warehouse same value is specified for both maximum & minimum clusters (except for the value 1)

Select 1 option(s):

TRUE

FALSE

Q56. The scaling policy for a multi-cluster warehouse only applies (make sense) if it is running in Auto-scale mode and not in Maximized Mode

Select 1 option(s):

TRUE

FALSE

Q57. Scaling a warehouse UP will decrease the number of clusters. (e.g. Small to Medium)

Select 1 option(s):

FALSE

TRUE

Q58. Default Size of the warehouse created using CREATE WAREHOUSE command is

Select 1 option(s):

X-LARGE

SMALL

MEDIUM

X-SMALL

Q59. Scaling up is a manual process. (e.g. Small to Medium)

Select 1 option(s):

TRUE

FALSE

Q60. If a 3X-Large multi-cluster warehouse runs 1 cluster for one full hour and then runs 2 clusters for the next full hour, the total number of credits billed would be

Select 1 option(s):

128

256

192

64

Q61. Scaling a warehouse IN will decrease the number of clusters. (e.g. Max to Min)

Select 1 option(s):

TRUE

FALSE

Q62. Warehouses can be started and stopped at any time

Select 1 option(s):

TRUE

FALSE

Q63. Scaling down is a automated process. (e.g. X-Large to Large)

Select 1 option(s):

FALSE

TRUE

Q64. Warehouses can also be resized at any time, even while running, to accommodate the need for more or less compute resources

Select 1 option(s):

TRUE

FALSE

Q65. Which scaling policy, starts additional cluster immediately when either a query is queued or the system detects that there is one more query than the currently-running clusters can execute.

Select 1 option(s):

Economy

Standard

Legacy

None

Snowflake Test-6

Q1. In auto scale mode, if new_min_clusters < running clusters, then excess clusters shut down when they finish executing statements and the scaling policy conditions are met

Q2. In a multi cluster warehouse, auto-suspend and auto-resume apply only to the entire warehouse and not to the individual clusters in the warehouse

Q3. Out of below four options, which options require a running warehouse when retrieving data from them?

Q4. In a multi cluster warehouse, auto-suspending a running warehouse due to inactivity, does not apply to individual clusters, but rather the entire warehouse.

Q5. Maximum number of clusters that can be added in multi cluster warehouse is?

Q6. When the warehouse is resized (scaled up or out), then the additional servers that get added will also improve the performance of already running queries

Q7. A warehouse was started and it was up and running for 40 seconds. For how many seconds will the warehouse be billed for?

Q8. A warehouse was started and it was up and running for 62 seconds. For how many seconds will the warehouse be billed for?

Q9. Which of the following are options when creating a Virtual Warehouse?

Q10. Snowflake Credit Charges for a virtual warehouse is calculated based on:

Q11. In auto scale multi-cluster warehouse same value is specified for both maximum & minimum clusters (except for the value 1)

Q13. Which scaling policy, prevents/minimizes queuing by favoring starting additional clusters over conserving credits?

Q14. There is no benefit to stopping a warehouse before the first 60-second period is over because the credits have already been billed for that period

Q15. How many credits will be consumed if a Medium-size warehouse (4 servers per cluster) with 3 clusters runs in Auto Scale mode for 2 hours, where Cluster 1 runs continuously for 2 hours, Cluster 2 runs continously for 2nd hour only, Cluster 3 runs for 30 minutes only during 2nd hour

Q16. A Snowflake session can have multiple current warehouse at a time

Q17. How is the query load calculated, which is displayed on the “Warehouse Load over Time“ chart in Snowflake Web UI

Q18. When configuring a Warehouse using a Snowflake edition that has Elastic Data Warehousing enabled, what facets or components will you need to configure that are not needed in accounts where Elastic Data Warehousing is not enabled?

Q19. Which type of stage can store files that are staged and managed by one or more users and loaded into one or more tables

Q20. Replication operations use Snowflake-provided compute resources to copy data between accounts across regions.

Q21. Which all permissions snowflake requires on a S3 bucket and folder to be able to access files in the folder (and subfolders)

Q22. Copy options set in multiple locations are cumulative. Individual options set in one place override the same option set lower in the order of precedence.

Q23. What is the default compression of the output files generated by Snowflake when unloading data

Q24. When database replication is setup, then querying tables and views in a secondary database using Time Travel will always produce exact same results as that of when executing the same query in the primary database.

Q25. Which file formats are supported in the COPY command?

Q26. Resource monitors provide control over virtual warehouse credit usage; however, you cannot use them to control credit usage for the Snowflake-provided warehouses, including the SNOWPIPE warehouse

Q27. Which of the transformations are supported while loading data into table using the COPY command

Q28. Which types of database objects are currently supported while doing database replication?

Q29. Which of the following stages cannot be altered or dropped?

Q30. Bulk loading relies on the user-provided virtual warehouses

Q31. Which of the following is a separate database object?

Q32. In a VARIANT column, NULL values are stored as a string containing the word ânull,â not the SQL NULL value.

Q33. Which Snowflake object records DML changes made to tables, including inserts, updates, deletes as well as metadata about each change, so that actions can be taken using the changed data

Q34. In snowflake, while processing a query, the number of rows in the tables being queried has more impact than the overall size of the tables

Q35. Which of the following are true of Multi-Cluster warehouses? Select all that apply.

Q36. A warehouse can be started at any time, excluding the initial creation time

Q37. Which scaling policy, conserves credits by favoring keeping running clusters fully-loaded rather than starting additional clusters, which may result in queries being queued and taking longer to complete?

Q38. In auto scale mode, if new_min_clusters > running clusters, then additional clusters immediately started to meet the minimum.

Q39. Multi-cluster warehouses is only available in Enterprise Edition and above

Q40. Scaling a warehouse OUT will increase the number of servers. (e.g. Min to Max)

Q41. How many credits will be consumed if a Small-size warehouse (2 servers per cluster) with 3 clusters runs in Maximized mode for 2 hours

Q42. Scaling in is a manual process (e.g. Max Clusters to min clusters)

Q43. What can be the maximum credits consumed by a medium size warehouse with 3 clusters in one hour?

Q45. How many credits will be consumed if a Medium-size warehouse (4 servers per cluster) with 3 clusters runs in Maximized mode for 2 hours

Q46. Scaling out is an automated process (e.g. Min clusters to max clusters)

Q47. In a multi cluster warehouse, for each cluster there is a way we can specify different warehouse sizes

Q48. When a warehouse is suspended, the idle servers in that warehouse are immediately shut down, but any servers that are executing queries are allowed to run until the queries are completed. Such servers that are waiting to shut down are considered to be in which mode?

Q49. Scaling out of a warehouse can be done only in Enterprise edition and higher

Q50. Which of the following terms are associated with the Compute/Warehouse Layer?

Q51. If a multi-cluster warehouse is resized, the new size applies to all the clusters for the warehouse, including clusters that are currently running and any clusters that are started after the warehouse is resized

Q52. In auto scale mode, if new_max_clusters > running clusters, then no changes happen until additional clusters are needed

Q53. Scaling a warehouse DOWN will decrease the number of servers. (e.g. Medium to Small)

Q54. In maximized mode, what happens if the number of clusers are increased? (e.g. previously min & max was 2, but now min & max cluster size is changed to 4)

Q55. In maximized multi-cluster warehouse same value is specified for both maximum & minimum clusters (except for the value 1)

Q56. The scaling policy for a multi-cluster warehouse only applies (make sense) if it is running in Auto-scale mode and not in Maximized Mode

Q57. Scaling a warehouse UP will decrease the number of clusters. (e.g. Small to Medium)

Q58. Default Size of the warehouse created using CREATE WAREHOUSE command is

Q59. Scaling up is a manual process. (e.g. Small to Medium)

Q60. If a 3X-Large multi-cluster warehouse runs 1 cluster for one full hour and then runs 2 clusters for the next full hour, the total number of credits billed would be

Q61. Scaling a warehouse IN will decrease the number of clusters. (e.g. Max to Min)

Q62. Warehouses can be started and stopped at any time

Q63. Scaling down is a automated process. (e.g. X-Large to Large)

Q64. Warehouses can also be resized at any time, even while running, to accommodate the need for more or less compute resources

Q65. Which scaling policy, starts additional cluster immediately when either a query is queued or the system detects that there is one more query than the currently-running clusters can execute.

Q32. In a VARIANT column, NULL values are stored as a string containing the word ânull,â not the SQL NULL value.