最新なSnowflake ADA-C01問題集（80題）、真実試験の問題を全部にカバー！

質問 1：
When a role is dropped, which role inherits ownership of objects owned by the dropped role?
A. The role executing the command
B. The SECURITYADMIN role
C. The SYSADMIN role
D. The role above the dropped role in the RBAC hierarchy
正解：D
解説: (Pass4Test メンバーにのみ表示されます)

質問 2：
A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount of data from micro-partitions. The same user wants to run another query that uses the same data set.
Which action would provide optimal performance for the second SQL query?
A. Prevent the virtual warehouse from suspending between the running of the first and second queries.
B. Assign additional clusters to the virtual warehouse.
C. Use the RESULT_SCAN function to post-process the output of the first query.
D. Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)

質問 3：
A user with the proper role issues the following commands when setting up and activating network policies:
CREATE OR REPLACE NETWORK POLICY foo_policy
ALLOWED_IP_LIST = ( '1.1.1.0/24', '2.2.2.0/24' , '3.3. 3. 0/24' )
BLOCKED IP LIST = ( '1.1.1.1')
COMMENT = 'Account level policy';
ALTER ACCOUNT SET NETWORK_POLICY=FOO_POLICY;
CREATE OR REPLACE NETWORK POLICY bar_policy
ALLOWED_IP_LIST = ('3.3.3.0/24')
BLOCKED IP LIST = ('3.3.3.10')
COMMENT = 'user level policy';
ALTER USER userl SET NETWORK_POLICY=BAR_POLICY;
Afterwards, user1 attempts to log in to Snowflake from IP address 3.3.3.10.
Will the login be successful?
A. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.
B. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.
C. No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.
D. No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.
正解：D
解説: (Pass4Test メンバーにのみ表示されます)

質問 4：
What roles can be used to create network policies within Snowflake accounts? (Select THREE).
A. SYSADMIN
B. ORGADMIN
C. Any role that owns the database where the network policy is created
D. SECURITYADMIN
E. Any role with the global permission of CREATE NETWORK POLICY
F. ACCOUNTADMIN
正解：D,E,F
解説: (Pass4Test メンバーにのみ表示されます)

質問 5：
An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it into different production tables.
How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?
A. Create it as an external table, which will not incur Time Travel costs.
B. Create it as a temporary table with a retention time of 0 days.
C. Create it as a permanent table with a retention time of 0 days.
D. Create it as a transient table with a retention time of 0 days.
正解：D
解説: (Pass4Test メンバーにのみ表示されます)

質問 6：
A user has enrolled in Multi-factor Authentication (MFA) for connecting to Snowflake. The user informs the Snowflake Administrator that they lost their mobile phone the previous evening.
Which step should the Administrator take to allow the user to log in to the system, without revoking their MFA enrollment?
A. Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.
B. Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.
C. Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.
D. Alter the user and set MINS TO BYPASS MFA to a value that will disable MFA long enough for the user to log in.
正解：D
解説: (Pass4Test メンバーにのみ表示されます)