ExamGecko
Home Home / Snowflake / DEA-C01

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

Question list
Search
Search

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?

A.
TRUE
A.
TRUE
Answers
B.
FALSE
B.
FALSE
Answers
Suggested answer: B

Explanation:

If the data retention period for a table is less than 14 days, and a stream has not been consumed,

Snowflake temporarily extends this period to prevent it from going stale. The period is extended to the stream's offset, up to a maximum of 14 days by default, regardless of the Snowflake edition for your account. The maximum number of days for which Snowflake can extend the data retention period is determined by the MAX_DATA_EXTENSION_TIME_IN_DAYS parameter value. When the stream is consumed, the extended data retention period is reduced to the default period for the table.

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

A.
TRUE
A.
TRUE
Answers
B.
FALSE
B.
FALSE
Answers
Suggested answer: B

Explanation:

You cannot use the Snowflake web interface to create users with no passwords or remove passwords from existing users. You must use CREATE USER or ALTER USER command instead.

Also If you create a user with no password (or alter an existing user and remove their password), this effectively disables Snowflake authentication for the user. Without a password in Snowflake, a user cannot log in using Snowflake authentication and must use federated authentication instead.

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

A.
Snowflake supports using MFA in conjunction with SSO to provide additional levels of security.
A.
Snowflake supports using MFA in conjunction with SSO to provide additional levels of security.
Answers
B.
Snowflake supports multiple audience values (i.e. Audience or Audience Restriction Fields) in the SAML 2.0 assertion from the identity provider to Snowflake.
B.
Snowflake supports multiple audience values (i.e. Audience or Audience Restriction Fields) in the SAML 2.0 assertion from the identity provider to Snowflake.
Answers
C.
Snowflake supports SSO with Private Connectivity to the Snowflake Service for Snow-flake accounts on Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform.
C.
Snowflake supports SSO with Private Connectivity to the Snowflake Service for Snow-flake accounts on Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform.
Answers
D.
Snowflake supports using SSO with organizations, and you can use the corresponding URL in the SAML2 security integration.
D.
Snowflake supports using SSO with organizations, and you can use the corresponding URL in the SAML2 security integration.
Answers
Suggested answer: A, B, C, D

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

A.
HOURS_TO_BYPASS_MFA
A.
HOURS_TO_BYPASS_MFA
Answers
B.
SECS_TO_BYPASS_MFA
B.
SECS_TO_BYPASS_MFA
Answers
C.
MINS_TO_SKIP_MFA
C.
MINS_TO_SKIP_MFA
Answers
D.
MINS_TO_BYPASS_MFA
D.
MINS_TO_BYPASS_MFA
Answers
Suggested answer: D

Explanation:

You can use the following properties for the ALTER USER command to perform these tasks:

MINS_TO_BYPASS_MFA

Specifies the number of minutes to temporarily disable MFA for the user so that they can log in. After the time passes, MFA is enforced and the user cannot log in without the temporary token generated by the Duo Mobile application.

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]

A.
Go Driver
A.
Go Driver
Answers
B.
Node.js
B.
Node.js
Answers
C.
SnowFlake Connector for Spark
C.
SnowFlake Connector for Spark
Answers
D.
SnowSQL
D.
SnowSQL
Answers
E.
SnowCD
E.
SnowCD
Answers
Suggested answer: A, B, C, D

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

A.
Avoid Using the <?> Role for Automated Scripts
A.
Avoid Using the <?> Role for Automated Scripts
Answers
B.
Avoid Using the <?> Role to Create Objects Which System defined or Custom Role She is mentioning?
B.
Avoid Using the <?> Role to Create Objects Which System defined or Custom Role She is mentioning?
Answers
C.
SYSADMIN
C.
SYSADMIN
Answers
D.
SECURITYADMIN
D.
SECURITYADMIN
Answers
E.
CUSTOM Role
E.
CUSTOM Role
Answers
F.
USERADMIN
F.
USERADMIN
Answers
G.
ACCOUNTADMIN
G.
ACCOUNTADMIN
Answers
Suggested answer: E

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

A.
ORGADMIN
A.
ORGADMIN
Answers
B.
SECURITYADMIN
B.
SECURITYADMIN
Answers
C.
USERADMIN
C.
USERADMIN
Answers
D.
SYSADMIN
D.
SYSADMIN
Answers
E.
PUBLIC
E.
PUBLIC
Answers
Suggested answer: C

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

A.
TRUE
A.
TRUE
Answers
B.
FALSE
B.
FALSE
Answers
Suggested answer: A

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

A.
YES
A.
YES
Answers
B.
NO
B.
NO
Answers
Suggested answer: A

Explanation:

UDFs may be scalar or tabular.

A scalar function returns one output row for each input row. The returned row consists of a single column/value.

A tabular function, also called a table function, returns zero, one, or multiple rows for each input row.

A tabular UDF is defined by specifying a return clause that contains the TABLE keyword and specifies the names and data types of the columns in the table results. Tabular UDFs are often called UDTFs (user-defined table functions) or table UDFs.

Which are supported Programming Languages for Creating UDTFs?

A.
Python
A.
Python
Answers
B.
Node.javascript
B.
Node.javascript
Answers
C.
Javascript
C.
Javascript
Answers
D.
Java
D.
Java
Answers
E.
Perl
E.
Perl
Answers
Suggested answer: A, C, D
Total 130 questions
Go to page: of 13