ARA-C01 試験問題を無料オンラインアクセス

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 are read-only.
• C.Shared databases can also be created as transient databases.
• D.Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share.
• E.Shared databases cannot be cloned.
• F.Shared databases must be refreshed in order for new data to be visible.

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

Assuming all Snowflake accounts are using an Enterprise edition or higher, in which development and testing scenarios would be copying of data be required, and zero-copy cloning not be suitable? (Select TWO).

• A.The release process requires pre-production testing of changes with data of production scale and complexity. For security reasons, pre-production also runs in the production account.
• B.Production and development run in different databases in the same account, and Developers need to see production-like data but with specific columns masked.
• C.Data is in a production Snowflake account that needs to be provided to Developers in a separate development/testing Snowflake account in the same cloud region.
• D.Developers create their own datasets to work against transformed versions of the live data.
• E.Developers create their own copies of a standard test database previously created for them in the development account, for their initial development and unit testing.

A new user user_01 is created within Snowflake. The following two commands are executed:
Command 1# SHOW GRANTS TO USER user_01;
Command 2# SHOW GRANTS ON USER user_01;
What inferences can be made about these commands?

• A.Command 1 defines all the grants which are given to user_01Command 2 defines which role owns user_01
• B.Command 1 defines which user owns user_01Command 2 defines all the grants which have been given to user_01
• C.Command 1 defines all the grants which are given to user_01Command 2 defines which user owns user_01
• D.Command 1 defines which role owns user_01Command 2 defines all the grants which have been given to user_01

Which of the following are characteristics of Snowflake's parameter hierarchy?

• A.Session parameters override virtual warehouse parameters.
• B.Virtual warehouse parameters override user parameters.
• C.Table parameters override virtual warehouse parameters.
• D.Schema parameters override account parameters.