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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 18

Add to Whishlist

List of questions

Question 171

Report Export Collapse

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

Become a Premium Member for full access
  Unlock Premium Member

Question 172

Report Export Collapse

In the Snowflake access control model, which entity owns an object by default?

Become a Premium Member for full access
  Unlock Premium Member

Question 173

Report Export Collapse

What is the minimum Snowflake edition required to use Dynamic Data Masking?

Become a Premium Member for full access
  Unlock Premium Member

Question 174

Report Export Collapse

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 175

Report Export Collapse

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

Which Snowflake feature will support this?

Become a Premium Member for full access
  Unlock Premium Member

Question 176

Report Export Collapse

A user has unloaded data from a Snowflake table to an external stage.

Which command can be used to verify if data has been uploaded to the external stage named my_stage?

Become a Premium Member for full access
  Unlock Premium Member

Question 177

Report Export Collapse

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 178

Report Export Collapse

What is true about sharing data in Snowflake? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 179

Report Export Collapse

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

Snowflake SnowPro Core image Question 179 74540 09232024004504000000

A user needs to extract the dealership information from the JSON.

How can this be accomplished?

Become a Premium Member for full access
  Unlock Premium Member

Question 180

Report Export Collapse

Which of the following significantly improves the performance of selective point lookup queries on a table?

Become a Premium Member for full access
  Unlock Premium Member
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).