Snowflake SnowPro Core 問題練習

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

答えを確認する

正解: