ARA-R01試験無料問題集（163題）「Snowflake SnowPro Advanced: Architect Recertification 認定」

出題：1

Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)

A. They can support MIN and MAX aggregates.

B. They cannot include nested subqueries.

C. They can include ORDER BY clauses.

D. They can include context functions, such as CURRENT_TIME().

E. They can support inner joins, but not outer joins.

正解：A,B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Following objects can be cloned in snowflake

A. Transient table

B. Permanent table

C. Temporary table

D. Internal stages

E. External tables

正解：A,B,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

An Architect is designing a solution that will be used to process changed records in an orders table.
Newly-inserted orders must be loaded into the f_orders fact table, which will aggregate all the orders by multiple dimensions (time, region, channel, etc.). Existing orders can be updated by the sales department within 30 days after the order creation. In case of an order update, the solution must perform two actions:
1. Update the order in the f_0RDERS fact table.
2. Load the changed order data into the special table ORDER _REPAIRS.
This table is used by the Accounting department once a month. If the order has been changed, the Accounting team needs to know the latest details and perform the necessary actions based on the data in the order_repairs table.
What data processing logic design will be the MOST performant?

A. Usetwo streams and two tasks.

B. Useone stream and two tasks.

C. Usetwo streams and one task.

D. Useone stream and one task.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Which query will identify the specific days and virtual warehouses that would benefit from a multi-cluster warehouse to improve the performance of a particular workload?

A.

B.

C.

D.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?

A. All rows loaded using a specific COPY statement will have the same timestamp value.

B. Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.

C. All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.

D. Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

An Architect clones a database and all of its objects, including tasks. After the cloning, the tasks stop running.
Why is this occurring?

A. The objects that the tasks reference are not fully qualified.

B. Cloned tasks are suspended by default and must be manually resumed.

C. The Architect has insufficient privileges to alter tasks on the cloned database.

D. Tasks cannot be cloned.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

A. A task schedule will follow only the specified time and will fail to handle lost or duplicated hours.

B. Task schedules can be designed to follow specified or local time zones to accommodate the time changes.

C. A task will move to a suspended state during the daylight savings time change.

D. A frequent task execution schedule like minutes may not cause a problem, but will affect the task history.

E. A task scheduled in a UTC-based schedule will have no issues with the time changes.

正解：B,E 解答を投票する

出題：8

An Architect has designed a data pipeline that Is receiving small CSV files from multiple sources. All of the files are landing in one location. Specific files are filtered for loading into Snowflake tables using the copy command. The loading performance is poor.
What changes can be made to Improve the data loading performance?

A. Create a specific storage landing bucket to avoid file scanning.

B. Create a multi-cluster warehouse and merge smaller files to create bigger files.

C. Increase the size of the virtual warehouse.

D. Change the file format from CSV to JSON.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

An Architect has chosen to separate their Snowflake Production and QA environments using two separate Snowflake accounts.
The QA account is intended to run and test changes on data and database objects before pushing those changes to the Production account. It is a requirement that all database objects and data in the QA account need to be an exact copy of the database objects, including privileges and data in the Production account on at least a nightly basis.
Which is the LEAST complex approach to use to populate the QA account with the Production account's data and database objects on a nightly basis?

A. 1) Create a share in the Production account for each database
2) Share access to the QA account as a Consumer
3) The QA account creates a database directly from each share
4) Create clones of those databases on a nightly basis
5) Run tests directly on those cloned databases

B. 1) In the Production account, create an external function that connects into the QA account and returns all the data for one specific table
2) Run the external function as part of a stored procedure that loops through each table in the Production account and populates each table in the QA account

C. 1) Enable replication for each database in the Production account
2) Create replica databases in the QA account
3) Create clones of the replica databases on a nightly basis
4) Run tests directly on those cloned databases

D. 1) Create a stage in the Production account
2) Create a stage in the QA account that points to the same external object-storage location
3) Create a task that runs nightly to unload each table in the Production account into the stage
4) Use Snowpipe to populate the QA account

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

A company is designing a process for importing a large amount of loT JSON data from cloud storage into Snowflake. New sets of loT data get generated and uploaded approximately every 5 minutes.
Once the loT data is in Snowflake, the company needs up-to-date information from an external vendor to join to the data. This data is then presented to users through a dashboard that shows different levels of aggregation.
The external vendor is a Snowflake customer.
What solution will MINIMIZE complexity and MAXIMIZE performance?

A. 1. Create an external table over the JSON data in cloud storage.
2. Create a task that runs every 5 minutes to run a transformation procedure on new data based on a saved timestamp.
3. Ask the vendor to create a data share with the required data that can be imported into the company's Snowflake account.
4. Join the vendor's data back to the loT data using a transformation procedure.
5. Create views over the larger dataset to perform the aggregations required by the dashboard.
6. Give the views access to the dashboard tool.

B. 1. Create an external table over the JSON data in cloud storage.
2. Create a task that runs every 5 minutes to run a transformation procedure on new data, based on a saved timestamp.
3. Ask the vendor to expose an API so an external function can be used to generate a call to join the data back to the loT data in the transformation procedure.
4. Give the transformed table access to the dashboard tool.
5. Perform the aggregations on the dashboard tool.

C. 1. Create a Snowpipe to bring the JSON data into Snowflake.
2. Use streams and tasks to trigger a transformation procedure when new JSON data arrives.
3. Ask the vendor to create a data share with the required data that is then imported into the Snowflake account.
4. Join the vendor's data back to the loT data in a transformation procedure
5. Create materialized views over the larger dataset to perform the aggregations required by the dashboard.
6. Give the materialized views access to the dashboard tool.

D. 1. Create a Snowpipe to bring the JSON data into Snowflake.
2. Use streams and tasks to trigger a transformation procedure when new JSON data arrives.
3. Ask the vendor to expose an API so an external function call can be made to join the vendor's data back to the loT data in a transformation procedure.
4. Create materialized views over the larger dataset to perform the aggregations required by the dashboard.
5. Give the materialized views access to the dashboard tool.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

ARA-R01試験無料問題集「Snowflake SnowPro Advanced: Architect Recertification 認定」