ExamGecko
Login
Home / Snowflake / SnowPro Core / List of questions
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 33

List of questions

Question 321

Report
Export
Collapse

Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.

How does Snowflake recommend resolving this issue?

Scale up the existing warehouse.
Scale up the existing warehouse.
Create separate warehouses for each user.
Create separate warehouses for each user.
Create separate warehouses for each workload.
Create separate warehouses for each workload.
Stop loading and querying data at the same time.
Stop loading and querying data at the same time.
Suggested answer: C

Explanation:

Snowflake recommends creating separate warehouses for each workload to resolve performance issues caused by shared virtual warehouses.This ensures that the resources are not being overutilized by one user's activities, thereby affecting the performance of another user's activities4.

asked 23/09/2024
SAI CHARAN TANGELLA
35 questions

Question 322

Report
Export
Collapse

How long does Snowflake retain information in the ACCESS HISTORY view?

7 days
7 days
14 days
14 days
28 days
28 days
365 days
365 days
Suggested answer: D

Explanation:

Snowflake retains information in the ACCESS HISTORY view for 365 days.This allows users to query the access history of Snowflake objects within the last year1.

asked 23/09/2024
Nogueira Elder
36 questions

Question 323

Report
Export
Collapse

A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?

The data from the permanent table.
The data from the permanent table.
The data from the temporary table.
The data from the temporary table.
An error stating that the view could not be compiled.
An error stating that the view could not be compiled.
An error stating that the referenced object could not be uniquely identified.
An error stating that the referenced object could not be uniquely identified.
Suggested answer: A

Explanation:

When a view is defined on a permanent table, and a temporary table with the same name is created in the same schema, the query from the view will return the data from the permanent table.Temporary tables are session-specific and do not affect the data returned by views defined on permanent tables2.

asked 23/09/2024
CRISTIAN FONSECA
38 questions

Question 324

Report
Export
Collapse

What is used to diagnose and troubleshoot network connections to Snowflake?

SnowCD
SnowCD
Snowpark
Snowpark
Snowsight
Snowsight
SnowSQL
SnowSQL
Suggested answer: A

Explanation:

SnowCD (Snowflake Connectivity Diagnostic Tool) is used to diagnose and troubleshoot network connections to Snowflake.It runs a series of connection checks to evaluate the network connection to Snowflake

asked 23/09/2024
Gishi Anurag
30 questions

Question 325

Report
Export
Collapse

Which REST API can be used with unstructured data?

inscrtFilcs
inscrtFilcs
insertReport
insertReport
GET /api/tiles/
GET /api/tiles/
loadHistoryScan
loadHistoryScan
Suggested answer: C

Explanation:

The REST API used with unstructured data in Snowflake is GET /api/files/, which retrieves (downloads) a data file from an internal or external stage4.

asked 23/09/2024
jordi vanderpooten
34 questions

Question 326

Report
Export
Collapse

What column type does a Kafka connector store formatted information in a single column?

ARRAY
ARRAY
OBJECT
OBJECT
VARCHAR
VARCHAR
VARIANT
VARIANT
Suggested answer: D

Explanation:

The Kafka connector stores formatted information in a single column of type VARIANT.This column type is used to store semi-structured data like JSON or Avro, which allows for flexibility in the data structure

asked 23/09/2024
shridhar deshpande
40 questions

Question 327

Report
Export
Collapse

When unloading data to an external stage, what is the MAXIMUM file size supported?

1 GB
1 GB
5 GB
5 GB
10 GB
10 GB
16 GB
16 GB
Suggested answer: B

Explanation:

When unloading data to an external stage, the maximum file size supported is 5 GB.This limit ensures efficient data transfer and management within Snowflake's architecture

asked 23/09/2024
Lyboth Ntsana
43 questions

Question 328

Report
Export
Collapse

By definition, a secure view is exposed only to users with what privilege?

IMPORT SHARE
IMPORT SHARE
OWNERSHIP
OWNERSHIP
REFERENCES
REFERENCES
USAGE
USAGE
Suggested answer: B

Explanation:

A secure view in Snowflake is exposed only to users with the OWNERSHIP privilege.This privilege ensures that only authorized users who own the view, or roles that include ownership, can access the secure view

asked 23/09/2024
Lucie Loisel
39 questions

Question 329

Report
Export
Collapse

What is a characteristic of the Snowflake Query Profile?

It can provide statistics on a maximum number of 100 queries per week.
It can provide statistics on a maximum number of 100 queries per week.
It provides a graphic representation of the main components of the query processing.
It provides a graphic representation of the main components of the query processing.
It provides detailed statistics about which queries are using the greatest number of compute resources.
It provides detailed statistics about which queries are using the greatest number of compute resources.
It can be used by third-party software using the Query Profile API.
It can be used by third-party software using the Query Profile API.
Suggested answer: B

Explanation:

The Snowflake Query Profile provides a graphic representation of the main components of the query processing.This visual aid helps users understand the execution details and performance characteristics of their queries4.

asked 23/09/2024
ACHILLE CARROLL
43 questions

Question 330

Report
Export
Collapse

What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).

Bytes spilled to local cache.
Bytes spilled to local cache.
Bytes spilled to local storage.
Bytes spilled to local storage.
Bytes spilled to remote cache.
Bytes spilled to remote cache.
Bytes spilled to remote storage.
Bytes spilled to remote storage.
Bytes spilled to remote metastore.
Bytes spilled to remote metastore.
Suggested answer: A, B

Explanation:

In a Query Profile, the statistical information that indicates a query is too large to fit in memory includes bytes spilled to local cache and bytes spilled to local storage.These metrics suggest that the working data set of the query exceeded the memory available on the warehouse nodes, causing intermediate results to be written to disk

asked 23/09/2024
Edwin Daneel
32 questions
Total 627 questions
Go to page: of 63
Open VPLUS File
Convert VPLUS to PDF

Related questions

What is a key feature of Snowflake architecture?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
How is unstructured data retrieved from data storage?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
A materialized view should be created when which of the following occurs? (Choose two.)
What happens when a virtual warehouse is resized?
How can a Snowflake user traverse semi-structured data?
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
User-level network policies can be created by which of the following roles? (Select TWO).