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

出題：1

A company is designing its serving layer for data that is in cloud storage. Multiple terabytes of the data will be used for reporting. Some data does not have a clear use case but could be useful for experimental analysis.
This experimentation data changes frequently and is sometimes wiped out and replaced completely in a few days.
The company wants to centralize access control, provide a single point of connection for the end-users, and maintain data governance.
What solution meets these requirements while MINIMIZING costs, administrative effort, and development overhead?

A. Import all the data in cloud storage to be used for reporting into a Snowflake schema with native tables.
Then create a role that has access to this schema and manage access to the data through that role.

B. Import the data used for reporting into a Snowflake schema with native tables. Then create views that have SELECT commands pointing to the cloud storage files for the experimentation data. Then create two different roles to match the different user personas, and grant these roles to the corresponding users.

C. Import all the data in cloud storage to be used for reporting into a Snowflake schema with native tables.
Then create two different roles with grants to the different datasets to match the different user personas, and grant these roles to the corresponding users.

D. Import the data used for reporting into a Snowflake schema with native tables. Then create external tables pointing to the cloud storage folders used for the experimentation data. Then create two different roles with grants to the different datasets to match the different user personas, and grant these roles to the corresponding users.

正解：D 解答を投票する

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

出題：2

Which of the following are characteristics of how row access policies can be applied to external tables?
(Choose three.)

A. A row access policy cannot be applied to a view created on top of an external table.

B. A row access policy can be applied to the VALUE column of an existing external table.

C. While cloning a database, both the row access policy and the external table will be cloned.

D. An external table can be created with a row access policy, and the policy can be applied to the VALUE column.

E. External tables are supported as mapping tables in a row access policy.

F. A row access policy cannot be directly added to a virtual column of an external table.

正解：B,D,F 解答を投票する

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

出題：3

When activating Tri-Secret Secure in a hierarchical encryption model in a Snowflake account, at what level is the customer-managed key used?

A. At the micro-partition level

B. At the root level (HSM)

C. At the account level (AMK)

D. At the table level (TMK)

正解：C 解答を投票する

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

出題：4

An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00 AM, to recover some objects.
The STAGING schema has 50 days of retention.
The Architect runs the following statement:
CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-06-01 08:00:00'); The Architect receives the following error: Time travel data is not available for schema STAGING. The requested time is either beyond the allowed time travel period or before the object creation time.
The Architect then checks the schema history and sees the following:
CREATED_ON|NAME|DROPPED_ON
2021-06-02 23:00:00 | STAGING | NULL
2021-05-01 10:00:00 | STAGING | 2021-06-02 23:00:00
How can cloning the STAGING schema be achieved?

A. Undrop the STAGING schema and then rerun the CLONE statement.

B. Rename the STAGING schema and perform an UNDROP to retrieve the previous STAGING schema version, then run the CLONE statement.

C. Modify the statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp =>
'2021-05-01 10:00:00');

D. Cloning cannot be accomplished because the STAGING schema version was not active during the proposed Time Travel time period.

正解：D 解答を投票する

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

出題：5

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 解答を投票する

出題：6

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 automatically resize to accommodate the size of the stream.

B. The warehouse MY_WH will only be active when there are results in the stream.

C. The warehouse MY_WH will never suspend.

D. The warehouse MY_WH will be made active every five minutes to check the stream.

正解：B 解答を投票する

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

出題：7

A company has built a data pipeline using Snowpipe to ingest files from an Amazon S3 bucket. Snowpipe is configured to load data into staging database tables. Then a task runs to load the data from the staging database tables into the reporting database tables.
The company is satisfied with the availability of the data in the reporting database tables, but the reporting tables are not pruning effectively. Currently, a size 4X-Large virtual warehouse is being used to query all of the tables in the reporting database.
What step can be taken to improve the pruning of the reporting tables?

A. Use an ORDER BY <cluster_key (s) > command to load the reporting tables.

B. Increase the size of the virtual warehouse to a size 5X-Large.

C. Eliminate the use of Snowpipe and load the files into internal stages using PUT commands.

D. Create larger files for Snowpipe to ingest and ensure the staging frequency does not exceed 1 minute.

正解：A 解答を投票する

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

出題：8

What is a key consideration when setting up search optimization service for a table?

A. The table must be clustered with a key having multiple columns for effective search optimization.

B. Search optimization service can help to optimize storage usage by compressing the data into a GZIP format.

C. Search optimization service can significantly improve query performance on partitioned external tables.

D. Search optimization service works best with a column that has a minimum of 100 K distinct values.

正解：D 解答を投票する

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

出題：9

Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)

A. Periodic rekeying of encrypted data

B. Extended Time Travel (up to 90 days)

C. Customer-managed encryption keys through Tri-Secret Secure

D. AWS, Azure, or Google Cloud private connectivity to Snowflake

E. Federated authentication and SSO

正解：C,D 解答を投票する

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

出題：10

The diagram shows the process flow for Snowpipe auto-ingest with Amazon Simple Notification Service (SNS) with the following steps:
Step 1: Data files are loaded in a stage.
Step 2: An Amazon S3 event notification, published by SNS, informs Snowpipe - by way of Amazon Simple Queue Service (SQS) - that files are ready to load. Snowpipe copies the files into a queue.
Step 3: A Snowflake-provided virtual warehouse loads data from the queued files into the target table based on parameters defined in the specified pipe.

If an AWS Administrator accidentally deletes the SQS subscription to the SNS topic in Step 2, what will happen to the pipe that references the topic to receive event messages from Amazon S3?

A. The pipe will no longer be able to receive the messages. To restore the system immediately, the user needs to manually create a new SNS topic with a different name and then recreate the pipe by specifying the new SNS topic name in the pipe definition.

B. The pipe will no longer be able to receive the messages and the user must wait for 24 hours from the time when the SNS topic subscription was deleted. Pipe recreation is not required as the pipe will reuse the same subscription to the existing SNS topic after 24 hours.

C. The pipe will continue to receive the messages as Snowflake will automatically restore the subscription by creating a new SNS topic. Snowflake will then recreate the pipe by specifying the new SNS topic name in the pipe definition.

D. The pipe will continue to receive the messages as Snowflake will automatically restore the subscription to the same SNS topic and will recreate the pipe by specifying the same SNS topic name in the pipe definition.

正解：A 解答を投票する

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

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