Absolute Free ADA-C01 Exam Practice for Comprehensive Preparation 

The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.

To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.

Users can have unlimited primary databases and they can be replicated to an unlimited number of accounts if all accounts are within the same organization.

create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;

create transient table TRANSIENT SALES DATA as select * from SALES_DATA copy grants;

Use the following SQL commands:

create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants; insert into TRANSIENT_SALES_DATA select * from SALES_DATA;