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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 34

Add to Whishlist

List of questions

Question 331

Report Export Collapse

What is the MAXIMUM Time Travel retention period for a transient table?

O days
O days
1 day
1 day
7 days
7 days
90 days
90 days
Suggested answer: B
Explanation:

The maximum Time Travel retention period for a transient table in Snowflake is 1 day.This is the default and maximum duration for which Snowflake maintains the historical data for transient tables, allowing users to query data as it appeared at any point within the past 24 hours2.

asked 23/09/2024
IGNACIO CHICO TORRES
42 questions

Question 332

Report Export Collapse

Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

list @bronzestage;
list @bronzestage;
select * from directory(@bronzestage);
select * from directory(@bronzestage);
select metadata$filename from @bronzestage;
select metadata$filename from @bronzestage;
select * from table(information_schema.stage_directory_file_registration_history( stage name=>'bronzestage1));
select * from table(information_schema.stage_directory_file_registration_history( stage name=>'bronzestage1));
Suggested answer: B
Explanation:

The query that contains a Snowflake hosted file URL in a directory table for a stage named bronzestage isselect * from directory(@bronzestage).This query retrieves a list of all files on the stage along with metadata, including the Snowflake file URL for each file3.

asked 23/09/2024
DIEGO MORENO
42 questions

Question 333

Report Export Collapse

Which Snowflake edition enables data sharing only through Snowflake Support?

Virtual Private Snowflake
Virtual Private Snowflake
Business Critical
Business Critical
Enterprise
Enterprise
Standard
Standard
Suggested answer: A
Explanation:

The Snowflake edition that enables data sharing only through Snowflake Support is the Virtual Private Snowflake (VPS).By default, VPS does not permit data sharing outside of the VPS environment, but it can be enabled through Snowflake Support4.

asked 23/09/2024
James Williams
39 questions

Question 334

Report Export Collapse

When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?

When using a paid listing on the Snowflake Marketplace
When using a paid listing on the Snowflake Marketplace
When using a private listing on the Snowflake Marketplace
When using a private listing on the Snowflake Marketplace
When using a personalized listing on the Snowflake Marketplace
When using a personalized listing on the Snowflake Marketplace
When using a Direct Share with another account
When using a Direct Share with another account
Suggested answer: A
Explanation:

Snowsight automatically detects if a target account is in a different region and enables cross-cloud auto-fulfillment when using a paid listing on the Snowflake Marketplace.This feature allows Snowflake to manage the replication of data products to consumer regions as needed, without manual intervention1.

asked 23/09/2024
David Brun
40 questions

Question 335

Report Export Collapse

Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).

Java
Java
Javascript
Javascript
Scala
Scala
Python
Python
SQL
SQL
Suggested answer: B, E
Explanation:

User-Defined Function (UDF) handlers must be written inline for Javascript and SQL.These languages allow the UDF logic to be included directly within the SQL statement that creates the UDF2.

asked 23/09/2024
Cristian Bello Henriquez
36 questions

Question 336

Report Export Collapse

Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?

PARSE_JSON
PARSE_JSON
CHECK_JSON
CHECK_JSON
JSON_EXTRACT_PATH_TEXT
JSON_EXTRACT_PATH_TEXT
PARSE_XML
PARSE_XML
Suggested answer: A
Explanation:

The semi-structured data function that interprets an input string as a JSON document and produces a VARIANT value is PARSE_JSON.This function is used to parse a JSON formatted string and return it as a VARIANT data type, which can then be used for further processing within Snowflake3.

asked 23/09/2024
Albert Hidalgo Bassons
49 questions

Question 337

Report Export Collapse

Which items are considered schema objects in Snowflake? (Select TWO).

Pipe
Pipe
File format
File format
Resource monitor
Resource monitor
Storage integration
Storage integration
Virtual warehouse
Virtual warehouse
Suggested answer: A, B
Explanation:

In Snowflake, schema objects include Pipes and File formats.Pipes are used for continuous data loading, and File formats specify the format of data files used in loading and unloading operations within Snowflake

asked 23/09/2024
Balazs Jarmy
56 questions

Question 338

Report Export Collapse

What are benefits of using Snowpark with Snowflake? (Select TWO).

Snowpark uses a Spark engine to generate optimized SQL query plans.
Snowpark uses a Spark engine to generate optimized SQL query plans.
Snowpark automatically sets up Spark within Snowflake virtual warehouses.
Snowpark automatically sets up Spark within Snowflake virtual warehouses.
Snowpark does not require that a separate cluster be running outside of Snowflake.
Snowpark does not require that a separate cluster be running outside of Snowflake.
Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.
Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.
Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).
Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).
Suggested answer: C, D
Explanation:

Snowpark is designed to bring the data programmability to Snowflake, enabling developers to write code in familiar languages like Scala, Java, and Python. It allows for the execution of these codes directly within Snowflake's virtual warehouses, eliminating the need for a separate cluster.Additionally, Snowpark's compatibility with Spark allows users to leverage their existing Spark code with minimal changes1.

asked 23/09/2024
Alexander Ferrer
55 questions

Question 339

Report Export Collapse

If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?

60
60
91
91
120
120
121
121
Suggested answer: D
Explanation:

Snowflake's billing for virtual warehouses is per-second, with a minimum of 60 seconds for each time the warehouse is started or resumed. Therefore, if a warehouse runs for 61 seconds, it is billed for 61 seconds.If it is then shut down and restarted, running for an additional 30 seconds, it is billed for another 60 seconds (the minimum charge for a restart), totaling 121 seconds2

asked 23/09/2024
Rui Afonso
38 questions

Question 340

Report Export Collapse

Which transformation is supported by a COPY INTO <table> command?

Filter using a where clause
Filter using a where clause
Filter using a limit keyword
Filter using a limit keyword
Cast using a SELECT statement
Cast using a SELECT statement
Order using an ORDER BY clause
Order using an ORDER BY clause
Suggested answer: C
Explanation:

The COPY INTO <table> command in Snowflake supports transformations such as casting using a SELECT statement.This allows for the transformation of data types as the data is being loaded into the table, which can be particularly useful when the data types in the source files do not match the data types in the target table

asked 23/09/2024
Anna Panagiotidou
37 questions
Total 627 questions
Go to page: of 63