- 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...
If the user runs the same copy into command what will happen?
A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command: COPY INTO my__table FROM @my__stage; The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer...
Will the developer be able to modify the table to read the masked data?
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?A . Yes, because a table owner has full control and can unset...
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)A . Data can be filtered by an optional where clauseB . Incoming data can be joined with other tablesC . Columns can be reorderedD . Columns can be omittedE . Row level access...
Which SQL command should be used to validate which data was loaded into the stage?
A user has unloaded data from Snowflake to a stage. Which SQL command should be used to validate which data was loaded into the stage?A . list @file__stageB . show @file__stageC . view @file__stageD . verify @file__stageView AnswerAnswer: A
Which of the following can be executed/called with Snowpipe?
Which of the following can be executed/called with Snowpipe?A . A User Defined Function (UDF)B . A stored procedureC . A single copy_into statementD . A single insert__into statementView AnswerAnswer: C
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.A . TrueB . FalseView AnswerAnswer: B
Which services does the Snowflake Cloud Services layer manage? (Select TWO).
Which services does the Snowflake Cloud Services layer manage? (Select TWO).A . Compute resourcesB . Query executionC . AuthenticationD . Data storageE . MetadataView AnswerAnswer: C, E Explanation: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the...
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?A . Data is hashed by the cluster key to facilitate fast searches for common data valuesB . Larger micro-partitions are created for common data values to reduce the number of partitions that...
The fail-safe retention period is how many days?
The fail-safe retention period is how many days?A . 1 dayB . 7 daysC . 45 daysD . 90 daysView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
