ExamGecko
Login
Home / Snowflake / DEA-C01 / List of questions
Ask Question

Snowflake DEA-C01 Practice Test - Questions Answers, Page 6

Add to Whishlist

List of questions

Question 51

Report Export Collapse

Can the same column be specified in both a Dynamic data masking policy signature and a row ac-cess policy signature at the same time?

Become a Premium Member for full access
  Unlock Premium Member

Question 52

Report Export Collapse

Which two Account usage views can be used for auditing Dynamic data masking purpose?

Become a Premium Member for full access
  Unlock Premium Member

Question 53

Report Export Collapse

Which of the below concepts/functions helps while implementing advanced Column-level Security?

Become a Premium Member for full access
  Unlock Premium Member

Question 54

Report Export Collapse

Select the Incorrect statement about External Functions in SnowFlake?

Become a Premium Member for full access
  Unlock Premium Member

Question 55

Report Export Collapse

Which are the Cloud Platforms that Support Calling an External Function?

Become a Premium Member for full access
  Unlock Premium Member

Question 56

Report Export Collapse

While creating External function, Which Database object required with at least ACCOUNTAD-MIN privileges?

Become a Premium Member for full access
  Unlock Premium Member

Question 57

Report Export Collapse

What are Invalid rules applicable when using stored procedure contains transaction?

Become a Premium Member for full access
  Unlock Premium Member

Question 58

Report Export Collapse

You can execute zero, one, or more transactions inside a stored procedure?

Become a Premium Member for full access
  Unlock Premium Member

Question 59

Report Export Collapse

Snowflake does not treat the inner transaction as nested; instead, the inner transaction is a separate transaction. What is term used to call these Transaction?

Become a Premium Member for full access
  Unlock Premium Member

Question 60

Report Export Collapse

Elon, a Data Engineer, needs to Split Semi-structured Elements from the Source files and load them as an array into Separate Columns.

Source File:

Become a Premium Member for full access
  Unlock Premium Member
Total 130 questions
Go to page: of 13
Open VPLUS File
Convert VPLUS to PDF

Related questions

Snowflake web interface can be used to create users with no passwords or remove passwords from existing users?
Select the correct usage statements with regards to SQL UDF?
Mark the Correct Statements: Statement 1. Snowflake's zero-copy cloning feature provides a convenient way to quickly take a "snapshot" of any table, schema, or database. Statement 2. Data Engineer can use zero-copy cloning feature for creating instant backups that do not incur any additional costs (until changes are made to the cloned object).
You as Data engineer might want to consider disabling auto-suspend for a warehouse if?
The COPY command supports several options for loading data files from a stage i.e.
Clones can be cloned, with no limitations on the number or iterations of clones that can be created (e.g. you can create a clone of a clone of a clone, and so on), which results in a n-level hierarchy of cloned objects, each with their own portion of shared and independent data storage?
Streams record the differences between two offsets. If a row is added and then updated in the current offset, what will be the value of METADATA^^SUPDATE Columns in this scenario?
Select the Incorrect statement about External Functions in SnowFlake?
For enabling non-ACCOUNTADMIN Roles to Perform Data Sharing Tasks, which two glob-al/account privileges snowflake provide?
Which are false statements about Star Schema?