SnowPro Advanced Data Engineer Practice Test practice questions, page 7 of 7, with answer review and explanations.
Question 31
The following chart represents the performance of a virtual warehouse over time: A Data Engineer notices that the warehouse is queueing queries. The warehouse is size X-Small, the minimum and maximum cluster counts are set to 1, the scaling policy is set to standard, and auto-suspend is set to 10 minutes. How can the performance be improved?
Change the cluster settings.
Increase the size of the warehouse.
Change the scaling policy to economy.
Change auto-suspend to a longer time frame.
Question 32
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?
An error will be returned because the Engineer cannot share data that has already been shared.
An error will be returned because only views and secure stored procedures can be shared.
An error will be returned because only secure functions can be shared with inbound shares.
The Engineer will be able to share the secure function with other accounts.