最新Snowflake DEA-C01考试练习题库, 帮您学习DEA-C01考试知识点

下列DEA-C01练习题是Snowflake DEA-C01完整题库的一部分. DEA-C01完整练习题库共有130道题. Examook最新DEA-C01练习题库可以助您顺利通过考试. 如果您使用我们的题库没有效果, 我们将全额退还您的购买费用. 想要测试和学习Eaxmook DEA-C01练习题库? 现在开始吧!

完整 DEA-C01 练习题库

Snowflake DEA-C01 练习题库

DEA-C01 w练习题库的更新日期是 2025-03-13 .

正在练习第 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-03-13

完整 DEA-C01 练习题库

关于 DEA-C01 考试

题目#1

题目#2

题目#3

题目#4

题目#5

热门考试

Shop Categories