Snowflake ADA-C01 問題集

質問 1：
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 system (20) seed (1);
B. select * from LINEITEM sample bernoulli (20);
C. select * from LINEITEM tablesample block (20 rows);
D. select * from LINEITEM sample system (20);
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
In which scenario will use of an external table simplify a data pipeline?
A. When accessing a Snowflake table from a relational database
B. When accessing a Snowflake table from an external database within the same region
C. When accessing a Snowflake table that references data files located in cloud storage
D. When continuously writing data from a Snowflake table to external storage
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A requirement has been identified to allow members of a corporate Data Product team to bring in data sets from the Snowflake Marketplace. The members of this team use the role DP_TEAM.
What grant statements must the ACCOUNTADMIN execute in order for the DP TEAM role to import and work with data from the Marketplace?
A. grant usage on snowflake_marketplace to role dp_team;
grant create database on account to role dp_team;
B. grant imported privileges on account to role dp_team;
grant create database on account to role dp_team;
C. grant import share on account to role dp_team;
grant create database on account to role dp_team;
D. grant marketplace in account to role dp_team;
grant create database from share to role dp_team;
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A Snowflake account is configured with SCIM provisioning for user accounts and has bi-directional synchronization for user identities. An Administrator with access to SECURITYADMIN uses the Snowflake UI to create a user by issuing the following commands:
use role USERADMIN;
create or replace role DEVELOPER_ROLE;
create user PTORRES PASSWORD = 'hello world!' MUST_CHANGE_PASSWORD = FALSE default_role = DEVELOPER_ROLE; The new user named PTORRES successfully logs in, but sees a default role of PUBLIC in the web UI. When attempted, the following command fails:
use DEVELOPER_ROLE;
Why does this command fail?
A. USERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER.
B. The new role will only take effect once the identity provider has synchronized by way of SCIM with the Snowflake account.
C. The DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able to use the role.
D. The new role can only take effect after USERADMIN has logged out.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
What are benefits of using Snowflake organizations? (Select TWO).
A. Administrators have the ability to create accounts in any available cloud provider or region.
B. Administrators can change Snowflake account editions on-demand based on need.
C. Administrators can simplify data movement across all accounts within the organization.
D. User administration is simplified across all accounts within the organization.
E. Administrators can monitor and understand usage across all accounts in the organization.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)