ARA-C01試験無料問題集（164題）「Snowflake SnowPro Advanced Architect Certification 認定」

出題：1

When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)

A. Parquet

B. Avro

C. CSV

D. XML

E. JSON

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

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

出題：2

A user, analyst_user has been granted the analyst_role, and is deploying a SnowSQL script to run as a background service to extract data from Snowflake.
What steps should be taken to allow the IP addresses to be accessed? (Select TWO).

A. ALTERROLEANALYST_ROLESETNETWORK_POLICY='ANALYST_POLICY';

B. ALTERUSERANALYST_USERSETNETWORK_POLICY='10.1.1.20';

C. USE ROLE SECURITYADMIN;CREATE OR REPLACE NETWORK POLICY
ANALYST_POLICY ALLOWED_IP_LIST = ('10.1.1.20');

D. USE ROLE USERADMIN;CREATE OR REPLACE NETWORK POLICYANALYST_POLICYALLOWED_IP_LIST = ('10.1.1.20');

E. ALTERUSERANALYSTJJSERSETNETWORK_POLICY='ANALYST_POLICY';

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

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

出題：3

A Snowflake Architect is setting up database replication to support a disaster recovery plan. The primary database has external tables.
How should the database be replicated?

A. Replicate the database ensuring the replicated database is in the same region as the external tables.

B. Create a clone of the primary database then replicate the database.

C. Share the primary database with an account in the same region that the database will be replicated to.

D. Move the external tables to a database that is not replicated, then replicate the primary database.

正解：D 解答を投票する

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

出題：4

A Snowflake Architect is designing a multiple-account design strategy.
This strategy will be MOST cost-effective with which scenarios? (Select TWO).

A. The company needs to support different role-based access control features for the development, test, and production environments.

B. The company must use a specific network policy for certain users to allow and block given IP addresses.

C. The company wants to clone a production database that resides on AWS to a development database that resides on Azure.

D. The company needs to share data between two databases, where one must support Payment Card Industry Data Security Standard (PCI DSS) compliance but the other one does not.

E. The company security policy mandates the use of different Active Directory instances for the development, test, and production environments.

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

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

出題：5

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

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

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

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

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

出題：6

What is a characteristic of event notifications in Snowpipe?

A. When a pipe Is paused, event messages received for the pipe enter a limited retention period.

B. Notifications identify the cloud storage event and the actual data in the files.

C. Snowflake can process all older notifications when a paused pipe Is resumed.

D. The load history is stored In the metadata of the target table.

正解：A 解答を投票する

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

出題：7

An Architect has a VPN_ACCESS_LOGS table in the SECURITY_LOGS schema containing timestamps of the connection and disconnection, username of the user, and summary statistics.
What should the Architect do to enable the Snowflake search optimization service on this table?

A. Assume role with ALL PRIVILEGES including ADD SEARCH OPTIMIZATION in the SECURITY LOGS schema.

B. Assume role with OWNERSHIP on future tables and ADD SEARCH OPTIMIZATION on the SECURITY_LOGS schema.

C. Assume role with OWNERSHIP on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema.

D. Assume role with ALL PRIVILEGES on VPN_ACCESS_LOGS and ADD SEARCHOPTIMIZATION in the SECURITY_LOGS schema.

正解：C 解答を投票する

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

出題：8

A user named USER_01 needs access to create a materialized view on a schema EDW. STG_SCHEMA. How can this access be provided?

A. GRANT CREATE MATERIALIZED VIEW ON SCHEMA EDW.STG_SCHEMA TO USER
USER_01;

B. GRANT ROLE NEW_ROLE TO USER_01;GRANT CREATE MATERIALIZED VIEW ON EDW.STG_SCHEMA TO NEW_ROLE;

C. GRANT CREATE MATERIALIZED VIEW ON DATABASE EDW TO USER USERJD1;

D. GRANT ROLE NEW_ROLE TO USER USER_01;GRANT CREATE MATERIALIZED VIEW ON SCHEMA ECW.STG_SCHEKA TO NEW_ROLE;

正解：A 解答を投票する

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

出題：9

An Architect is implementing a CI/CD process. When attempting to clone a table from a production to a development environment, the cloning operation fails.
What could be causing this to happen?

A. The retention time for the table is set to zero.

B. Tables cannot be cloned from a higher environment to a lower environment.

C. The table has a masking policy.

D. The table is transient.

正解：C 解答を投票する

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

出題：10

How can the Snowpipe REST API be used to keep a log of data load history?

A. Call insertReport every 8 minutes for a 10-minute time range.

B. Call loadHistoryScan every 10 minutes for a 15-minute time range.

C. Call loadHistoryScan every minute for the maximum time range.

D. Call insertReport every 20 minutes, fetching the last 10,000 entries.

正解：B 解答を投票する

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

ARA-C01試験無料問題集「Snowflake SnowPro Advanced Architect Certification 認定」