Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. SnowPro-Core - SnowPro Core Certification Exam

SnowPro-Core Exam Dumps - SnowPro Core Certification Exam

Searching for workable clues to ace the Snowflake SnowPro-Core Exam? You’re on the right place! ExamCert has realistic, trusted and authentic exam prep tools to help you achieve your desired credential. ExamCert’s SnowPro-Core PDF Study Guide, Testing Engine and Exam Dumps follow a reliable exam preparation strategy, providing you the most relevant and updated study material that is crafted in an easy to learn format of questions and answers. ExamCert’s study tools aim at simplifying all complex and confusing concepts of the exam and introduce you to the real exam scenario and practice it with the help of its testing engine and real exam dumps

Go to page:
Question # 153

What does the LATERAL modifier for the FLATTEN function do?

A.

Casts the values of the flattened data

B.

Extracts the path of the flattened data

C.

Joins information outside the object with the flattened data

D.

Retrieves a single instance of a repeating element in the flattened data

Full Access
Question # 154

What is the purpose of the Snowflake SPLIT TO_TABLE function?

A.

To count the number of characters in a string

B.

To split a string into an array of sub-strings

C.

To split a string and flatten the results into rows

D.

To split a string and flatten the results into columns

Full Access
Question # 155

What is the primary purpose of a directory table in Snowflake?

A.

To store actual data from external stages

B.

To automatically expire file URLs for security

C.

To manage user privileges and access control

D.

To store file-level metadata about data files in a stage

Full Access
Question # 156

When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

A.

1 hour

B.

2 hours

C.

4 hours

D.

8 hours

Full Access
Question # 157

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.

Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

A.

CREATE TABLE <title_name> LIKE TABLE_A;

B.

CREATE VIEW <view_name> AS SELECT * FROM TABLE_A;

C.

CREATE TABLE <title_name> AS SELECT * FROM TABLE_A;

D.

CREATE MATERIALIZED VIEW <view name> AS SELECT * FROM TABLE A;

Full Access
Question # 158

What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'

A.

Views

B.

Materialized views

C.

Tables

D.

External tables

E.

Future grants

Full Access
Question # 159

Which Snowflake role can manage any object grant globally, including modifying and revoking grants?

A.

USERADMIN

B.

ORGADMIN

C.

SYSADMIN

D.

SECURITYADMIN

Full Access
Question # 160

Which Snowflake function will parse a JSON-null into a SQL-null?

A.

TO_CHAR

B.

TO_VARIANT

C.

TO_VARCHAR

D.

STRIP NULL VALUE

Full Access
Go to page:

Hot Exams

PCNSE Dumps
AZ-900 Dumps
200-301 Dumps
350-401 Dumps
350-701 Dumps
AZ-104 Dumps
CS0-003 Dumps
N10-009 Dumps
SY0-701 Dumps
CAS-005 Dumps
PT0-003 Dumps
ZDTA Dumps