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

出題：1

How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?

A. Create multiple materialized views with different cluster keys.

B. Create multiple clustering keys for a table.

C. Create a clustering key that contains all columns used in the access paths.

D. Create super projections that will automatically create clustering.

正解：A 解答を投票する

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

出題：2

An Architect is troubleshooting a query with poor performance using the QUERY function. The Architect observes that the COMPILATION_TIME Is greater than the EXECUTION_TIME.
What is the reason for this?

A. The query has overly complex logic.

B. The query Is reading from remote storage

C. The query Is queued for execution.

D. The query is processing a very large dataset.

正解：A 解答を投票する

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

出題：3

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 メンバーにのみ表示されます)

出題：4

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 メンバーにのみ表示されます)

出題：5

Role A has the following permissions:
. USAGE on db1
. USAGE and CREATE VIEW on schemal in db1
. SELECT on tablel in schemal
Role B has the following permissions:
. USAGE on db2
. USAGE and CREATE VIEW on schema2 in db2
. SELECT on table2 in schema2
A user has Role A set as the primary role and Role B as a secondary role.
What command will fail for this user?

A. use database db1;
use schema schemal;
select * from db2.schema2.table2;

B. use database db2;
use schema schema2;
select * from db1.schemal.tablel union select * from table2;

C. use database db2;
use schema schema2;
create view v2 as select * from dbl.schemal. tablel;

D. use database db1;
use schema schemal;
create view v1 as select * from db2.schema2.table2;

正解：C 解答を投票する

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

出題：6

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

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

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

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

正解：D 解答を投票する

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

出題：7

The IT Security team has identified that there is an ongoing credential stuffing attack on many of their organization's system.
What is the BEST way to find recent and ongoing login attempts to Snowflake?

A. Query the LOGIN_HISTORY view in the ACCOUNT_USAGE schema in the SNOWFLAKE database.

B. Call the LOGIN_HISTORY Information Schema table function.

C. View the History tab in the Snowflake UI and set up a filter for SQL text that contains the text
"LOGIN".

D. View the Users section in the Account tab in the Snowflake UI and review the last login column.

正解：A 解答を投票する

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

出題：8

An Architect is using SnowCD to investigate a connectivity issue.
Which system function will provide a list of endpoints that the network must be able to access to use a specific Snowflake account, leveraging private connectivity?

A. SYSTEMSAUTHORIZE_PRIVATELINK

B. SYSTEMSALLOWLIST_PRIVATELINK ()

C. SYSTEMSALLOWLIST ()

D. SYSTEMSGET_PRIVATELINK

正解：D 解答を投票する

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

出題：9

The Data Engineering team at a large manufacturing company needs to engineer data coming from many sources to support a wide variety of use cases and data consumer requirements which include:
1) Finance and Vendor Management team members who require reporting and visualization
2) Data Science team members who require access to raw data for ML model development
3) Sales team members who require engineered and protected data for data monetization What Snowflake data modeling approaches will meet these requirements? (Choose two.)

A. Consolidate data in the company's data lake and use EXTERNAL TABLES.

B. Create a set of profile-specific databases that aligns data with usage patterns.

C. Create a Data Vault as the sole data pipeline endpoint and have all consumers directly access the Vault.

D. Create a single star schema in a single database to support all consumers' requirements.

E. Create a raw database for landing and persisting raw data entering the data pipelines.

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

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

出題：10

When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?

A. ABORT_STATEMENT

B. SKIP_FILE

C. FAIL

D. CONTINUE

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

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

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