SnowPro Core V1

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

Which statement best describes Snowflake tables?A . Snowflake tables are logical representations of underlying physical dataB . Snowflake tables ate the physical instantiation of data loaded Into SnowflakeC . Snowflake tables require that clustering keys be defined to perform optimallyD . Snowflake tables are owned by a userView AnswerAnswer: A...

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:A . Configure the Maximum Clusters setting to “Auto-Scale”B . Set the Warehouse type to “Auto”C . Set the Minimum Clusters and Maximum Clusters settings to the same valueD . Set the Minimum Clusters and Maximum Clusters settings to the...

What happens when a Data Provider revokes privileges to a Share on an object in their source database?A . The object immediately becomes unavailable for all Data ConsumersB . Any additional data arriving after this point in time will not be visible to Data ConsumersC . The Data Consumers stop...

Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?A . 1 HourB . 3 HoursC . 12 hoursD . 24 hoursView AnswerAnswer: D Explanation: Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

Which of the following statements would be used to export/unload data from Snowflake?A . COPY INTO @stageB . EXPORT TO @stageC . INSERT INTO @stageD . EXPORT_TO_STAGE (stage = > @Wage, select = > 'select * from t1);View AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?A . The primary cluster in the virtual warehouseB . The entire virtual warehouseC . The database in which the virtual warehouse residesD . The Queries currently being run on the virtual warehouseView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual% 20clusters%20in%20the%20warehouse.

True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/credits.html

Which are true of Snowflake roles?A . All grants to objects are given to roles, and never to usersB . In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operationC . The public role controls at...

Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answersA . SnowSQLB . ODBCC . RD . HIVEView AnswerAnswer: A,B Explanation: Reference: https://docs.snowflake.com/en/user-guide/connecting.html