- All Exams Instant Download
Select the true statement
Select the true statementA . Privileges are granted to roles. Roles are granted to users B. Privileges are granted to users. Users are granted to roles C. Privileges are granted to both roles and usersView AnswerAnswer: A Explanation: Privileges are granted to roles, and roles are granted to users, to...
Which of the below are securable objects?
Which of the below are securable objects?A . USER B. ROLE C. PRIVILEDGE D. TABLE E. DATABASEView AnswerAnswer: A,B,D,E Explanation: Securable object is an entity to which access can be granted. Unless allowed by a grant, access will be denied Every securable object resides within a logical container in a...
Data sharing is supported only between provider and consumer accounts in same region
Data sharing is supported only between provider and consumer accounts in same regionA . TRUE B. FALSEView AnswerAnswer: B Explanation: please read the below link https://docs.snowflake.com/en/user-guide/secure-data-sharing-across-regions-plaforms.html
Dynamic data masking is supported in which editions of snowflake
Dynamic data masking is supported in which editions of snowflakeA . Enterprise B. VPS C. Business Critical D. StandardView AnswerAnswer: A,B,C Explanation: Support for Dynamic masking is available in enterprise edition and above
All multi cluster warehouses that were using the Legacy policy now use the default Standard policy
All multi cluster warehouses that were using the Legacy policy now use the default Standard policyA . TRUE B. FALSEView AnswerAnswer: A Explanation: A third scaling policy, Legacy, was provided for backward compatibility. In contrast to the other policies, it used a static approach based on length of time a...
Why?
You have a medium warehouse with auto suspend of 5 minutes. You ran a query on table#1. After 10 minutes, you ran a query that joins table#1 and table#2, but you see that the query did not use data cache. Why?A . When a warehouse is suspended, it may lose...
JSON and PARQUET files can be loaded to columns in the same table
JSON and PARQUET files can be loaded to columns in the same tableA . TRUE B. FALSEView AnswerAnswer: B Explanation: Let us try to answer some logical questions to arrive at the answer for this question
SNOWPIPE_AUTO_INGEST is supported for external stages only
SNOWPIPE_AUTO_INGEST is supported for external stages onlyA . TRUE B. FALSEView AnswerAnswer: A Explanation: Snowpipe auto-ingest only works with the external stage object. However, Snowpipe REST APIs work with both internal and external stages
Why is this error thrown and who can give you the required privilege?
You are creating a TASK to query a table streams created on the raw table and insert subsets of rows into multiple tables. You are following the below steps, but when you reached the step to resume the task, you received an error message as below. Why is this error...
Which are those?
Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns. Which are those?A . RECORD_CONTENT B. RECORD_METADATA C. RECORD_MESSAGEView AnswerAnswer: A,B Explanation: Schema of Topics for Kafka Topics Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns:
