- All Exams Instant Download
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
Which data types does Snowflake support when querying semi-structured data? (Select TWO)A . VARIANTB . ARRAYC . VARCHARD . XMLE . BLOBView AnswerAnswer: A,B Explanation: https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY. The maximum length of...
Which copy INTO command outputs the data into one file?
Which copy INTO command outputs the data into one file?A . SINGLE=TRUEB . MAX_FILE_NUMBER=1C . FILE_NUMBER=1D . MULTIPLE=FAISEView AnswerAnswer: B
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.A . TrueB . FalseView AnswerAnswer: A
The FLATEEN function is used to query which type of data in Snowflake?
The FLATEEN function is used to query which type of data in Snowflake?A . Structured dataB . Semi-structured dataC . Both of the aboveD . None of the aboveView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/querying-semistructured.html FLATTEN is used to unnest semi-structured data. Don't see an application for structured data as by...
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)A . Growth of storage and compute are tightly coupled togetherB . Storage expands without the requirement to add more computeC . Compute can be scaled up or down without the requirement...
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)A . The validation_mode option is used when creating an Internal StageB . validation_mode=return_all_errors is a parameter of the copy commandC . The validation_mode option will validate data to be loaded by the copy statement while completing the...
Which Snowflake partner specializes in data catalog solutions?
Which Snowflake partner specializes in data catalog solutions?A . AlationB . DataRobotC . dbtD . TableauView AnswerAnswer: A Explanation: Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, & Govern Data Across an Enterprise. https://docs.snowflake.com/en/user-guide/ecosystem-all.html
The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers
The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answersA . The complexity of each queryB . The CONCURRENT_QUERY_UMIT parameter set on the Snowflake accountC . The size of the data required for each queryD . The tool that s executing the queryView...
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:A . ConcurrencyB . PerformanceView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html
