A company has a table with that has corrupted data, named Data. The company wants to recover the data as it was 5 minutes ago using cloning and Time Travel.
What command will accomplish this?
A. CREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);
B. CREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);
C. CREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);
D. CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
What does a Snowflake Architect need to consider when implementing a Snowflake Connector for Kafka?
A. 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.
B. The default retention time for Kafka topics is 14 days.
C. The Kafka connector supports key pair authentication, OAUTH. and basic authentication (for example, username and password).
D. Every Kafka message is in JSON or Avro format.
正解:D
質問 3:
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 table has a masking policy.
B. Tables cannot be cloned from a higher environment to a lower environment.
C. The retention time for the table is set to zero.
D. The table is transient.
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
When activating Tri-Secret Secure in a hierarchical encryption model in a Snowflake account, at what level is the customer-managed key used?

A. At the micro-partition level
B. At the root level (HSM)
C. At the account level (AMK)
D. At the table level (TMK)
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
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 VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema.
C. Assume role with OWNERSHIP on future tables and ADD SEARCH OPTIMIZATION on the SECURITY_LOGS schema.
D. Assume role with ALL PRIVILEGES on VPN_ACCESS_LOGS and ADD SEARCHOPTIMIZATION in the SECURITY_LOGS schema.
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 6:
Company A would like to share data in Snowflake with Company B. Company B is not on the same cloud platform as Company A.
What is required to allow data sharing between these two companies?
A. Company A and Company B must agree to use a single cloud platform: Data sharing is only possible if the companies share the same cloud provider.
B. Ensure that all views are persisted, as views cannot be shared across cloud platforms.
C. Setup data replication to the region and cloud platform where the consumer resides.
D. Create a pipeline to write shared data to a cloud storage location in the target cloud provider.
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 7:
Is it possible for a data provider account with a Snowflake Business Critical edition to share data with an Enterprise edition data consumer account?
A. If a user in the provider account with a share owning role which also has override share restrictions privilege share_restrictions set to False when adding an Enterprise consumer account, it can import the share.
B. A Business Critical account cannot be a data sharing provider to an Enterprise consumer. Any consumer accounts must also be Business Critical.
C. If a user in the provider account with a share owning role sets share_restrictions to False when adding an Enterprise consumer account, it can import the share.
D. If a user in the provider account with role authority to create or alter share adds an Enterprise account as a consumer, it can import the share.
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 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. All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.
C. Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.
D. Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
Aoyama -
なかなかARA-C01試験でいい点は取れると思う。解釈でわかりやく内容を明示。つまづきやすいポイントをフォローしてくれてる。