ARA-C01 試験問題を無料オンラインアクセス

A Developer is having a performance issue with a Snowflake query. The query receives up to 10 different values for one parameter and then performs an aggregation over the majority of a fact table. It then joins against a smaller dimension table. This parameter value is selected by the different query users when they execute it during business hours. Both the fact and dimension tables are loaded with new data in an overnight import process.
On a Small or Medium-sized virtual warehouse, the query performs slowly. Performance is acceptable on a size Large or bigger warehouse. However, there is no budget to increase costs. The Developer needs a recommendation that does not increase compute costs to run this query.
What should the Architect recommend?

• A.Enable the search optimization service on the table. When the users execute the query, the search optimization service will automatically adjust the query execution plan based on the frequently-used parameters.
• B.Create a task that will run the 10 different variations of the query corresponding to the 10 different parameters before the users come in to work. The task will be scheduled to align with the users' working hours in order to allow the warehouse cache to be used.
• C.Create a dedicated size Large warehouse for this particular set of queries. Create a new role that has USAGE permission on this warehouse and has the appropriate read permissions over the fact and dimension tables. Have users switch to this role and use this warehouse when they want to access this data.
• D.Create a task that will run the 10 different variations of the query corresponding to the 10 different parameters before the users come in to work. The query results will then be cached and ready to respond quickly when the users re-issue the query.

What Snowflake features should be leveraged when modeling using Data Vault?

• A.Snowflake's support of multi-table inserts into the data model's Data Vault tables
• B.Data needs to be pre-partitioned to obtain a superior data access performance
• C.Scaling up the virtual warehouses will support parallel processing of new source loads
• D.Snowflake's ability to hash keys so that hash key joins can run faster than integer joins

The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend - 60 and used exclusively for this task, which statement is true?

• A.The warehouse MY_WH will never suspend.
• B.The warehouse MY_WH will only be active when there are results in the stream.
• C.The warehouse MY_WH will be made active every five minutes to check the stream.
• D.The warehouse MY_WH will automatically resize to accommodate the size of the stream.

An Architect needs to design a solution for building environments for development, test, and pre-production, all located in a single Snowflake account. The environments should be based on production data.
Which solution would be MOST cost-effective and performant?

• A.Use zero-copy cloning into transient tables.
• B.Use a Snowflake task to trigger a stored procedure to copy data.
• C.Use zero-copy cloning into permanent tables.
• D.Use CREATE TABLE ... AS SELECT (CTAS) statements.

Database DB1 has schema S1 which has one table, T1.
DB1 --> S1 --> T1
The retention period of EG1 is set to 10 days.
The retention period of s: is set to 20 days.
The retention period of t: Is set to 30 days.
The user runs the following command:
Drop Database DB1;
What will the Time Travel retention period be for T1?

• A.37 days
• B.20 days
• C.30 days
• D.10 days