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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 32

Add to Whishlist

List of questions

Question 311

Report Export Collapse

Which Snowflake URL type is used by directory tables?

File
File
Pre-signed
Pre-signed
Scoped
Scoped
Virtual-hosted style
Virtual-hosted style
Suggested answer: C
Explanation:

The Snowflake URL type used by directory tables is the scoped URL.This type of URL provides access to files in a stage with metadata, such as the Snowflake file URL, for each file

asked 23/09/2024
eswar raj
38 questions

Question 312

Report Export Collapse

For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

10
10
50
50
64
64
256
256
Suggested answer: D
Explanation:

For the ALLOWED VALUES tag property, the maximum number of possible string values for a single tag is 256.This allows for a wide range of values to be assigned to a tag when it is set on an object

asked 23/09/2024
Sam K
35 questions

Question 313

Report Export Collapse

What does Snowflake's search optimization service support?

External tables
External tables
Materialized views
Materialized views
Tables and views that are not protected by row access policies
Tables and views that are not protected by row access policies
Casts on table columns (except for fixed-point numbers cast to strings)
Casts on table columns (except for fixed-point numbers cast to strings)
Suggested answer: C
Explanation:

Snowflake's search optimization service supports tables and views that are not protected by row access policies.It is designed to improve the performance of certain types of queries on tables, including selective point lookup queries and queries on fields in VARIANT, OBJECT, and ARRAY (semi-structured) columns1.

asked 23/09/2024
Sanjiv Cumar
47 questions

Question 314

Report Export Collapse

What action can a user take to address query concurrency issues?

Enable the query acceleration service.
Enable the query acceleration service.
Enable the search optimization service.
Enable the search optimization service.
Add additional clusters to the virtual warehouse
Add additional clusters to the virtual warehouse
Resize the virtual warehouse to a larger instance size.
Resize the virtual warehouse to a larger instance size.
Suggested answer: C
Explanation:

To address query concurrency issues, a user can add additional clusters to the virtual warehouse.This allows for the distribution of queries across multiple clusters, reducing the load on any single cluster and improving overall query performance2.

asked 23/09/2024
DAVID LOPEZ MORGADO
46 questions

Question 315

Report Export Collapse

How long can a data consumer who has a pre-signed URL access data files using Snowflake?

Indefinitely
Indefinitely
Until the result_cache expires
Until the result_cache expires
Until the retention_time is met
Until the retention_time is met
Until the expiration time is exceeded
Until the expiration time is exceeded
Suggested answer: D
Explanation:

A data consumer who has a pre-signed URL can access data files using Snowflake until the expiration time is exceeded.The expiration time is set when the pre-signed URL is generated and determines how long the URL remains valid3.

asked 23/09/2024
Yusuf Sivrikaya
45 questions

Question 316

Report Export Collapse

Which pages are included in the Activity area of Snowsight? (Select TWO).

Contacts
Contacts
Sharing settings
Sharing settings
Copy History
Copy History
Query History
Query History
Automatic Clustering History
Automatic Clustering History
Suggested answer: D, E
Explanation:

The Activity area of Snowsight includes the Query History page, which allows users to monitor and view details about queries executed in their account, including performance data1.It also includes the Automatic Clustering History, which provides insights into the automatic clustering operations performed on tables2.

asked 23/09/2024
Easwari Lakshminarayanan
50 questions

Question 317

Report Export Collapse

Which kind of Snowflake table stores file-level metadata for each file in a stage?

Directory
Directory
External
External
Temporary
Temporary
Transient
Transient
Suggested answer: A
Explanation:

The kind of Snowflake table that stores file-level metadata for each file in a stage is a directory table.A directory table is an implicit object layered on a stage and stores file-level metadata about the data files in the stage3.

asked 23/09/2024
Danyail Storey
31 questions

Question 318

Report Export Collapse

Which parameter prevents streams on tables from becoming stale?

MAXDATAEXTENSIONTIMEINDAYS
MAXDATAEXTENSIONTIMEINDAYS
MTN_DATA_RETENTION_TTME_TN_DAYS
MTN_DATA_RETENTION_TTME_TN_DAYS
LOCK_TIMEOUT
LOCK_TIMEOUT
STALE_AFTER
STALE_AFTER
Suggested answer: A
Explanation:

The parameter that prevents streams on tables from becoming stale is MAXDATAEXTENSIONTIMEINDAYS.This parameter specifies the maximum number of days for which Snowflake can extend the data retention period for the table to prevent streams on the table from becoming stale4.

asked 23/09/2024
ERIK BURDETT
50 questions

Question 319

Report Export Collapse

A user needs to create a materialized view in the schema MYDB.MYSCHEM

Which statements will provide this access?
Which statements will provide this access?
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K'-'SCHEMA TO USER! ;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K'-'SCHEMA TO USER! ;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
Suggested answer: A
Explanation:

To provide a user with the necessary access to create a materialized view in a schema, the user must be granted a role that has the CREATE MATERIALIZED VIEW privilege on that schema.First, the role is granted to the user, and then the privilege is granted to the role

asked 23/09/2024
Mykhailo Vavilov
36 questions

Question 320

Report Export Collapse

Which objects together comprise a namespace in Snowflake? (Select TWO).

Account
Account
Database
Database
Schema
Schema
Table
Table
Virtual warehouse
Virtual warehouse
Suggested answer: B, C
Explanation:

In Snowflake, a namespace is comprised of a database and a schema.The combination of a database and schema uniquely identifies database objects within an account

asked 23/09/2024
George Kavvalakis
31 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).