Pass with ARA-C01 Practice Materials 100% for sure

What is the MOST efficient way to design an environment where data retention is not considered critical, and customization needs are to be kept to a minimum?

• A. Use a temporary table.
• B. Use a transient schema.
• C. Use a transient table.
• D. Use a transient database.

Which functions does the Data Build Tool (dbt) facilitate? (Select TWO).

• A. Data testing
• B. Data loading
• C. Data transformation
• D. Data visualization
• E. Data replication

An Architect has a table called leader_follower that contains a single column named JSON. The table has one row with the following structure:
{
"activities": [
{ "activityNumber": 1, "winner": 5 },
{ "activityNumber": 2, "winner": 4 }
],
"follower": {
"name": { "default": "Matt" },
"number": 4
},
"leader": {
"name": { "default": "Adam" },
"number": 5
}
}
Which query will produce the following results?
ACTIVITY_NUMBER
WINNER_NAME
1
Adam
2
Matt

• A. value:winner = lf.json:leader.number,
  lf.json:leader.name.default,
  lf.json:follower.name.default
  )::VARCHAR AS winner_name
  FROM leader_follower lf,
  LATERAL FLATTEN(input => json:activities) p;
• B. value:winner = lf.json:leader.number,
  lf.json:leader,
  lf.json:follower
  )::VARCHAR AS winner_name
  FROM leader_follower lf,
  LATERAL FLATTEN(input => json:activities) p;
• C. value:activityNumber AS activity_number,
  IFF(
• D. SELECT
• E. SELECT
• F. SELECT lf.json:activities.activityNumber AS activity_number,
  IFF(
  lf.json:activities.activityNumber = lf.json:leader.number,
  lf.json:leader.name.default,
  lf.json:follower.name.default
  )::VARCHAR
  FROM leader_follower lf;
• G. value:winner = lf.json:leader.number,
  lf.json:leader.name.default,
  lf.json:follower.name.default
  )::VARCHAR AS winner_name
  FROM leader_follower lf,
  LATERAL FLATTEN(input => json:activities, outer => TRUE) p;
• H. SELECT
• I. value:activityNumber AS activity_number,
  IFF(
• J. value:activityNumber AS activity_number,
  IFF(

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 a Snowflake task to trigger a stored procedure to copy data.
• B. Use CREATE TABLE ... AS SELECT (CTAS) statements.
• C. Use zero-copy cloning into permanent tables.
• D. Use zero-copy cloning into transient tables.

A team needs to recover data after pipeline failures or business rule violations.
Requirements:
* Database recoverable for 48 hours
* Analytics schema recoverable for 5 days
What is the correct approach?

• A. Use Time Travel with MIN_DATA_RETENTION_TIME_IN_DAYS = 2 and
  DATA_RETENTION_TIME_IN_DAYS = 5 on the ANALYTICS schema.
• B. Use Time Travel with DATA_RETENTION_TIME_IN_DAYS = 2 and
  MIN_DATA_RETENTION_TIME_IN_DAYS = 5 on the ANALYTICS schema.
• C. Use tasks with database and schema clones.
• D. Use custom stored procedure backups.