ADA-C02 無料問題集「Snowflake SnowPro Advanced Administrator ADA-C02」

（A）The account name is immutable and cannot be changed.

（B）The account requires at least one ORGADMIN role within one of the organization's accounts.

（C）The account name must be unique among all Snowflake customers.

（D）The account name must be specified when the account is created.

（E）The account name must be unique within the organization.

（A）Use bi-directional data sharing among offices in the same region and replication among offices across the continents.

（B）Use the PUT command to move files to an Amazon S3 bucket and Azure Blobs, and use an external file management application to move files within the corporate VPC.

（C）Move all the Snowflake accounts to a single region, and implement data sharing.

（D）Use data replication everywhere to reduce costs associated with same-region sharing.

（A）SELECT * FROM my_table AT(OFFSET => -60*30);

（B）SELECT * FROM TIME_TRAVEL('MY_TABLE', 2021-01-01 07:00:00);

（C）SELECT * FROM my_table WITH TIME TRAVEL(OFFSET => -60*30);

（D）SELECT * FROM my_table BEFORE(STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

（E）SELECT * FROM my_table AT(TIMESTAMP => '2021-01-01 07:00:00'::timestamp);

（F）SELECT * FROM my_table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';

（A）The table is not big enough to take advantage of the clustering key.

（B）The STORE_ID should be numeric.

（C）The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.

（D）Sales across stores are not uniformly distributed.

（A）IMPORT SHARE and CREATE DATABASE

（B）SECURITYADMIN

（C）SYSADMIN

（D）ACCOUNTADMIN

（E）IMPORT PRIVILEGES and SHARED DATABASE

（A）If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.

（B）Queries executed within a given transaction see that transaction's uncommitted changes.

（C）A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.

（D）Transaction locking in Snowflake is enforced exclusively at the row and table levels.

（A）Auto-suspend does not apply for multi-cluster warehouses.

（B）After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.

（C）When the minimum number of clusters is running and there is no activity for the specified period of time.

（D）When there has been no activity on any cluster for the specified period of time.