Snowflake SnowPro-Core Practice Test Pdf Exam Material [Q149-Q163]

NEW QUESTION 149
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

Pipes

Streams

Tasks

Procedures

NEW QUESTION 150
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

VIEWS_HISTORY

OBJECT_HISTORY

ACCESS_HISTORY

LOGIN_HISTORY

NEW QUESTION 151
True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

True

False

NEW QUESTION 152
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

The table contains a column that has very low cardinality

DML statements that are being issued against the table are blocked

The table has a small number of micro-partitions

Queries on the table are running slower than expected

The clustering depth for the table is large

NEW QUESTION 153
What is the recommended compressed file size range for continuous data loads using Snowpipe?

8-16 MB

16-24 MB

10-99 MB

100-250 MB

NEW QUESTION 154
True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

True

False

NEW QUESTION 155
True or False: The COPY command must specify a File Format in order to execute.

True

False

NEW QUESTION 156
What technique does Snowflake use to limit the number of micro-partitions scanned by each query?

B-tree

Indexing

Map reduce

Pruning

NEW QUESTION 157
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

SCIM

Federated authentication

TLS 1.2

Key-pair authentication

OAuth

OCSP authentication

NEW QUESTION 158
Which services does the Snowflake Cloud Services layer manage? (Choose two.)

Compute resources

Query execution

Authentication

Data storage

Metadata

NEW QUESTION 159
Which formats are supported for unloading data from Snowflake?
Choose 2 answers

Delimited (CSV, TSV, etc.)

Avro

JSON

ORC

NEW QUESTION 160
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
Select one.

INITTIALLY_SUSPENDED = TRUE/FALSE

START_AFTCR_CREATE = TRUE/FALSE

START_TTIME = 60 // (seconds from now)

START.TIME = CURRENT.DATE()

NEW QUESTION 161
Which Snowflake partner specializes in data catalog solutions?

Alation

DataRobot

dbt

Tableau

NEW QUESTION 162
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

Scaling out adds clusters of varying sizes to a virtual warehouse.

Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

Scaling up resizes a virtual warehouse so it can handle more complex workloads.

Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

NEW QUESTION 163
How would a user execute a series of SQL statements using a task?

Include 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 ..

A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask …. AS call stored_proc1(); call stored_proc2();

Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask …. AS call stored_proc_multiple_statements_inside();

Create 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 task1, task2, etc. sequentially.

Snowflake SnowPro-Core Practice Test Pdf Exam Material [Q149-Q163]

Leave a Reply Cancel reply

SnowPro-Core Practice Tests

Related Certifications

Recent Posts

Categories

Archives