SnowPro Core

Select the different types of Internal Stages: (Choose three.)A . Named StageB . User StageC . Table StageD . Schema StageView AnswerAnswer: A,B,C Explanation: Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage

What is the maximum compressed row size in Snowflake?A . 8KBB . 16MBC . 50MBD . 4000GBView AnswerAnswer: B

When a pipe is recreated using the CREATE on REPLAC PIPE command: Select one.A . The Pipe load history is reset to emptyB . The REFRESH parameter is set to TRUEC . Previously loaded files will be ignoredD . All of the aboveView AnswerAnswer: A

Select the three types of tables that exist within Snowflake. Choose 3 answersA . TemporaryB . TransientC . ProvisionedD . PermanentView AnswerAnswer: A,B,D Explanation: Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)A . CustomB . EconomyC . OptimizedD . StandardView AnswerAnswer: B,D Explanation: Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance

Which of the following are options when creating a virtual Warehouse? Choose 2 answersA . Auto-dropB . Auto resizeC . Auto-resumeD . Auto-suspendView AnswerAnswer: C,D Explanation: Reference: https://help.pentaho.com/Documentation/9.1/Products/Create_Snowflake_warehouse https://www.analytics.today/blog/what-is-a-snowflake-virtual-warehouse

What is the maximum compressed row size in Snowflake?A . 8KBB . 16MBC . 50MBD . 4000GBView AnswerAnswer: B

Which of the following statements is true of Snowflake?A . It was built specifically for the cloudB . It was built as an on-premises solution and then ported to the cloudC . It was designed as a hybrid database to allow customers to store data either on premises or in...

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://acrotrend.com/snowflake-data-sharing/

For a multi-cluster Warehouse, the number of credits billed is calculated on: Select one.A . The number of queries that ran using the Warehouse.B . The size of the Warehouse and the number of clusters that ran within a given time period.C . The sue of the Warehouse and the...