ADA-C01 試験問題を無料オンラインアクセス

A company enabled replication between accounts and is ready to replicate data across regions in the same cloud service provider.
The primary database object is : PROD_AWS_EAST. Location : AWS_EAST
The secondary database object is : PROD_AWS_WEST. Location : AWS_WEST
What command and account location is needed to refresh the data?

• A.Location : AWS_WEST
  Command : REFRESH DATABASE PROD_AWS WEST REFRESH;
• B.Location : AWS_EAST
  Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;
• C.Location : AWS_WEST
  Command : ALTER DATABASE PROD AWS WEST REFRESH;
• D.Location : AWS EAST
  Command: ALTER DATABASE PROD_AWS_WEST REFRESH;

What SCIM integration types are supported in Snowflake? (Select THREE).

• A.Google Cloud Platform (GCP)
• B.Duo Security Provisioning Connector
• C.Custom
• D.Okta
• E.Azure Active Directory (Azure AD)
• F.Amazon Web Services (AWS)

A user accidentally truncated the data from a frequently-modified table. The Administrator has reviewed the query history and found the truncate statement which was run on 2021-12-12 15:00 with query ID 8e5d0ca9-005e-44e6-b858-a8f5b37c5726. Which of the following statements would allow the Administrator to create a copy of the table as it was exactly before the truncated statement was executed, so it can be checked for integrity before being inserted into the main table?

• A.INSERT INTO CURRENT_TABLE SELECT * FROM CURRENT_TABLE before (statement => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');
• B.CREATE TABLE RESTORE_TABLE CLONE CURRENT_TABLE before (statement => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');
• C.CREATE TABLE RESTORE_TABLE CLONE CURRENT_TABLE BEFORE (timestamp => '2021-12-12 00:00');
• D.SELECT * FROM CURRENT_TABLE before (statement => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that will perform the following tasks:
1. At 80% usage notify the account Administrators.
2. At 100% usage suspend the warehouse and notify the account Administrators.
3. At 120% stop all running executions, suspend the warehouse, and notify the account Administrators.
Which SQL command will meet these requirements?

• A.create or replace resource monitor RM1 with credit_quota=3000
  frequency = yearly
  triggers on 80 percent do notify
  on 100 percent do suspend
  on 120 percent do suspend_immediate;
  alter warehouse WH1 set resource_monitor = RM1;
• B.create or replace resource monitor RM1 with credit_quota=3000
  frequency = yearly
  start_timestamp = '2022-01-01 00:00 CET'
  triggers on 80 percent do notify
  on 100 percent do suspend
  on 120 percent do suspend_immediate;
  alter warehouse WH1 set resource monitor = RM1;
• C.create or replace resource monitor RM1 with credit_quota=3000
  start_timestamp = '2022-01-01 00:00 CET'
  triggers on 80 percent do notify
  on 100 percent do suspend
  on 120 percent do suspend_immediate;
  alter warehouse WH1 set resource_monitor = RM1;
• D.create or replace resource monitor RM1 with credit_quota=3000
  start_timestamp = '2022-01-01 00:00 CET'
  triggers on 80 percent do notify
  on 100 percent do notify and suspend
  on 120 percent do notify and suspend_immediate;
  alter warehouse WH1 set resource monitor = RM1;

An Administrator needs to create a sample of the table LINEITEM. The sample should not be repeatable and the sampling function should take the data by blocks of rows.
What select command will generate a sample of 20% of the table?

• A.select * from LINEITEM tablesample block (20 rows);
• B.select * from LINEITEM sample system (20);
• C.select * from LINEITEM sample bernoulli (20);
• D.select * from LINEITEM tablesample system (20) seed (1);