Free SnowPro Core Mock Test for Certification Prep

Welcome to your Snowflake Test-4

Name

Email

Phone

Q1. What is correct about multi cluster virtual warehouses?

Select 2 option(s):

Multi Cluster will remove the additional clusters as query demand decreases

Maximum of 5 multi cluster warehouse can be created in one snowflake account

Multi Cluster warehouses cannot be suspended

Multi Cluster warehouse will spin up additional clusters when under high query workload which is beyond the current capacity

Q2. There is no additional storage charges with rekeying of data in Fail-safe.

Select 1 option(s):

TRUE

FALSE

Q3. Resource monitor notifications can be received by account administrators through the following ways

Select 2 option(s):

Email

Web Interface

SMS

Push Notification

Q4. Time travel can be disabled at account level by any user?

Select 1 option(s):

TRUE

FALSE

Q5. When a table which has time traveled enabled is dropped, and if a table with same name is created after that, what happens?

Select 1 option(s):

The table with same name cannot be created till the time time travel retention period of dropped object is over

The table with same name cannot be created till the time time travel retention period and fail safe period of dropped object is over

It restores the previous dropped version of the table

It creates a new version of the table

Q6. Micro partitions are immutable which means once created they cannot be changed.

Select 1 option(s):

TRUE

FALSE

Q7. You have a virtual warehouse named BI_warehouse which is sized as Medium. You need to resize it to X-LARGE for future queries. What is the best way to make this change.

Select 1 option(s):

Drop and recreate the same warehouse with X-LARGE size

It is not permitted to resize the warehouse once its created

Alter the existing warehouse either by using an ALTER command or through the Snowflake Web UI to change the size

Q8. 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):

Standard

Legacy

None

Economy

Q9. The standard retention period for time travel is of how many days, which is automatically enabled for all Snowflake accounts

Select 1 option(s):

7

30

1

15

Q10 Fail-safe is not provided as a means for accessing historical data after the Time Travel retention period has ended. It is for use only by Snowflake to recover data that may have been lost or damaged due to extreme operational failures

Select 1 option(s):

TRUE

FALSE

Q11. A user can upload one or more data files to an external stage. If the stage is a customer-managed container in a cloud storage service (like S3 in AWS), the user may or may not encrypt the data files using client-side encryption

Select 1 option(s):

TRUE

FALSE

Q12. Which of the following tables have no fail safe period?

Select 2 option(s):

Transient

Permanent

Temporary

Q13. Which access control privileges must be granted on specified resource monitors for roles other than account administrators to view and modify resource monitors as needed

Select 1 option(s):

MODIFY

CREATE

UPDATE

MONITOR

Q14. Resource monitor notifications can be received only by account administrators

Select 1 option(s):

FALSE

TRUE

Q15. Please look at the below two queries Option 1: SELECT * FROM TABLE_NAME WHERE YEAR = 2015 AND UPPER(COL_NAME) = ‘VALUE1‘; Option 2: SELECT * FROM TABLE_NAME WHERE YEAR = 2015 AND COL_NAME =‘VALUE1‘; Which one of these will scan less partitions? Note: COL_NAME stores values both in upper and lower case

Select 1 option(s):

Option 2

Option 1

Both will scan same number of partitions

Scanning of partition is random, so no concrete logic can be applied on scanning logic

Q16. Resource monitors support the below actions

Select 3 option(s):

Notify & Suspend

Notify & Call accountadmins

Notify

Notify & Suspend Immediately

Notify & Abort

Notify & raise snowflake support ticket

Q17. When a table which has time traveled enabled is dropped, and if a new table with same name is created after that, then the undrop table command is executed, what will happen?

Select 1 option(s):

The table will be restored with a different name

The newly created table will be overwritten with the restored version of the table

The undrop command fails

Q18. Both time travel & failsafe require extra storage which has cost associated with it

Select 1 option(s):

FALSE

TRUE

Q19. Which property of resource monitor specifies whether the resource monitor is used to monitor the credit usage for your entire Account (i.e. all warehouses in the account) or a specific set of individual warehouses

Select 1 option(s):

None

MONITOR LEVEL

SINGLE_MULTIPLE

CREDIT QUOTA

Q20. Tri-Secret Secure option is available in which Snowflake Edition

Select 1 option(s):

Enterprise & higher

Business Critical & higher

All editions

Q21. What happens to the data of a table that is currently in time travel, when the retention period of a table is increased? E.g. The retention period is increased from 10 days to 20 days.

