Practice Free SnowPro Core Exam Online Questions
What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?
- A . Standard
- B . Enterprise
- C . Business Critical
- D . Virtual Private Snowflake
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
- A . True
- B . False
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
- A . True
- B . False
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
- A . The number of queries executed
- B . The number of active users assigned to the warehouse
- C . The size of the virtual warehouse
- D . The length of time the warehouse is running
- E . The duration of the queries that are executed
How many resource monitors can be assigned at the account level?
- A . 1
- B . 2
- C . 3
- D . 4
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
- A . CONTENT
- B . PATH
- C . BYTE_SIZE
- D . INDEX
- E . DATATYPE
What is a responsibility of Snowflake’s virtual warehouses?
- A . Infrastructure management
- B . Metadata management
- C . Query execution
- D . Query parsing and optimization
- E . Management of the storage layer
True or False: A Virtual Warehouse can be resized while suspended.
- A . True
- B . False
A user has 10 files in a stage containing new customer data.
The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?
- A . All data from all of the files on the stage will be appended to the table
- B . Only data about new customers from the new files will be appended to the table
- C . The operation will fail with the error uncertain files in stage.
- D . All data from only the newly-added files will be appended to the table.
In a Snowflake role hierarchy, what is the top-level role?
- A . SYSADMIN
- B . ORGADMIN
- C . ACCOUNTADMIN
- D . SECURITYADMIN