SnowPro Core

Which of the following statements is true of data loading?A . Resizing the virtual warehouse from x-Small to Small will process a single file twice as fastB . The "deal file size for loading is 16MB to match micro-partition sizeC . Marry files in the 10-lOOMB range tend to land...

Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy?A . Account -> Schema -> Database -> TableB . Account -> Database -> Schema -> TableC . Database -> Schema -> Table -> AccountD . Database -> Table -> Schema -> AccountView AnswerAnswer: B Explanation:...

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 lowest Snowflake edition that offers Time Travel up to 90 days.A . standard EditionB . Premier EditionC . Enterprise EditionD . Business Critical EditionView AnswerAnswer: C Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-availability.html

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...

True or False: The COPY command must specify a File Format in order to execute.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://interworks.com/blog/hcalder/2018/07/26/the-basics-of-loading-data-into-snowflake/

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/

How a Snowpipe charges calculated?A . Per-second/per Warehouse sizeB . Per-second/per-core granularityC . Number of Pipes in accountD . Total storage bucket sizeView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

Which of the following statements about data sharing are true? choose 2 answersA . New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader AccountsB . All database objects can be included In a shared databaseC . Reader Accounts are created and funded by...

If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:A . All Snowflake sessions using the warehouse are terminated.B . The last query using the warehouse completes.C . There are no users loaned into Snowflake.D . The Warehouse is inactive for a specified period of time.View...