Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

SnowPro Core > Chapter 4: Loading Data > Flashcards

Chapter 4: Loading Data Flashcards

1
Q

True or False: Snowpipe is designed to load small volumes of data that is arriving continuously.

True
False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
1
Q

Which of the following features in Snowflake allows creating tables through which you can query data in an external stage without loading it first?

Materialized views
External tables
Snowpipe
COPY

A

External tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which of the following statements are true for external tables? (Choose three.)

External tables can be joined with other tables.
Views can be created on external tables.
Update queries can be run on external tables.
External tables are read-only.

A

External tables can be joined with other tables.
Views can be created on external tables.
External tables are read-only.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which of the following statements are true for Snowpipe? (Choose two.)

Snowpipe uses an active virtual warehouse to load data.
Snowpipe makes use of Snowflake’s serverless computing resources.
Snowflake automatically scales up and down the Snowpipe resource.
Snowpipe’s compute resources are managed through a virtual warehouse that you must expand

A

Snowpipe makes use of Snowflake’s serverless computing resources.
Snowflake automatically scales up and down the Snowpipe resource.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which one of the following data loading methods uses virtual warehouse resources? (Choose all that apply.)

Loading data using COPY command through an external stage
Loading data using COPY command through an internal stage
Data loading through Snowpipe
Unloading data to an external stage using the COPY command

A

Loading data using COPY command through an external stage
Loading data using COPY command through an internal stage
Unloading data to an external stage using the COPY command

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which of the following is true about Snowpipe? (Choose two.)

The cost of Snowpipe is calculated and billed separately from the cost of virtual warehouse use.
Snowpipe utilizes shared virtual warehouse computational resources for processing.
Snowpipe is serverless and so does not require virtual warehouse resources.
Snowpipe consumption costs are included in the virtual warehouse compute.

A

The cost of Snowpipe is calculated and billed separately from the cost of virtual warehouse use.
Snowpipe is serverless and so does not require virtual warehouse resources.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which of the following can be used to load data using the COPY command? (Choose two.)

External stage
Internal stage
Web pages
REST APIs

A

External stage
Internal stage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Snowflake supports which semi-structured file formats? (Choose all that apply.)

Parquet
JSON
HTML
Avro
XML

A

Parquet
JSON
Avro
XML

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

When exporting or unloading data from Snowflake, which of the following file formats are supported for unloading? (Choose all that apply.)
Avro
ORC
XML
CSV
Parquet

A

CSV
Parquet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is the amount of uncompressed data that a column of VARIANT data type can store for a single row?

8 MB
16 MB
Unlimited
32 MB

A

16 MB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

The load metadata for a table expires after how many days?
64 days
32 days
Never
256 days

A

64 days

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which of the following can be a target location when using the COPY INTO <location> command? (Choose two.)</location>

A named internal stage
A named external stage
A local folder
Cloud storage location, such as an S3 bucket

A

A named internal stage
A named external stage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which of the following statements are true regarding data loading? (Choose all that apply.)

GET is used to download files from a Snowflake internal stage to a local folder.
PUT is used to upload files into a Snowflake internal stage from a local folder.
REMOVE can be used to remove files from internal stages and external stages.
GET and PUT cannot be executed from the Worksheets view.
LOAD is used to load files into a table from an internal stage.

A

GET is used to download files from a Snowflake internal stage to a local folder.
PUT is used to upload files into a Snowflake internal stage from a local folder.
REMOVE can be used to remove files from internal stages and external stages.
GET and PUT cannot be executed from the Worksheets view.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which of the following transformations are not supported by the COPY command? (Choose three.)

JOIN
GROUP BY
FLATTEN
CONCAT
CAST

A

JOIN
GROUP BY
FLATTEN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Snowpipe supports loading data continuously. Snowpipe can load data from which of the following objects? (Choose two.)

External stages
Internal stages
Temporary tables
Transient tables

A

External stages
Internal stages

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

True or False: When you use the PUT command, the data is encrypted on the client machine before uploading it.

False
True

A

True

16
Q

What is the recommended file size to optimize the load process?

100–250 MB
25–50 MB
5–10 MB
500 MB

A

100–250 MB

SnowPro Core (10 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions