Free Snowflake SnowPro-Core Exam Dumps and SnowPro-Core Exam Questions

Question No: 1

MultipleChoice

Which statements are true of micro-partitions?

Choose 2 answers

Options

AThey are approximately 16MB in size

BThey are stored compressed only if COMPRESS=TRUE on Table

CThey are Immutable

DThey are only encrypted in the Enterprise edition and above

Question No: 2

MultipleChoice

Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)?

Choose 2 answers

Options

ASnowSQL

BODBC

CR

DHIVE

Question No: 3

MultipleChoice

What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.

Options

AInstalling and configuring hardware

BPatching software

CPhysical security

DMaintaining metadata and statists

Question No: 4

MultipleChoice

Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):

Select one:

Options

ASECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN

BSECURITYADMIN ACCOUNTADMIN, SYSADMIN

CSECURITYADMIN, ACCOUNTADMIN

DACCOUNTADMIN

Question No: 5

MultipleChoice

True or False: Snowpipe via RFST API can only reference External Stages as source.

Options

ATrue

BFalse

Question No: 6

MultipleChoice

When creating a user it is advisable sable to:

Choose 2 answers

Options

ASet the user to be initially disabled

BForce an immediate password change

CSet a default role for the user

DSet the number of minutes to unlock to 15 minutes

ESet the users access to expire within a specified timeframe

Question No: 7

MultipleChoice

How would you execute a series of SQL statements using Task?

Options

Ainclude the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..
INSERT INTO target2 SELECT .. FROM stream .s1 where ..

BA stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);

CA stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask.... AS call
stored_proc_multiple_statements_inside():

DCreate a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.

Question No: 8

MultipleChoice

On which of the following cloud platforms can a Snowflake account be hosted? (Choose three.)

Options

AAmazon Web Services

BPrivate Virtual Cloud

COracle Cloud

DMicrosoft Azure Cloud

EGoogle Cloud Platform

FAlibaba Cloud

Question No: 9

MultipleChoice

What command is used to load files into an Internal Stage within Snowflake? Select one.

Options

APUT

BCOPY INTO

CTRANSFER

DINSERT

Question No: 10

MultipleChoice

When loading data into Snowflake, the COPY command supports:

Choose 2 answers

Options

AJoins

BFitters

CData type conversions

DColumn reordering

EAggregates