ARA-R01問題集、Snowflake実際の試験問題

質問 1

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

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

質問 2

A company is trying to Ingest 10 TB of CSV data into a Snowflake table using Snowpipe as part of Its migration from a legacy database platform. The records need to be ingested in the MOST performant and cost-effective way.
How can these requirements be met?

A. Use ON_ERROR = continue in the copy into command.

B. Use on error = SKIP_FILE in the copy into command.

C. Use FURGE = FALSE in the copy into command.

D. Use purge = TRUE in the copy into command.

正解: B

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

質問 3

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

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

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

正解: B

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

質問 4

What does a Snowflake Architect need to consider when implementing a Snowflake Connector for Kafka?

A. The default retention time for Kafka topics is 14 days.

B. The Kafka connector supports key pair authentication, OAUTH. and basic authentication (for example, username and password).

C. Every Kafka message is in JSON or Avro format.

D. The Kafka connector will create one table and one pipe to ingest data for each topic. If the connector cannot create the table or the pipe it will result in an exception.

正解: D

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

質問 5

The data share exists between a data provider account and a data consumer account. Five tables from the provider account are being shared with the consumer account. The consumer role has been granted the imported privileges privilege.
What will happen to the consumer account if a new table (table_6) is added to the provider schema?

A. The consumer role will see the table only after this grant is given on the provider side:
use role accountadmin;
Grant select on table EDW.ACCOUNTING.Table_6 to share PSHARE_EDW_4TEST;

B. The consumer role will see the table only after this grant is given on the consumer side:
grant imported privileges on database PSHARE_EDW_4TEST_DB to DEV_ROLE;

C. The consumer role will automatically see the new table and no additional grants are needed.

D. The consumer role will see the table only after this grant is given on the provider side:
use role accountadmin;
grant usage on database EDW to share PSHARE_EDW_4TEST ;
grant usage on schema EDW.ACCOUNTING to share PSHARE_EDW_4TEST ;
Grant select on table EDW.ACCOUNTING.Table_6 to database PSHARE_EDW_4TEST_DB ;

正解: D

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

質問 6

Which Snowflake objects can be used in a data share? (Select TWO).

A. External table

B. Secure view

C. Stream

D. Standard view

E. Stored procedure

正解: A,B

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

質問 7

An Architect Is designing a data lake with Snowflake. The company has structured, semi-structured, and unstructured data. The company wants to save the data inside the data lake within the Snowflake system. The company is planning on sharing data among Its corporate branches using Snowflake data sharing.
What should be considered when sharing the unstructured data within Snowflake?

A. A file URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with the "expiration_time" argument defined for the URL time limit.

B. A scoped URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with a 24-hour time limit for the URL.

C. A pre-signed URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with no time limit for the URL.

D. A file URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with a 7-day time limit for the URL.

正解: A

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

質問 8

A user has the appropriate privilege to see unmasked data in a column.
If the user loads this column data into another column that does not have a masking policy, what will occur?

A. Masked data will be loaded into the new column.

B. Unmasked data will be loaded into the new column but only users with the appropriate privileges will be able to see the unmasked data.

C. Unmasked data will be loaded into the new column and no users will be able to see the unmasked data.

D. Unmasked data will be loaded in the new column.

正解: D

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

質問 9

How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

A. Shared databases are not supported by Time Travel.

B. Shared databases must be refreshed in order for new data to be visible.

C. Shared databases can also be created as transient databases.

D. Shared databases cannot be cloned.

E. Shared databases are read-only.

F. Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share.

正解: A,D,E

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

質問 10

What Snowflake system functions are used to view and or monitor the clustering metadata for a table? (Select TWO).

A. SYSTEMSTABLE_CLUSTERING

B. SYSTEMSCLUSTERING_INFORMATION

C. SYSTEMSCLUSTERING_DEPTH

D. SYSTEMSCLUSTERING

E. SYSTEMSCLUSTERING_RATIO

正解: B,C

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

質問 11

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 minute for the maximum time range.

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

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

正解: C

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

Snowflake SnowPro Advanced: Architect Recertification - ARA-R01 模擬練習