ARA-C01 exam

Which of the two are limitations of the insertReport API of SnowPipe?A . The 10,000 most recent events are retained B. Events are retained for a maximum of 10 minutes C. Events are retained for a maximum of 24 hoursView AnswerAnswer: A,B Explanation: Endpoint: insertReport Retrieves a report of files...

When a database gets cloned, what accesses are replicatedA . All objects in the database and their child objects(schemas, tables etc) B. Only the data base object access C. Only the child object access D. No access gets replicatedView AnswerAnswer: A Explanation: A cloned object does not retain any granted...

Which of the below operations are allowed on an inbound share data?A . MERGE B. CREATE/DROP/ALTER TABLE C. ALTER SCHEMA D. SELECT WITH JOIN E. SELECT WITH GROUP BY F. INSERT INTOView AnswerAnswer: D,E Explanation: This is a trick question:) remember a share is read only, so you can only...

When a cloned table is replicated to a secondary database, the data also gets replicated in the secondary databaseA . TRUE B. FALSEView AnswerAnswer: A Explanation: Replication of clone table replicates the data as well. This increases your data storage cost.

What is the recommended strategy to choose the right sized warehouse to achieve best performance based on query processing?A . Run homogenous queries on the same warehouse B. Run heterogenous queries on the same warehouseView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#how-does-query-compositio n-impact-warehouse-processing To achieve the best results, try to execute relatively homogeneous...

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

Which of the below query will you run to get the approximate number of distinct values in a table?A . select approx_count_distinct(column1) from table1; B. select approx_count(column1) from table1; C. select count_distinct(column1 approx) from table1;View AnswerAnswer: A Explanation: APPROX_COUNT_DISTINCT Uses HyperLogLog to return an approximation of the distinct cardinality of...

If your role does not own the share, but owns the objects in the share, how can you block access to the objectsA . Revoking the USAGE or SELECT privileges with CASCADE on the objects from the share owner. B. Revoking the USAGE or SELECT privileges on the objects from...

Out of the three query optimization techniques(search optimization, clustering and materialized view) which one does not have storage costA . Search Optimization Service B. Materialized View C. Clustering the TableView AnswerAnswer: C Explanation: The following table shows which of these three optimizations have storage or compute costs:

{"stuId":2000,"stuCourse":"Snowflake"} How will you write a query that will check if stuId in JSON in #1 is also there in JSON in#2A . with stu_demography as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000, "stuName":"Amy"}')), B. stu_course as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000,"stuCourse":"Snowflake"}')) select case...