1
Q
Which of the following will contribute to your account level storage usage?
A
- Snowflake Internal Stage
- Database (and the tables in it)
2
Q
What are the connectors & programs that can be downloaded under the Download section of Snowflake web UI?
A
- ODBC Driver
- JDBC Driver
- SnowSQL
3
Q
A snowflake share…
A
- has information about the consumer(s)
- is a container that contains objects to be shared
4
Q
To close a database your current role must have which privilege on the source database?
A
- USAGE
5
Q
Which properties can be set for a multi-cluster warehouse?
A
- MIN_CLUSTER_COUNT
- MAX_CLUSTER_COUNT
- AUTO_RESUME
- AUTO_SUSPEND
6
Q
The binary data type can store what amount of data?
A
8 MB
7
Q
How much data can the VARCHAR data type store?
A
16MB
SNOWFLAKE_PRO_CORE
flashcards
Decks in class (22)
# Cards
-
D1.1 - EXPLAIN HOW TO MANAGE SNOWFLAKE ACCOUNTS4
-
D1.2 - OUTLINE SECURITY PRINCIPLES6
-
D1.3 - DEFINE THE ENTITIES AND ROLES THAT ARE USED IN SNOWFLAKE3
-
D1.4 - EXPLAIN THE SECURITY CAPABILITIES ASSOCIATED WITH EACH SNOWFLAKE EDITION6
-
D1.5 - OUTLINE DATA GOVERNANCE CAPABILITES IN SNOWFLAKE5
-
D2.1 - OUTLINE COMPUTING PRINCIPLES22
-
D2.2 - EXPLAIN VIRTUAL WAREHOUSE BEST PRACTICES8
-
D3.1 - OUTLINE DIFFERENT COMMANDS USED TO LOAD DATA AND WHEN THEY SHOULD BE USED16
-
D3.2 - DEFINE BULK AS COMPARED TO CONTINUOUS DATA LOADING METHODS2
-
D3.3 - DEFINE BEST PRACTICES THAT SHOULD BE CONSIDERED WHEN LOADING DATA7
-
D3.4 - OUTLINE HOW DATA CAN BE UNLOADED FROM SNOWFLAKE TO EITHER LOCAL STORAGE OR CLOUD STORAGE3
-
D3.5 - EXPLAIN HOW TO WORK AND LOAD SEMI-STRUCTURED DATA5
-
D4.1 - OUTLINE BEST PRACTICES FOR SNOWFLAKE PERFORMANCE MANAGEMENT ON STORAGE7
-
D4.2 - OUTLINE BEST PRACTICES FOR SNOWFLAKE PERFORMANCE MANAGEMENT ON VIRTUAL WAREHOUSES6
-
D5.1 - OUTLINE KEY COMPONENTS OF SNOWFLAKES CLOUD DATA PLATFORM12
-
D5.2 - OUTLINE SNOWFLAKE DATA SHARING CAPABILITIES6
-
D5.3 - EXPLIAN HOW SNOWFLAKE IS DIFFERENT COMPARED TO LEGACY WAREHOUSE SOLUTIONS4
-
D5.5 - IDENTIFY SNOWFLAKE's PARTNER ECOSYSTEM2
-
D5.6 - OUTLINE AND DEFINE THE PURPOSE OF SNOWFLAKES THREE DISTINCT LAYERS4
-
D5.7 - OUTLINE SNOWFLAKES CATALOG AND OBJECTS12
-
SAMPLE QUESTIONS7
-
FOCUS QUESTIONS6
