ARA-C01 exam

You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the...

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?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 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 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 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...

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 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 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

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...