IS_ROLE_IN_SESSION is a function in Snowflake that checks if a specified role is active in the current session. This is commonly used in conjunction with dynamic data masking to determine if a user has the necessary role to view unmasked data.
Snowflake snowpro advanced data engineer practice test
snowpro advanced data engineer
Question 1
A Data Engineer defines the following masking policy:
The policy must be applied to the full_name column in the customer table:
Which query will apply the masking policy on the full_name column?
- A. ALTER TABLE customer MODIFY COLUMN full_nameSET MASKING POLICY name policy;
- B. ALTER TABLE customer MODIFY COLUMN full_nameADD MASKING POLICY name_policy;
- C. ALTER TABLE customer MODIFY COLUMNfirst_name SET MASKING POLICY name_policy,last_name SET MASKING POLICY name_policy;
- D. ALTER TABLE customer MODIFY COLUMNfirst_name ADD MASKING POLICY name_policy,last_name SET MASKING POLICY name_policy;
Answer:
b -
Discussions
0
/ 1000
Question 2
Within a Snowflake account. permissions have been defined with custom roles and role hierarchies.
To set up column-level masking using a role in the hierarchy of the current user, what command would be used?
- A. CURRENT_ROLE
- B. INVOKER_ROLE
- C. IS_ROLE_IN_SESSION
- D. IS_GRANTED_TO_INVOKER_ROLE
Answer:
d
Discussions
0
/ 1000
3 months, 4 weeks ago
Question 3
A Data Engineer needs to know the details regarding the micro-partition layout for a table named Invoice using a built-in function.
Which query will provide this information?
- A. SELECT SYSTEM$CLUSTERING_INFORMATION('Invoice');
- B. SELECT $CLUSTERING_INFORMATION('Invoice');
- C. CALL SYSTEM$CLUSTERING_INFORMATION('Invoice');
- D. CALL $CLUSTERING_INFORMATION('Invoice');
Answer:
a
Discussions
0
/ 1000
Question 4
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?
- A. Creating a DataFrame from a table will start a virtual warehouse.
- B. Creating a DataFrame from a staged file with the read() method will start a virtual warehouse.
- C. Transforming a DataFrame with methods like replace() will start a virtual warehouse.
- D. Calling a Snowpark stored procedure to query the database with session.call() will start a virtual warehouse.
Answer:
a
Discussions
0
/ 1000
Question 5
Which system role is recommended for a custom role hierarchy to be ultimately assigned to?
- A. ACCOUNTADMIN
- B. SECURITYADMIN
- C. SYSADMIN
- D. USERADMIN
Answer:
c
Discussions
0
/ 1000
Question 6
What kind of Snowflake integration is required when defining an external function in Snowflake?
- A. API integration
- B. HTTP integration
- C. Notification integration
- D. Security integration
Answer:
a
Discussions
0
/ 1000
Question 7
Which methods will trigger an action that will evaluate a DataFrame? (Choose two.)
- A. DataFrame.random_split()
- B. DataFrame.collect()
- C. DataFrame.select()
- D. DataFrame.col()
- E. DataFrame.show()
Answer:
be
Discussions
0
/ 1000
Question 8
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 with all of the attributes of each team member?
- D. None
Answer:
b
Discussions
0
/ 1000
Question 9
A Data Engineer is investigating a query that is taking a long time to return. The Query Profile shows the following:
What step should the Engineer take to increase the query performance?
- A. Add additional virtual warehouses.
- B. Increase the size of the virtual warehouse.
- C. Rewrite the query using Common Table Expressions (CTEs).
- D. Change the order of the joins and start with smaller tables first.
Answer:
b
Discussions
0
/ 1000
Question 10
Which functions will compute a 'fingerprint' over an entire table, query result, or window to quickly detect changes to table contents or query results? (Choose two.)
- A. HASH(*)
- B. HASH_AGG(*)
-
C.
HASH_AGG(
, ) - D. HASH_AGG_COMPARE(*)
- E. HASH_COMPARE(*)
Answer:
bd
Discussions
0
/ 1000
should be A