SnowPro Core

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

Which of the following items does the Cloud services Layer manage? Choose 4 answersA . user authenticationB . MetadataC . Query compilation and optimizationD . external blob storageE . Data securityView AnswerAnswer: A,B,C,E

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.A . TrueB . FalseView AnswerAnswer: A

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.A . TrueB . FalseView AnswerAnswer: A

Which type of table corresponds to a single Snowflake session?A . TemporaryB . TranslentC . ProvisionalD . PermanentView AnswerAnswer: A

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.A . TrueB . FalseView AnswerAnswer: B

True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.A . TrueB . FalseView AnswerAnswer: B

Which of the following are options when creating a Virtual Warehouse?A . Auto-suspendB . Auto-resumeC . Local SSD sizeD . User countView AnswerAnswer: A,B

When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:A . ConcurrencyB . PerformanceView AnswerAnswer: B

Which of the following statements is true of zero-copy cloning?A . Zero-copy clones objects inheritB . All zero-copy clone objects inherit the privileges of their original objectsC . Zero-copy coning is licensed as an additional Snowflake featureD . At the instance/instance a clone is created, all micro-partitions in the original...