Select 1 option(s):

When data retention is changed, all the data in time travel moves to fail safe by default

The data in time travel will be retained as per previous retention period only i.e. for 10 days only

None is true

The data in time travel will be retained for the extended period of retention period i.e. for 20 days

Q22. It is not possible to suspend a specific cluster in a multi - cluster virtual warehouse but rather the whole virtual warehouse is suspended.

Select 1 option(s):

FALSE

TRUE

Q23. Which minimum Snowflake license allows Mulitcluster data virtual warehouse capability?

Select 1 option(s):

Standard

VPS

Enterprise

Business Critical

Q24. Select the statements that are true for a shared database

Select 2 option(s):

Users in a consumer account can view/query data, but cannot insert or update data, or create any objects in the database.

Time Travel can be done by consumer on shared database

Consumer can clone the objects present in shared database

Shared databases are read-only

Consumer can edit the comments of the shared database

Q25. When a table data changes (for e.g. few records are updated and few are deleted) and the table is within the time travel retention period, which of the following statement is true?

Select 1 option(s):

Snowflake maintains only the information pertaining to these changed records (i.e. updated & deleted ones)

Snowflake takes a full copy of the table every time any change is made to the table

Q26. Maximum historical data that can be maintained of Transient & Temporary table is?

Select 1 option(s):

7 Days

0 Day

1 Day

90 Days

Q27. Which of the following is true regarding Roles in Snowflake?

Select 2 option(s):

A role can be assigned to another role

A user can be assinged multiple roles

Privlieges can be assigned to role and also directly to individual users

Maximum number of roles that can be assinged to a user is 5

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

Select 1 option(s):

FALSE

TRUE

Q29. Multi cluster virtual warehouses are designed to handle –

Select 3 option(s):

Queuing issues

Large Complex Queries

Large number of concurrent users (executing query at same time)

Large number of concurrent queries

Q30. Which of the follo6wing Snowflake Editions allow only a maximum of 1 day of time travel?

Select 1 option(s):

VPS

Business Critical

Standard

Enterprise

Q31. If retrieval of data from fail safe is required, you must

Select 1 option(s):

Retrieval from Fail Safe is not possible

Contact Snowflake Support

Query the Fail Safe DB and retrive the data by yourself

Download it directly from the underlying cloud storage of Snowflake

Q32. Time Travel and Fail safe are one and the same thing?

Select 1 option(s):

TRUE

FALSE

Q33. After how many days account and table master keys are automatically rotated by Snowflake?

Select 1 option(s):

60

45

90

30

Q34. For a single snowflake session, more than one virtual warehouse can be specified at a time for executing a query.

Select 1 option(s):

TRUE

FALSE

Q35. True or false: A table in Snowflake can only be queried using the Virtual Warehouse used to load the data.

Select 1 option(s):

TRUE

FALSE

Q36. True or false: Virtual Warhouses cannot be resized while queries are running.

Select 1 option(s):

TRUE

FALSE

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

Select 2 option(s):

Adds clusters automatically based on query activity

Sizes each cluster optimally based on the queries

Scales down when query activity slows

Multi-cluster warehouses will never auto-suspend

Q38. Under what circumstances would Fail-Safe NOT be an effective method for data recovery?

Select 1 option(s):

As a means for accessing historical data after the Time Travel retention period has ended

To recover data that may have been lost or damaged due to extreme operational failures

To protect data in the event of a system failure or other catastrophic event e.g. a hardware failure or security breach

Q39. Which role is most powerful role in a Snowflake system?

Select 1 option(s):

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

Q40. Snowflake uses a staged release process for new releases in which different account types are upgraded gradually.

Select 1 option(s):

TRUE

FALSE

Q41. All security related information is stored in which layer of snowflake architecture

Select 1 option(s):

Storage

None

Cloud Service

Compute

Q42. When a network policy includes values in both the allowed and blocked IP address lists, Snowflake applies the blocked IP address list first

Select 1 option(s):

FALSE

TRUE

Q43. In Tri Secret Secure option customer manages the master key

Select 1 option(s):

TRUE

FALSE

Q44. When a table which has time traveled enabled is dropped, and if a new table with same name is created after that, then the dropped table cannot be restored back ever?

Select 1 option(s):

FALSE

TRUE

Q45. To clone a table your current role must have which privilege on the source table?

Select 1 option(s):

DELETE

SELECT

UPDATE

INSERT

Q46. What is the recommended file size to optimize the number of parallel operations for a load?

