Which Snowflake table objects can be shared with other accounts? (Select TWO).

User-Defined Table Functions (UDTFs)

How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.

Review the granted privileges to the database object.

Review the row access policy for the database object.

Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.

Query the REPLICATION USAGE HISTORY view in the ORGANIZATION USAGE schema.

How can a Snowflake user traverse semi-structured data?

Insert a colon (:) between the VARIANT column name and any first-level element.

Insert a colon (:) between the VARIANT column name and any second-level element.

Insert a double colon (: :) between the VARIANT column name and any first-level element.

Insert a double colon (: :) between the VARIANT column name and any second-level element.

What is the purpose of the Snowflake SPLIT TO_TABLE function?

To split a string and flatten the results into rows

To count the number of characters in a string

To split a string into an array of sub-strings

To split a string and flatten the results into rows

To split a string and flatten the results into columns

Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?

Multi-Factor Authentication (MFA)

A Snowflake account has activated federated authentication.What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?

The user will be unable to enter a password.

The user will encounter an error, and will not be able to log in.

The user will be able to log into Snowflake successfully.

After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.

What will prevent unauthorized access to a Snowflake account from an unknown source?

Multi-Factor Authentication (MFA)

Role-Based Access Control (RBAC)

What is the purpose of a Query Profile?

To profile a particular query to understand the mechanics of the query, its behavior, and performance.

To profile how many times a particular query was executed and analyze its u^age statistics over time.

To profile a particular query to understand the mechanics of the query, its behavior, and performance.

To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.

To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?

Virtual Private Snowflake Edition

What is a directory table in Snowflake?

An object layered on a stage that is used to store file-level metadata

A separate database object that is used to store file-level metadata

An object layered on a stage that is used to store file-level metadata

A database object with grantable privileges for unstructured data tasks

A Snowflake table specifically designed for storing unstructured files

Which Snowflake command can be used to unload the result of a query to a single file?

Use COPY INTO <internal stage> with SINGLE = TRUE followed by a GET command to download the file.

Use COPY INTO <external stage> followed by a GET command to download the file.

Use COPY INTO <internal stage> followed by a put command to download the file.

Use COPY INTO <internal stage> with SINGLE = TRUE followed by a GET command to download the file.

Use COPY INTO <external stage> with SINGLE = TRUE followed by a PUT command to download the file.

What factors impact storage costs in Snowflake? (Select TWO).

The cloud region used by the account

Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).

Bytes spilled to remote storage

How can a Snowflake user validate data that is unloaded using the COPY INTO <location> command?

Use the VALlDATlON_MODE - SQL statement.

Load the data into a relational table.

Use the VALlDATlON_MODE - SQL statement.

Use the validation mode = return rows statement.

Which feature of Snowflake's Continuous Data Protection (CDP) has associated costs?

Multi-Factor Authentication (MFA)

Which of the following SQL statements will list the version of the drivers currently being used?

Execute SELECT CURRENT_JDBC_VERSION() ; from SnowSQL

Execute SELECT CURRENT_ODBC_CLlENT(); from the Web Ul

Execute SELECT CURRENT_JDBC_VERSION() ; from SnowSQL

Execute SELECT CURRENT_CLIENT(); from an application

Execute SELECT CURRENT_VERSION (); from the Python Connector

When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).

USAGE on the specific tables in the database.

USAGE on the database and the schema containing the tables to share

USAGE on the specific tables in the database.

MODIFY on 1Mb specific tables in the database.

USAGE on the database and the schema containing the tables to share

OPEBATE on the database and the schema containing the tables to share.

When should a stored procedure be created with caller's rights?

When the stored procedure needs to run with the privileges of the role that called the stored procedure

When the caller needs to be prevented from viewing the source code of the stored procedure

When the caller needs to run a statement that could not execute outside of the stored procedure

When the stored procedure needs to run with the privileges of the role that called the stored procedure

When the stored procedure needs to operate on objects that the caller does not have privileges on

What happens to the privileges granted to Snowflake system-defined roles?

The privileges cannot be revoked.

The privileges can be revoked by an ACCOUNTADMIN.

The privileges can be revoked by an orgadmin.

The privileges can be revoked by any user-defined role with appropriate privileges.

Snowflake SnowPro Core Practice Test 11 - Free Online Exam Prep & Questions

Spam

Selling illegal goods, money scams etc.

Hate Speech

Serious attack on a group.

Harassment and bullying

Harassing an individual (including doxing)

Harmful activities

Threatening or glorifying violence or serious harm, including self-harm

Adult content (Consensual)

Nudity/Sexual content

Sexual exploitation and abuse (child safety)

Sexually explicit or suggestive imagery or writing involving minors

Sexual exploitation and abuse (adults and animals)

Sexually explicit or suggestive imagery or writing involving non-consenting adults or non-humans

Plagiarism

Reusing content without attribution (link and blockquotes)

Poorly written

Not in English or has very bad formatting, grammar, and spelling

Inappropriate credential

Author's credential is offensive, spam, or impersonation

Other

Ex. Illegal content, incomplete question...

Snowflake SnowPro Core Practice Test 11

Question

Snowflake SnowPro Core Practice Tests

Practice Tests