SnowPro Core 시험 - Snowflake실제시험문제와 답 - 100문항

Question No : 1

Which of the following statements is true of data loading?

A.Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
B.The "deal file size for loading is 16MB to match micro-partition size
C.Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file

정답:

Question No : 2

True or False: A single database can exist in more than one Snowflake account.

A.True
B.False

정답:
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

Question No : 3

Which of the following commands sets the Virtual Warehouse for a session?

A.COPT WAREHOUSE FROM <<Config file> ;
B.SET warehouse = <<warehouse name>>;
C.USE WAREHOUSE <<warehouse name>>;
D.USE VIRTUAL_WAREHOUSE <<warehouse name>>;

정답:
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

Question No : 4

Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers

A.MIN(< < column value>>)
B.COPY
C.SUM(<< column value >>)
D.UPDATE

정답:

Question No : 5

What is the minimum duration charged when starting a virtual warehouse?

A.1 second
B.1 minute
C.1 hour
D.1 day

정답:

Question No : 6

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

A.Users
B.Tables
C.Databases
D.Internal Stages

정답:

Question No : 7

Which of the following commands are not blocking operations?
Choose 2 answers

A.UPDATE
B.INSERT
C.MERGE
D.COPY

정답:

Question No : 8

Which type of table corresponds to a single Snowflake session?

A.Temporary
B.Translent
C.Provisional
D.Permanent

정답:

Question No : 9

The fail-safe retention period is how many days?

A.1 day
B.7 days
C.45 days
D.90 days

정답:
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

Question No : 10

Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy?

A.Account -> Schema -> Database -> Table
B.Account -> Database -> Schema -> Table
C.Database -> Schema -> Table -> Account
D.Database -> Table -> Schema -> Account

정답:
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

Question No : 11

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

A.Configure the Maximum Clusters setting to “Auto-Scale”
B.Set the Warehouse type to “Auto”
C.Set the Minimum Clusters and Maximum Clusters settings to the same value
D.Set the Minimum Clusters and Maximum Clusters settings to the different values

정답:
Explanation:
Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

Question No : 12

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

A.True
B.False

정답:

Question No : 13

What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?

A.INITTIALLY_SUSPENDED = TRUE/FALSE
B.START_AFTCR_CREATE = TRUE/FALSE
C.START_TTIME = 60 // (seconds from now)
D.STAR
E.TIME = CURREN
F.DATE()

정답:

Question No : 14

True or False: The COPY command must specify a File Format in order to execute.

A.True
B.False

정답:

Question No : 15

What is the most granular object that the Time Travel retention period can be defined on?

A.Account
B.Database
C.Schema
D.Table

정답:

Snowflake SnowPro Core 시험