Free certification test prep

QUESTION 50
True or False: You can resize a Virtual Warehouse while queries are running.

QUESTION 51
Select the different types of Internal Stages: (Choose three.)

QUESTION 52
On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers

QUESTION 53
Select the three types of tables that exist within Snowflake.
Choose 3 answers

QUESTION 54
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

QUESTION 55
How many shares can be consumed by single Data Consumer?

QUESTION 56
True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

QUESTION 57
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

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

QUESTION 59
In which layer of its architecture does Snowflake store its metadata statistics?

QUESTION 60
True or False: Snowflake charges a premium for storing semi-structured data.

QUESTION 61
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

QUESTION 62
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

QUESTION 63
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

QUESTION 64
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

QUESTION 65
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

QUESTION 66
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

QUESTION 67
What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.