An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it into different production tables…

Question

Options

• ACreate it as an external table, which will not incur Time Travel costs.
• BCreate it as a transient table with a retention time of 0 days.
• CCreate it as a temporary table with a retention time of 0 days.
• DCreate it as a permanent table with a retention time of 0 days.

• A
  2% (1)
• B
  76% (32)
• C
  7% (3)
• D
  14% (6)

Explanation

A transient table is a type of table that does not support Time Travel or Fail-safe, which means that it does not incur any storage costs for maintaining historical versions of the data or backups for disaster recovery. A transient table can be dropped at any time, and the data is not recoverable. A transient table can also have a retention time of 0 days, which means that the data is deleted immediately after the table is dropped or truncated. Therefore, creating the staging table as a transient table with a retention time of 0 days can minimize the storage costs and maximize the performance, as the data is only loaded and transformed once, and then deleted after the production tables are populated.

No community discussion yet for this question.