仕事や学業と両立しながらSnowflake SnowPro Advanced Administratorの合格を目指す方にとって、限られた時間をどう使うかが最大の課題です。CertJukenのADA-C01練習問題は80問の厳選された内容で、短い準備期間でも出題範囲を効率よくカバーできます。

Snowflake ADA-C01 試験概要:

認定ベンダー:	Snowflake
試験名:	SnowPro Advanced: Administrator認定試験
試験番号:	ADA-C01
関連資格:	SnowPro Advanced: Architect SnowPro Advanced: Security Engineer SnowPro Core
受験料:	375米ドル
認定の有効期間:	2年間
対応言語:	English
試験時間:	115 分
出題数:	65問
試験形式:	シナリオ設定型問題, 単一選択問題, 複数選択問題
合格点:	750点（0～1000点の評価尺度）
推奨トレーニング:	Snowflake公式トレーニング
受験申し込み:	Pearson VUEでの受験登録
サンプル問題:
受験方法:	OnVUEによるオンライン監視付き受験、またはPearson VUE試験会場での受験
前提条件:	有効なSnowPro Core認定資格を保有し、かつSnowflakeの運用管理に関する実務経験が2年以上あること
公式シラバスのURL:	https://learn.snowflake.com/en/certifications/snowpro-advanced-administrator-c01/

Snowflake ADA-C01 試験シラバストピック:

Snowflake SnowPro Advanced Administratorに関するよくある質問

Snowflake SnowPro Advanced Administrator 認定 ADA-C01 試験問題：

問題 #1

What is required for stages, without credentials, to limit data exfiltration after a storage integration and associated stages are created?

A. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = true;
B. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = false;
C. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = true;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = false;
D. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION FOR STAGE_OPERATION = true;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = true;

問題 #2

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

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

問題 #3

Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

A. Reset a Snowflake user's password
B. Create new users
C. Create new roles
D. Manage system grants

問題 #4

The ACCOUNTADMIN of Account 123 works with Snowflake Support to set up a Data Exchange. After the exchange is populated with listings from other Snowflake accounts, what roles in Account 123 are allowed to request and get data?

A. Only the ACCOUNTADMIN role, and no other roles
B. Any role that the listing provider has designated as authorized
C. Any role with IMPORT SHARE and CREATE DATABASE privileges
D. Any role with USAGE privilege on the Data Exchange

問題 #5

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. SELECT * FROM CURRENT_TABLE before (statement => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');
B. INSERT INTO CURRENT_TABLE SELECT * FROM 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. CREATE TABLE RESTORE_TABLE CLONE CURRENT_TABLE before (statement => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

解説：