ExamGecko
Home / Snowflake / DEA-C01
Ask Question

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

Question list
Search

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?

YES
YES
NO
NO
Suggested answer: B
asked 23/09/2024
roberto gaccetta
34 questions

Question 52

Report
Export
Collapse

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

MASKING POLICIES
MASKING POLICIES
POLICY_REFERENCES
POLICY_REFERENCES
DYNAMIC MASKING POLICIES
DYNAMIC MASKING POLICIES
DYNAMIC POLICY_REFERENCES
DYNAMIC POLICY_REFERENCES
Suggested answer: A, B
asked 23/09/2024
Tuan Nguyen
41 questions

Question 53

Report
Export
Collapse

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

CURRENT_ROLE
CURRENT_ROLE
INVOKER_ROLE
INVOKER_ROLE
Role Hierarchy
Role Hierarchy
CURRENT_CLIENT
CURRENT_CLIENT
Suggested answer: A, B, C

Explanation:

Column-level Security supports using Context Functions in the conditions of the masking policy body to enforce whether a user has authorization to see data. To determine whether a user can see data in a given SQL statement, it is helpful to consider:

Masking policy conditions using CURRENT_ROLE target the role in use for the current session.

Masking policy conditions using INVOKER_ROLE target the executing role in a SQL statement.

Role hierarchy Determine if a specified role in a masking policy condition (e.g. ANALYST custom role) is a lower privilege role in the CURRENT_ROLE or INVOKER_ROLE role hierarchy. If so, then the role returned by the CURRENT_ROLE or INVOKER_ROLE functions inherits the privileges of the specified role.

asked 23/09/2024
Mike de Roo
29 questions

Question 54

Report
Export
Collapse

Select the Incorrect statement about External Functions in SnowFlake?

An external function is a type of UDF.
An external function is a type of UDF.
An external function does not contain its own code; instead, the external function calls code that is stored and executed outside Snowflake.
An external function does not contain its own code; instead, the external function calls code that is stored and executed outside Snowflake.
Inside Snowflake, the external function is stored as a API Integration object.
Inside Snowflake, the external function is stored as a API Integration object.
Inside Snowflake, the external function is stored as a database object that contains in-formation that Snowflake uses to call the remote service.
Inside Snowflake, the external function is stored as a database object that contains in-formation that Snowflake uses to call the remote service.
Suggested answer: C
asked 23/09/2024
Rebecca Gillespie
40 questions

Question 55

Report
Export
Collapse

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

GCP
GCP
AWS & AZURE
AWS & AZURE
AWS only
AWS only
AWS,GCP,AZURE
AWS,GCP,AZURE
Suggested answer: D
asked 23/09/2024
JP Brune
39 questions

Question 56

Report
Export
Collapse

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

STORAGE Integration
STORAGE Integration
SECURITY Integration
SECURITY Integration
API Integration
API Integration
None of the above required.
None of the above required.
Suggested answer: C
asked 23/09/2024
Rehan Malik
51 questions

Question 57

Report
Export
Collapse

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

A transaction can be inside a stored procedure, or a stored procedure can be inside a transaction.
A transaction can be inside a stored procedure, or a stored procedure can be inside a transaction.
You cannot start a transaction before calling the stored procedure, then complete the transaction inside the stored procedure.
You cannot start a transaction before calling the stored procedure, then complete the transaction inside the stored procedure.
You cannot start a transaction inside the stored procedure, then complete the transac-tion after returning from the procedure.
You cannot start a transaction inside the stored procedure, then complete the transac-tion after returning from the procedure.
If a transaction is started inside a stored procedure and is still active when the stored procedure finishes, then an error occurs, and the transaction is rolled back.
If a transaction is started inside a stored procedure and is still active when the stored procedure finishes, then an error occurs, and the transaction is rolled back.
A transaction inside a stored procedure can include a call to another stored procedure that contains a transaction.
A transaction inside a stored procedure can include a call to another stored procedure that contains a transaction.
All Rules are Applicable.
All Rules are Applicable.
Suggested answer: F
asked 23/09/2024
Sam Krupesh
38 questions

Question 58

Report
Export
Collapse

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

TRUE
TRUE
FALSE
FALSE
Suggested answer: A
asked 23/09/2024
Katia Santa Olalla S
32 questions

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?

Scoped transactions
Scoped transactions
Inner Transaction
Inner Transaction
Nested Scope Transaction
Nested Scope Transaction
Atomic Transaction
Atomic Transaction
Enclosed Transaction
Enclosed Transaction
Suggested answer: A
asked 23/09/2024
Patrick Cheung
37 questions

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:

+----------------------------------------------------------------------+
+----------------------------------------------------------------------+
| $1 |
| $1 |
|----------------------------------------------------------------------|
|----------------------------------------------------------------------|
| {"mac_address": {"host1": "197.128.1.1","host2": "197.168.0.1"}}, |
| {"mac_address": {"host1": "197.128.1.1","host2": "197.168.0.1"}}, |
| {"mac_address": {"host1": "197.168.2.1","host2": "197.168.3.1"}} |
| {"mac_address": {"host1": "197.168.2.1","host2": "197.168.3.1"}} |
+----------------------------------------------------------------------+ Output: Splitting the Machine Address as below.
+----------------------------------------------------------------------+ Output: Splitting the Machine Address as below.
COL1 | COL2 |
COL1 | COL2 |
|----------+----------|
|----------+----------|
| [ | [ |
| [ | [ |
| "197", | "197", |
| "197", | "197", |
| "128", | "168", |
| "128", | "168", |
| "1", | "0", |
| "1", | "0", |
| "1" | "1" |
| "1" | "1" |
| ] | ] |
| ] | ] |
| [ | [ |10. | "197", | "197", |11. | "168", | "168", |12. | "2", | "3", |13. | "1" | "1" |14. | ] | ]Which SnowFlake Function can Elon use to transform this semi structured data in the output format?
| [ | [ |10. | "197", | "197", |11. | "168", | "168", |12. | "2", | "3", |13. | "1" | "1" |14. | ] | ]Which SnowFlake Function can Elon use to transform this semi structured data in the output format?
CONVERT_TO_ARRAY
CONVERT_TO_ARRAY
SPLIT
SPLIT
GROUP_BY_CONNECT
GROUP_BY_CONNECT
NEST
NEST
Suggested answer: B
asked 23/09/2024
Mekmek Kh
37 questions
Total 130 questions
Go to page: of 13