Chapter 3: Interfaces Connectivity Flashcards
Consider the Worksheets view on the classic Snowflake web UI. Which of the following can you select for each worksheet? (Select all that apply.)
Database
User
Table
Schema
Virtual Warehouse
Database
Schema
Virtual Warehouse
Which of the following connectors and programs can be downloaded from the Downloads section in the Snowflake web UI? (Select all that apply.)
Go Snowflake driver
JDBC driver
Snowpipe connector
OAuth driver
Kerberos driver
Go Snowflake driver
JDBC driver
On the classic Snowflake web UI, which button on the top bar takes you to the screen where you can create new compute clusters?
Databases
Account
Warehouses
Worksheets
Warehouses
True or False: You can open only a single worksheet in the Snowflake web UI.
True
False
False
On the classic Snowflake web UI, which of the following are buttons on the top navigation bar? (Select all that apply.)
Worksheets
Warehouses
Databases
Security
Worksheets
Warehouses
Databases
You have logged into the Snowflake web UI but cannot see the Account button in the top bar. Which one of the following could be the reason?
Snowflake has renamed the Account button to Organization.
The Account button is only available to users with the ACCOUNTADMIN or SECURITYADMIN role. However, your current role is neither of these two roles.
The Account button is shown in only specific browsers.
The Account button is shown only for those Snowflake accounts who have the Enterprise license.
The Account button is only available to users with the ACCOUNTADMIN or SECURITYADMIN role. However, your current role is neither of these two roles.
What functionality can you access under the Warehouses button? (Select all that apply.)
Review billing and cost information related to virtual warehouses.
Create new virtual warehouses.
Suspend or resume existing virtual warehouses.
See the percentage of space used by each virtual warehouse.
Create new virtual warehouses.
Suspend or resume existing virtual warehouses.
True or False: A Snowflake user can configure multifactor authentication (MFA) through the Snowflake Web UI.
True
False
True
You are developing a program in Java. The program needs to connect to a Snowflake instance and run queries. To connect to the Snowflake database, which one of the following drivers will you need?
Go Snowflake driver
JDBC driver
Snowpipe connector
ODBC driver
CLI client (SnowSQL)
JDBC driver
You plan to use a business intelligence tool to connect to Snowflake to create new reports and dashboards. Which of the following are possible drivers that you can use in the tool to connect to Snowflake? (Select all that apply.)
Python connector
JDBC driver
ODBC driver
Spark connector
CLI client (SnowSQL)
JDBC driver
ODBC driver
Which type of Snowflake partner is Matillion?
Data Integration
Business intelligence
Machine learning and data science
SQL development and management
Security and governance
Data Integration