Select 1 option(s):

10 MB to 100 MB (uncompressed)

10 MB to 100 MB (compressed)

1 MB to 10 MB (compressed)

100 MB to 250 MB (compressed)

Q47. Which parameter is required to be set to modify the time travel period of any object in snowflake?

Select 1 option(s):

DATA_RETENTION_TIME_IN_WEEKS

DATA_RETENTION_TIME_IN_MINUTES

DATA_RETENTION_TIME_IN_DAYS

DATA_RETENTION_TIME_IN_HOURS

Q48. You are using a XL warehouse which has 16 nodes and 4 cores in each node. When you submit a query to this warehouse, snowflake maximum split of the query can be into how many partitions? (Provided that the query is eligible for maximum splitting)

Select 1 option(s):

4

16

64

128

Q49. Fail Safe period starts right after time travel retention period ends

Select 1 option(s):

FALSE

TRUE

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

Select 2 option(s):

Auto Suspend

Storage Size

Auto Resume

Cache Size

Q51. Periodic rekeying requires Enterprise Edition and higher

Select 1 option(s):

FALSE

TRUE

Q52. As an ETL developer you are developing jobs to load data into a snowflake table. You have an S3 stage defined which contains a single file containing 1000 rows. You managed to load those 1000 rows using the copy command of snowflake, but while performing further executions of those copy command, you notice that your COPY command is executing successfully but is loading zero rows into the target table. What could be the reason?

Select 1 option(s):

Snowflake Tracks the file that have been loaded and will not load the same file again

The file that was loaded on first run got deleted, as with every copy command the associated files are removed from S3

The file might have got corrupted

Q53. What is the size limit on the variant data type in snowflake?

Select 1 option(s):

10 MB (compressed)

16 MB (uncompressed)

10 MB (uncompressed)

16 MB (compressed)

Q54. Federated authentication in snowflake is compliant with SAML2.0

Select 1 option(s):

FALSE

TRUE

Q55. What are the resources that a virtual warehouse provides?

Select 3 option(s):

Temporary Storage

CPU (Processing Power)

Memory

User & Role Management

Long term data storage

Q56. You can increase or decrease the size of a virtual warehouse as your user base & query demand increase or decrease?

Select 1 option(s):

TRUE

FALSE

Q57. Which are the 2 modes in which a multi cluster warehouse can run?

Select 2 option(s):

Minimized

Dynamic

Maximized

Balanced

Auto-Scale

Q58. If a server runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, it is billed for how many seconds?

Select 1 option(s):

91

120

90

121

Q59. Users created in a reader account can not do which of the following?

Select 3 option(s):

SELECT

DELETE

UPDATE

INSERT

Q60. Which encryption algorithm used by snowflake?

Select 1 option(s):

RSA

DES

AES 256 bit encryption

MD5

Q61. Under the Download section in Snowflake Web UI, what are the connectors & programs that can be downloaded? Select All that apply

Select 3 option(s):

Snowpipe Connector

SnowSQL

Tableau Connector

ODBC driver

Power BI Connector

JDBC driver

Q62. Which command can be executed to get the version history of table “Test1“ in schema “mytestdb.myschema“ within the time travel period in snowflake?

Select 1 option(s):

show tables version like ‘Test1‘ in mytestdb.myschema;

show tables history like ‘Test1‘ in mytestdb.myschema;

show history of table like ‘Test1‘ in mytestdb.myschema;

show version of table like ‘Test1‘ in mytestdb.myschema;

Q63. You are the solution architect for a large manufacturing company running a Snowflake data warehouse. Your Snowflake implementation has just gone live with a single virtual warehouse and has been opened up to all the users across the organization. One of your heaviest users are the marketing department, who have a large number of users and execute a large number of queries. Marketing users have complained that the queries take a long time to execute for them. What is the best immediate action should you take to improve their experience?

Select 1 option(s):

Increase the size of your single warehouse to the maximum size possible

Study each and every query of the marketing team and optimize them

Limit the number of queries that marketing team can execute

Have a dedicated warehouse for marketing team, and set the capacity of this warehouse as per the needs of marketing team

Q64. As a consumer you can create only one database per share?

Select 1 option(s):

TRUE

FALSE

Q65. Changing the retention period for your account or individual objects changes the value for all lower-level objects that do not have a retention period explicitly set. For example: If you change the retention period at the account level, all databases, schemas, and tables that do not have an explicit retention period automatically inherit the new retention period.

Select 1 option(s):

TRUE

FALSE