ExamGecko
Search Search Login
Home Home / Snowflake / ARA-C01
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

What is a valid object hierarchy when building a Snowflake environment?
What is a characteristic of event notifications in Snowpipe?
A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy. Which requirements will be addressed with this approach? (Choose two.)
What transformations are supported in the below SQL statement? (Select THREE). CREATE PIPE ... AS COPY ... FROM (...)
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 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.)
How can the Snowpipe REST API be used to keep a log of data load history?
The following DDL command was used to create a task based on a stream: Assuming MY_WH is set to auto_suspend -- 60 and used exclusively for this task, which statement is true?
At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?
Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)

Question 2 - ARA-C01 discussion

Report
Export

A company has a table with that has corrupted data, named Dat

a. 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 CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);
Answers
A.
CREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);
B.
CREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);
Answers
B.
CREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);
C.
CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);
Answers
C.
CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);
D.
CREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);
Answers
D.
CREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);
Suggested answer: C

Explanation:

This is the correct command to create a clone of the table Data as it was 5 minutes ago using cloning and Time Travel. Cloning is a feature that allows creating a copy of a database, schema, table, or view without duplicating the data or metadata. Time Travel is a feature that enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period. To create a clone of a table at a point in time in the past, the syntax is:

CREATE TABLE <clone_name> CLONE <source_table> AT (OFFSET => <offset_in_seconds>);

The OFFSET parameter specifies the time difference in seconds from the present time. A negative value indicates a point in the past. For example, -60*5 means 5 minutes ago. Alternatively, the TIMESTAMP parameter can be used to specify an exact timestamp in the past.The clone will contain the data as it existed in the source table at the specified point in time12.

Snowflake Documentation: Cloning Objects

Snowflake Documentation: Cloning Objects at a Point in Time in the Past

Show Answer
asked 23/09/2024
John Murphy
32 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms