- All Exams Instant Download
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
Which of the following commands cannot be used within a reader account?
Which of the following commands cannot be used within a reader account?A . CREATE SHAREB . ALTER WAREHOUSEC . DROP ROLED . SHOW SCHEMASE . DESCRBE TABLEView AnswerAnswer: ABC
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).A . Compute Credits = 50 Credits Cloud Services = 10B . Compute Credits = 80 Credits Cloud Services = 5C . Compute Credits = 10 Credits Cloud Services = 9D . Compute Credits = 120 Credits...
