Snowflake SnowPro-Core Quiz:2 Topic:5 Questions:6-10

Free Practice Mock Questions Set 6-10 (Quiz # 2) for Snowflake SnowPro-Core Exam, according to official Snowflake SnowPro Core Exam syllabus topic # 5

Question: 1

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

ACompute Credits = 50 Credits Cloud Services = 10

BCompute Credits = 80 Credits Cloud Services = 5

CCompute Credits = 10 Credits Cloud Services = 9

DCompute Credits = 120 Credits Cloud Services = 10

ECompute Credits = 200 Credits Cloud Services = 26

Answer : B, D

Show Answer

Hide Answer

Question: 2

When a pipe is recreated using the CREATE on REPLAC PIPE command:

Select one.

AThe Pipe load history is reset to empty

BThe REFRESH parameter is set to TRUE

CPreviously loaded files will be ignored

DAll of the above

Answer : A

Show Answer

Hide Answer

Question: 3

What is the most granular object that the Time Travel retention can be defined on?

Select one.

AAccount

BDatabase

CSchema

DTable

Answer : D

Show Answer

Hide Answer

Question: 4

The number of queries that a Warehouse can concurrently process is determined by:

Choose 2 answers

AThe complexity of each query

BThe CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

CThe size of the data required for each query

DThe tool that s executing the query

Answer : A, C

Show Answer

Hide Answer

Question: 5

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

q5_SnowPro-Core