Join the discussion
Question 1/46
When using the CURRENT_ROLE and CURRENT_USER functions with secure UDFs that will be shared with Snowflake accounts, Snowflake returns a NULL value for these functions?
Correct Answer: A
Explanation
When using the CURRENT_ROLE and CURRENT_USER functions with secure UDFs that will be shared with Snowflake accounts, Snowflake returns a NULL value for these functions. The rea-son is that the owner of the data being shared does not typically control the users or roles in the ac-count with which the UDF is being shared.
When using the CURRENT_ROLE and CURRENT_USER functions with secure UDFs that will be shared with Snowflake accounts, Snowflake returns a NULL value for these functions. The rea-son is that the owner of the data being shared does not typically control the users or roles in the ac-count with which the UDF is being shared.
Add Comments
- Other Question (46q)
- Q1. When using the CURRENT_ROLE and CURRENT_USER functions with secure UDFs that will be share...
- Q2. As part of Table Designing, Data Engineer added a timestamp column that inserts the curren...
- Q3. Snowflake computes and adds partitions based on the defined partition column expressions w...
- Q4. In Which Data Modelling Technique, Data Engineer generally refer the terms Hubs & Sate...
- Q5. To advance the offset of a stream to the current table version without consuming the chang...
- Q6. To view/monitor the clustering metadata for a table, Snowflake provides which of the follo...
- Q7. A SQL UDF evaluates an arbitrary SQL expression and returns the result(s) of the expressio...
- Q8. Jonas, a Lead Performance Engineer,identifed that some of the operation of his query which...
- Q9. In efforts to recover the dropped child tables within schema named SCV_SCHEMA by Data Engi...
- Q10. Data Engineer try to load data from external stage using Snowpipe & later find out tha...
- Q11. Melissa, Senior Data Engineer, looking out to optimize query performance for one of the Cr...
- Q12. Data Engineer looking out for quick tool for understanding the mechanics of queries & ...
- Q13. Let us say you have List of 50 Source files, which needs to be loaded into Snowflake inter...
- Q14. Mark the incorrect statement when Data Engineer implement Automating Continuous Data Loadi...
- Q15. Snowpipe API provides a REST endpoint for defining the list of files to ingest that Inform...
- Q16. As Data Engineer, you have been asked to access data held in AWS Glacier Deep Archive stor...
- Q17. Jackie, a Data engineer advised to his data team members about one of the Role highlightin...
- Q18. Data Engineer is using existing pipe that automates data loads using event notifications, ...
- Q19. To support Time Travel, Which of the following SQL extensions/parameters/commands have bee...
- Q20. To help manage STAGE storage costs, Data engineer recommended to monitor stage files and r...
- Q21. Can Masking policies be applied to virtual columns?...
- Q22. Mark the Incorrect Statements with respect to types of streams supported by Snowflake?...
- Q23. Mark the Correct Statements: Statement 1. Enable failover for a primary database to one or...
- Q24. Charles, A Lead Data engineer, with ACCOUNTADMIN role wants to configure the time travel f...
- Q25. When created, a stream logically takes an initial snapshot of every row in the source obje...
- Q26. Which ones are the false statements about Materialized Views?...
- Q27. John, Data Engineer, do have technical requirements to refresh the External tables Metadat...
- Q28. Which Function would Data engineer used to recursively resume all tasks in Chain of Tasks ...
- Q29. Mark the Correct Statements for the VALIDATION_MODE option used by Data Engineer for Da-ta...
- Q30. How Data Engineer can do Monitoring of Files which are Staged Internally during Continuous...
- Q31. If using a JavaScript UDF in a masking policy, Data Engineer needs to ensure the data type...
- Q32. Select the correct usage statements with regards to SQL UDF?...
- Q33. If the data retention period for a table is less than 90 days, and a stream has not been c...
- Q34. Which are supported Programming Languages for Creating UDTFs?...
- Q35. 1.+--------------------------------------------------------------+ 2.| SYSTEM$CLUSTERING_I...
- Q36. Pascal, a Data Engineer, have requirement to retrieve the 10 most recent executions of a s...
- Q37. Data Engineer identified use case where he decided to use materialized view for query perf...
- Q38. Which are false statements about Star Schema?
- Q39. Data Engineer Loading File named snowdata.tsv in the /datadir directory from his local mac...
- Q40. Which two Account usage views can be used for auditing Dynamic data masking purpose?...
- Q41. Select the incorrect statement while working with warehouses?...
- Q42. The Snowpipe API provides REST endpoints for fetching load reports. One of the Endpoint na...
- Q43. The COPY command supports several options for loading data files from a stage i.e. I. By p...
- Q44. While creating External function, Which Database object required with at least ACCOUNTAD-M...
- Q45. Ryan, a Data Engineer, wants to improve the performance of large, complex queries against ...
- Q46. Which are the two ways to access elements in a JSON object?...
