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

出題：1

A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers in different regions.
The data pipeline needs to run continuously and efficiently as new records arrive in the object storage leveraging event notifications. Also, the operational complexity, maintenance of the infrastructure, including platform upgrades and security, and the development effort should be minimal.
Which design will meet these requirements?

A. Ingest the data into Snowflake using Amazon EMR and PySpark using the Snowflake Spark connector.
Apply transformations using another Spark job. Develop a python program to do model inference by leveraging the Amazon Comprehend text analysis API. Then write the results to a Snowflake table and create a listing in the Snowflake Marketplace to make the data available to other companies.

B. Ingest the data using Snowpipe and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.

C. Ingest the data using Snowpipe and use streams and tasks to orchestrate transformations. Create an external function to do model inference with Amazon Comprehend and write the final records to a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.

D. Ingest the data using copy into and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.

正解：C 解答を投票する

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

出題：2

Which of the following ingestion methods can be used to load near real-time data by using the messaging services provided by a cloud provider?

A. Snowflake streams

B. Spark

C. Snowflake Connector for Kafka

D. Snowpipe

正解：C 解答を投票する

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

出題：3

A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines.
Which actions can the company take with the inbound share? (Choose two.)

A. Grant modify permissions on the share.

B. Create a table stream on the shared table.

C. Create additional views inside the shared database.

D. Create a table from the shared database.

E. Clone a table from a share.

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

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

出題：4

A company has a Snowflake account named ACCOUNTA in AWS us-east-1 region. The company stores its marketing data in a Snowflake database named MARKET_DB. One of the company's business partners has an account named PARTNERB in Azure East US 2 region. For marketing purposes the company has agreed to share the database MARKET_DB with the partner account.
Which of the following steps MUST be performed for the account PARTNERB to consume data from the MARKET_DB database?

A. From account ACCOUNTA create a share of database MARKET_DB, and create a new database out of this share locally in AWS us-east-1 region. Then make this database the provider and share it with the PARTNERB account.

B. Create a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA create a share of database MARKET_DB, create a new database out of this share locally in AWS us- east-1 region, and replicate this new database to AZABC123 account. Then set up data sharing to the PARTNERB account.

C. Create a share of database MARKET_DB, and create a new database out of this share locally in AWS us-east-1 region. Then replicate this database to the partner's account PARTNERB.

D. Create a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA replicate the database MARKET_DB to AZABC123 and from this account set up the data sharing to the PARTNERB account.

正解：D 解答を投票する

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

出題：5

Which command will create a schema without Fail-safe and will restrict object owners from passing on access to other users?

A. create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS
DATA_RETENTION_TIME_IN_DAYS = 1;

B. create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS
DATA_RETENTION_TIME_IN_DAYS = 7;

C. create schema EDW.ACCOUNTING WITH MANAGED ACCESS;

D. create schema EDW.ACCOUNTING WITH MANAGED ACCESS
DATA_RETENTION_TIME_IN_DAYS - 7;

正解：B 解答を投票する

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

出題：6

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

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

出題：7

Based on the architecture in the image, how can the data from DB1 be copied into TBL2? (Select TWO).

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

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

出題：8

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

出題：9

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

B. Use zero-copy cloning into transient tables.

C. Use a Snowflake task to trigger a stored procedure to copy data.

D. Use CREATE TABLE ... AS SELECT (CTAS) statements.

正解：B 解答を投票する

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

出題：10

The following chart represents the performance of a virtual warehouse over time:

A Data Engineer notices that the warehouse is queueing queries. The warehouse is sizeX-Small, theminimum and maximum cluster counts are set to 1, thescaling policy is set to standard, andauto-suspend is set to 10 minutes.
How can the performance be improved?

A. Increase the size of the warehouse.

B. Change the cluster settings.

C. Change the scaling policy to economy.

D. Change auto-suspend to a longer time frame.

正解：B 解答を投票する

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