sales@kaozhengpro.com

下列 DEA-C01 練習題僅為 Kaozhengpro 考證寶完整題庫中的一部分。完整版本共收錄 130 題最新考題與模擬試題,幫助您全面掌握考試重點。Kaozhengpro 提供的 DEA-C01 完整題庫,內容定期更新、緊貼官方考綱,能有效提升您的應試信心與通過率。若您使用題庫後仍未達到理想效果,我們將提供 全額退款保障。立即開始測試與學習,體驗專業題庫帶來的高效備考!

 完整DEA-C01題庫

Snowflake DEA-C01 免費練習題庫

DEA-C01 題庫的更新日期是 2025-10-26 .

正在練習第 1 頁,共 6 頁。

正在練習第 1 題,共 32 題

題目#1

Let's say you have a schema name MY_SCHEMA. This schema contains two permanent tables as shown below
CREATE TABLE MY_TABLE_A (C1 INT)
DATA_RETENTION_TIME_IN_DAYS = 10;
CREATE TABLE MY_TABLE_B (C1 INT);
What will be the impact of running the following command?
ALTER SCHEMA MY_SCHEMA SET DATA_RETENTION_TIME_IN_DAYS = 20;
A. Data retention time cannot be set at SCHEMA level, hence it will fail
B. The retention time on MY_TABLE_A does not change; MY_TABLE_B will be set to 20 days
C. The retention time on both the tables will be set to 20 days
D. The retention time will not change for both tables

A. B
Explanation
https://docs.snowflake.com/en/user-guide/data-time-travel.html#changing-the-data-retention-period-for-an-object
Changing the retention period for your account or individual objects changes the value for all lower-level objects that do not have a retention period explicitly set. For example:
If you change the retention period at the account level, all databases, schemas, and tables that do not have an explicit retention period automatically inherit the new retention period.
If you change the retention period at the schema level, all tables in the schema that do not have an explicit retention period inherit the new retention period.
Keep this in mind when changing the retention period for your account or any objects in your account because the change might have Time Travel consequences that you did not anticipate or intend. In particular, we do not recommend changing the retention period to 0 at the account level.

題目#2

Which of the below statements are true for API integration object?

A. Only Snowflake users who have the ACCOUNTADMIN role or who have a role with the global CREATE INTEGRATION privilege can execute CREATE API INTEGRATIO
B. Only Snowflake roles with OWNERSHIP or USAGE privileges on the API integration can use the API integration directly (e.g. by creating an external function that specifies that API integration).
C. An API integration object is tied to a specific cloud platform account and role within that account, but not to a specific HTTPS proxy UR
D. You can create more than one instance of an HTTPS proxy service in a cloud provider account, and you can use the same API integration to authenticate to multiple proxy services in that account.
E. Your Snowflake account can have multiple API integration objects, for example, for different cloud platform accounts.
F. Multiple external functions can use the same API integration object, and thus the same HTTPS proxy service.
G. ALL OF THE ABOVE

題目#3

Each micro partition contains between 50 mb and 500 MB of uncompressed data

A. TRUE
B. FALSE

題目#4

Which of the below are benefits of micro partitioning?

A. Micro partitions are derived automatically
B. Micro partitions need to be maintained by users
C. Micro partitions enables extremely efficient DML and fine-grained pruning for faster queries
D. Columns are stored independently within micro-partitions
E. Columns are compressed individually within micro-partitions

題目#5

You have just created a table in snowflake. There are now rows in the table.
What will be the clustering depth of the table?

A. 0
B. 1
C. 2
D. 3

考題代碼: DEA-C01題庫題數: 130 題更新時間:  2025-10-26

 完整 DEA-C01 題庫

商品分類