Question 36
In Which Data Modelling Technique, Data Engineer generally refer the terms Hubs & Satellites?
Question 37
Harry using Snowflake Enterprise Edition & decided to scale in/out the Cluster in automatic mode. He needs to configure some warehouses as multi cluster mode and some among them in Standard mode as per needs.
If Harry is using Snowflake Enterprise Edition (or a higher edition), all his warehouses should be configured as multi-cluster warehouses only.
If Harry is using Snowflake Enterprise Edition (or a higher edition), all his warehouses should be configured as multi-cluster warehouses only.
Question 38
A Data Engineer has written a stored procedure that will run with caller's rights. The Engineer has granted ROLEA right to use this stored procedure.
What is a characteristic of the stored procedure being called using ROLEA?
What is a characteristic of the stored procedure being called using ROLEA?
Question 39
Mark the correct statements about Cache?
Question 40
Data Engineer identified use case where he decided to use materialized view for query perfor-mance. Which one is not the limitation he must be aware of before using MVs in their use case?
