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

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

Add to Whishlist

List of questions

Question 111

Report Export Collapse

If the data retention period for a table is less than 90 days, and a stream has not been consumed, Snowflake temporarily extends this period to prevent it from going stale?

Become a Premium Member for full access
  Unlock Premium Member

Question 112

Report Export Collapse

Snowflake web interface can be used to create users with no passwords or remove passwords from existing users?

Become a Premium Member for full access
  Unlock Premium Member

Question 113

Report Export Collapse

Select the Correct statements with regard to using Federated authentication/SSO?

Become a Premium Member for full access
  Unlock Premium Member

Question 114

Report Export Collapse

Which property can be used with ALTER USER command to temporarily disable MFA for the user so that they can log in?

Become a Premium Member for full access
  Unlock Premium Member

Question 115

Report Export Collapse

Snowflake supports using key pair authentication for enhanced authentication security as an alternative to basic authentication (i.e. username and password). Select the list of SnowFlake Clients support the same? [Select All that Apply]

Become a Premium Member for full access
  Unlock Premium Member

Question 116

Report Export Collapse

Jackie, a Data engineer advised to his data team members about one of the Role highlighting fol-lows points:

Become a Premium Member for full access
  Unlock Premium Member

Question 117

Report Export Collapse

Which Role that is dedicated to user and role management only?

Become a Premium Member for full access
  Unlock Premium Member

Question 118

Report Export Collapse

By default, a newly-created Custom role is not assigned to any user, nor granted to any other role?

Become a Premium Member for full access
  Unlock Premium Member

Question 119

Report Export Collapse

UDTFs also called a table function, returns zero, one, or multiple rows for each input row?

Become a Premium Member for full access
  Unlock Premium Member

Question 120

Report Export Collapse

Which are supported Programming Languages for Creating UDTFs?

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?