Preview 8 out of 10 Flashcards
Question #:2

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

A.	The tables are now orphaned

B.	The user that deleted the role

C.	SYSADMIN

D.	The assumed role that dropped the role
Question #:2

A role is created and owns 2 tables. This role is then dropped. Who will now own the t...
Answer: D
Question #:3

When should you consider disabling auto-suspend for a Virtual Warehouse?

Choose 2 answers

A.	When users will be using compute at different times throughout a 24/7 period

B.	When managing a steady workload

C.	When the compute must be available with no delay or lag time

D.	When you don’t want to have to manually turn on the Warehouse each time a user needs it
Question #:3

When should you consider disabling auto-suspend for a Virtual Warehouse?

Choose 2 ans...
Answer: B C
Snowflake Certification Exam SnowPro-Core has been designed to measure your skills in handling the technical tasks mentioned in the certification syllabus
Snowflake Certification Exam SnowPro-Core has been designed to measure your skills in handling the t...
https://www.dumpstool.com/SnowPro-Core-exam.html
Question #:5

What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?

Select one.

A.	INITTIALLY_SUSPENDED = TRUE/FALSE

B.	START_AFTCR_CREATE = TRUE/FALSE

C.	START_TTIME = 60 // (seconds from now)

D.	START.TIME = CURRENT.DATE()
Question #:5

What parameter controls if the Virtual warehouse starts immediately after the CREATE W...
Answer: A
Question #:6

Which of the following statements are true of Snowflake releases: (Choose two.)

A.	They happen approximately weekly

B.	They roll up and release approximately monthly, but customers can request early release application

C.	During a release, new customer requests/queries/connections transparently move over to the newer version

D.	A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the

system will be unavailable and customer is upgraded
Question #:6

Which of the following statements are true of Snowflake releases: (Choose two.)

A.	Th...
Answer: C D
Question #:7

When can a Virtual Warehouse start running queries?

A.	12am-5am

B.	Only during administrator defined time slots

C.	When its provisioning is complete

D.	After replication
Question #:7

When can a Virtual Warehouse start running queries?

A.	12am-5am

B.	Only during admin...
Answer: B
Question #:8

Which item in the Data Warehouse migration process does not apply in Snowflake>

A.	Migrate Users

B.	Migrate Schemas

C.	Migrate Indexes

D.	Build the Data pipeline
Question #:8

Which item in the Data Warehouse migration process does not apply in Snowflake>

A....
Answer: C
Question #:9

Which of the following statements is true of data loading?

Select one.

A.	Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast

B.	The "deal file size for loading is 16MB to match micro-partition size

C.	Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file
Question #:9

Which of the following statements is true of data loading?

Select one.

A.	Resizing t...
Answer: C