Snowflake ADA-C01 問題集

質問 1：
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 メンバーにのみ表示されます)

質問 2：
For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?
A. The account_level policy will override the user_level policy.
B. A network policy error will be generated with no definitions provided.
C. The user_level policy will override the account_level policy.
D. The user_level network policies will not be supported.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
An Administrator has been asked to support the company's application team need to build a loyalty program for its customers. The customer table contains Personal Identifiable Information (PII), and the application team's role is DEVELOPER.
CREATE TABLE customer_data (
customer_first_name string,
customer_last_name string,
customer_address string,
customer_email string,
... some other columns,
);
The application team would like to access the customer data, but the email field must be obfuscated.
How can the Administrator protect the sensitive information, while maintaining the usability of the data?
A. Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data.
B. Create a separate table for all the non-Pll columns and grant the role DEVELOPER access to the new table.
C. Create a view on the customer_data table to eliminate the email column by omitting it from the SELECT clause. Grant the role DEVELOPER access to the view.
D. Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that contain sensitive data.
正解：D

質問 4：
A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database.
For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?
A. To save costs on warehouse shutdowns and startups for different queries
B. To save costs by running the warehouse as little as possible
C. To keep the data cache warm to support good performance of similar queries
D. To keep the query result cache warm for good performance on repeated queries
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
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 メンバーにのみ表示されます)

質問 6：
A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters busy all of the time, and occasionally they need three or four clusters of that size.
Based on this scenario, how should the Administrator set up a virtual warehouse to MOST efficiently support this group of users?
A. Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.
B. Create four virtual warehouses (sized Small through XL) and set them to auto-suspend and auto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run.
C. Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.
D. Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 7：
If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?
A. No, because the optimizer might decide against it.
B. No, because joins are not supported by materialized views.
C. Yes, because materialized views are always faster.
D. No, because the materialized view may not be up-to-date.
正解：A
解説: (Topexam メンバーにのみ表示されます)