[Jul 02, 2022] Get to the Top with SnowPro-Core Practice Exam Questions [Q83-Q107]

Rate this post

[Jul 02, 2022] Get to the Top with SnowPro-Core Practice Exam Questions

Use Real SnowPro-Core Dumps Free Sample Questions and Practice Test Engine

NEW QUESTION 83
Snowflake is designed for which type of workloads? (Choose two.)

OLAP (Analytics) workloads

OLTP (Transactional) workloads

Concurrent workloads

On-premise workloads

NEW QUESTION 84
In which layer of its architecture does Snowflake store its metadata statistics?

Storage Layer

Compute Layer

Database Layer

Cloud Services Layer

Explanation/Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/

NEW QUESTION 85
True or False: Users are able to see the result sets of queries executed by other users that share their same role.

True

False

NEW QUESTION 86
Which of the following statements is true of Snowflake micro-partitioning?

Micro-partitioning has been known to introduce data skew

Micro-partitioning: requires a partitioning schema to be defined up front

Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded

Micro-partitioning can be disabled within a Snowflake account

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

The tables are now orphaned

The user that deleted the role

SYSADMIN

The assumed role that dropped the role

NEW QUESTION 88
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

128

Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

NEW QUESTION 89
True or False: Pipes can be suspended and resumed.

True

False

NEW QUESTION 90
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

True

False

NEW QUESTION 91
True or False: It is possible to unload structured data to semi-structured formats such as JSON and Parquet.

True

False

Explanation/Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

NEW QUESTION 92
How would you execute a series of SQL statements using 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 you should sequence stored procedures calls in the task definition CREATE TASK mytask…. AS call stored_prc1(); call stored_proc2t);

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 task 1, task 2 sequentially.

NEW QUESTION 93
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

Scaling rhythmically

Scaling max

Scaling out

Scaling Up

NEW QUESTION 94
Which of the following commands sets the Virtual Warehouse for a session?

COPT WAREHOUSE FROM <<Config file> ;

SET warehouse = <<warehouse name>>;

USE WAREHOUSE <<warehouse name>>;

USE VIRTUAL_WAREHOUSE <<warehouse name>>;

NEW QUESTION 95
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

True

False

NEW QUESTION 96
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?
(Choose all that apply.)

Growth of storage and compute are tightly coupled together

Storage expands without the requirement to add more compute

Compute can be scaled up or down without the requirement to add more storage

Multiple compute clusters can access stored data without contention

Reference:
separate-storage-and-compute-65d2dffd450f

NEW QUESTION 97
True or False: During data unloading, only JSON and CSV files can be compressed.

True

False

NEW QUESTION 98
Which of the following statements is true of data loading?
Select one.

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

The “deal file size for loading is 16MB to match micro-partition size

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

NEW QUESTION 99
What is the minimum Snowflake edition that provides data sharing?

Standard

Premier

Enterprise

Business Critical Edition

NEW QUESTION 100
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

True

False

NEW QUESTION 101
The Query History in the Snowflake Web Interface (UI) is kept for approximately:

60 minutes

24 hours

14 days

30 days

1 year

NEW QUESTION 102
The PUT command: (Choose two.)

Automatically creates a File Format object

Automatically uses the last Stage created

Automatically compresses files using Gzip

Automatically encrypts files

NEW QUESTION 103
How many shares can be consumed by single Data Consumer?

100, but can be increased by contacting support

Unlimited

NEW QUESTION 104
Which type of table corresponds to a single Snowflake session?

Temporary

Transient

Provisional

Permanent

NEW QUESTION 105
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)

JDBC

SnowSQL

Snowflake Web Interface (UI)

ODBC

Python

D18912E1457D5D1DDCBD40AB3BF70D5D

NEW QUESTION 106
Which of the following statements would be used to export/unload data from Snowflake?

COPY INTO @slage

EXPORT TO @stage

INSERT INTO @stage

EXPORT_TO_STAGE(stage = > @Wage, select = > ‘select * from t1);

NEW QUESTION 107
Which of the following statements is true of data loading?
Select one.

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

The “deal file size for loading is 16MB to match micro-partition size

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

Loading …