Snowflake DEA-C01 Exam Practice Test Instant Access

Question 1

A secure function returns data coming through an inbound share

What will happen if a Data Engineer tries to assign usage privileges on this function to an outbound share?

AAn error will be returned because the Engineer cannot share data that has already been shared

BAn error will be returned because only views and secure stored procedures can be shared

CAn error will be returned because only secure functions can be shared with inbound shares

DThe Engineer will be able to share the secure function with other accounts

Answer : A

An error will be returned because the Engineer cannot share data that has already been shared. A secure function is a Snowflake function that can access data from an inbound share, which is a share that is created by another account and consumed by the current account. A secure function can only be shared with an inbound share, not an outbound share, which is a share that is created by the current account and shared with other accounts. This is to prevent data leakage or unauthorized access to the data from the inbound share.

Question 2

Assuming that the session parameter USE_CACHED_RESULT is set to false, what are characteristics of Snowflake virtual warehouses in terms of the use of Snowpark?

ACreating a DataFrame from a table will start a virtual warehouse

BCreating a DataFrame from a staged file with the read () method will start a virtual warehouse

CTransforming a DataFrame with methods like replace () will start a virtual warehouse -

DCalling a Snowpark stored procedure to query the database with session, call () will start a virtual warehouse

Answer : A

Creating a DataFrame from a table will start a virtual warehouse because it requires reading data from Snowflake. The other options will not start a virtual warehouse because they either operate on local data or use an existing session to query Snowflake.

Question 3

A Data Engineer wants to centralize grant management to maximize security. A user needs ownership on a table m a new schema However, this user should not have the ability to make grant decisions

What is the correct way to do this?

AGrant ownership to the user on the table

BRevoke grant decisions from the user on the table

CRevoke grant decisions from the user on the schema.

DAdd the with managed access parameter on the schema

Answer : D

The with managed access parameter on the schema enables the schema owner to control the grant and revoke privileges on the objects within the schema. This way, the user who owns the table cannot make grant decisions, but only the schema owner can. This is the best way to centralize grant management and maximize security.

Question 4

Which system role is recommended for a custom role hierarchy to be ultimately assigned to?

AACCOUNTADMIN

BSECURITYADMIN

CSYSTEMADMIN

DUSERADMIN

Answer : B

The system role that is recommended for a custom role hierarchy to be ultimately assigned to is SECURITYADMIN. This role has the manage grants privilege on all objects in an account, which allows it to grant access privileges to other roles or revoke them as needed. This role can also create or modify custom roles and assign them to users or other roles. By assigning custom roles to SECURITYADMIN, the role hierarchy can be managed centrally and securely. The other options are not recommended system roles for a custom role hierarchy to be ultimately assigned to. Option A is incorrect because ACCOUNTADMIN is the most powerful role in an account, which has full access to all objects and operations. Assigning custom roles to ACCOUNTADMIN can pose a security risk and should be avoided. Option C is incorrect because SYSTEMADMIN is a role that has full access to all objects in the public schema of the account, but not to other schemas or databases. Assigning custom roles to SYSTEMADMIN can limit the scope and flexibility of the role hierarchy. Option D is incorrect because USERADMIN is a role that can manage users and roles in an account, but not grant access privileges to other objects. Assigning custom roles to USERADMIN can prevent the role hierarchy from controlling access to data and resources.

Question 5

Database XYZ has the data_retention_time_in_days parameter set to 7 days and table xyz.public.ABC has the data_retention_time_in_days set to 10 days.

A Developer accidentally dropped the database containing this single table 8 days ago and just discovered the mistake.

How can the table be recovered?

Aundrop database xyz;

Bcreate -able abc_restore as select * from xyz.public.abc at {offset => -60*60*24*8};

Ccreate table abc_restore clone xyz.public.abc at (offset => -30G*24*3);

DCreate a Snowflake Support case lo restore the database and tab e from 'a i-safe

Answer : A

The table can be recovered by using the undrop database xyz; command. This command will restore the database that was dropped within the last 14 days, along with all its schemas and tables, including the customer table. The data_retention_time_in_days parameter does not affect this command, as it only applies to time travel queries that reference historical data versions of tables or databases. The other options are not valid ways to recover the table. Option B is incorrect because creating a table as select * from xyz.public.ABC at {offset => -6060248} will not work, as this query will try to access a historical data version of the ABC table that does not exist anymore after dropping the database. Option C is incorrect because creating a table clone xyz.public.ABC at {offset => -360024*3} will not work, as this query will try to clone a historical data version of the ABC table that does not exist anymore after dropping the database. Option D is incorrect because creating a Snowflake Support case to restore the database and table from fail-safe will not work, as fail-safe is only available for disaster recovery scenarios and cannot be accessed by customers.

Question 6

The JSON below is stored in a variant column named v in a table named jCustRaw:

Which query will return one row per team member (stored in the teamMembers array) along all of the attributes of each team member?

AOption A

BOption B

COption C

DOption D

Answer : B

Question 7

While running an external function, me following error message is received:

Error: function received the wrong number of rows

What is causing this to occur?

AExternal functions do not support multiple rows

BNested arrays are not supported in the JSON response

CThe JSON returned by the remote service is not constructed correctly

DThe return message did not produce the same number of rows that it received

Answer : D

The error message ''function received the wrong number of rows'' is caused by the return message not producing the same number of rows that it received. External functions require that the remote service returns exactly one row for each input row that it receives from Snowflake. If the remote service returns more or fewer rows than expected, Snowflake will raise an error and abort the function execution. The other options are not causes of this error message. Option A is incorrect because external functions do support multiple rows as long as they match the input rows. Option B is incorrect because nested arrays are supported in the JSON response as long as they conform to the return type definition of the external function. Option C is incorrect because the JSON returned by the remote service may be constructed correctly but still produce a different number of rows than expected.

Snowflake DEA-C01 SnowPro Advanced: Data Engineer Certification Exam Practice Test