Home / Snowflake / DEA-C01

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

Question list

List of questions

Question 51

(0)

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?

Question 52

(0)

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

Question 53

(0)

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

Question 54

(0)

Select the Incorrect statement about External Functions in SnowFlake?

Question 55

(0)

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

Question 56

(0)

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

Question 57

(0)

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

Question 58

(0)

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

Question 59

(0)

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?

Question 60

(0)

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:

Question 51

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

Show Answer Comment (0)

Question 52

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

MASKING POLICIES

POLICY_REFERENCES

DYNAMIC MASKING POLICIES

DYNAMIC POLICY_REFERENCES

Show Answer Comment (0)

Question 53

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

CURRENT_ROLE

INVOKER_ROLE

Role Hierarchy

CURRENT_CLIENT

Show Answer Comment (0)

Question 54

Select the Incorrect statement about External Functions in SnowFlake?

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.

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.

Show Answer Comment (0)

Question 55

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

GCP

AWS & AZURE

AWS only

AWS,GCP,AZURE

Show Answer Comment (0)

Question 56

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

STORAGE Integration

SECURITY Integration

API Integration

None of the above required.

Show Answer Comment (0)

Question 57

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.

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.

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.

All Rules are Applicable.

Show Answer Comment (0)

Question 58

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

TRUE

FALSE

Show Answer Comment (0)

Question 59

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

Inner Transaction

Nested Scope Transaction

Atomic Transaction

Enclosed Transaction

Show Answer Comment (0)

Question 60

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 |

|----------------------------------------------------------------------|

| {"mac_address": {"host1": "197.128.1.1","host2": "197.168.0.1"}}, |

| {"mac_address": {"host1": "197.168.2.1","host2": "197.168.3.1"}} |

+----------------------------------------------------------------------+ Output: Splitting the Machine Address as below.

COL1 | COL2 |

|----------+----------|

| [ | [ |

| "197", | "197", |

| "128", | "168", |

| "1", | "0", |

| "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?

CONVERT_TO_ARRAY

SPLIT

GROUP_BY_CONNECT

NEST

Show Answer Comment (0)

Total 130 questions