ARA-C01 exam

You have created a TASK in snowflake. How will you resume it?A . No need to resume, the creation operation automatically enables the task B. ALTER TASK mytask1 RESUME; C. ALTER TASK mytask1 START;View AnswerAnswer: B Explanation: It is important to remember that a Task that has just been created...

You have a need to make external file data available to your users with the lowest latency. The files are on an external stage in AWS. What feature of Snowflake is the most appropriate to useA . Materialized View B. SnowPipe C. Secure ViewView AnswerAnswer: B Explanation: Snowpipe is Snowflake’s...

COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSVA . GZIP B. BZ2 C. BROTLI D. ZSTD E. DEFLATE F. RAW_DEFLATEView AnswerAnswer: A,B,D,E,F Explanation: AUTO Compression algorithm detected automatically, except for Brotli-compressed files, which cannot currently be detected automatically. If loading Brotli-compressed files, explicitly use...

Which of the below objects cannot be replicated from one region to the other?A . File Formats B. Sequences C. Pipes D. Views E. Materialized views F. StreamsView AnswerAnswer: C,F Explanation: As of today(27-Nov-2020), below objects cannot be replicated

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