Exam SnowPro Core: SnowPro Core
| Exam Number: SnowPro Core | Length of test: 105 mins |
| Exam Name: SnowPro Core | Number of questions in the actual exam: 60 |
| Format: PDF, VPLUS | Passing Score: 70% |
Total Questions: 627
FREE
Premium VPLUS file
Download practice test questions
| Title | Size | Hits | Download |
|---|---|---|---|
| Snowflake.SnowPro-Core.by.Lincy.201q | 840.98 KB | 35 | Download |
Some new questions:
Q
Which Snowflake layer is associated with virtual warehouses?
A. Cloud services
B. Query processing
C. Elastic memory
D. Database storage
Q
What are valid sub-clauses to the OVER clause for a window function? (Select TWO).
A. GROUP BY
B. LIMIT
C. ORDER BY
D. PARTITION BY
E. UNION ALL
Q
What information does the Query Profile provide?
A. Graphical representation of the data model
B. Statistics for each component of the processing plan
C. Detailed Information about I he database schema
D. Real-time monitoring of the database operations
Q
Which common query problems are identified by the Query Profile? (Select TWO.)
A. Syntax error
B. Inefficient pruning
C. Ambiguous column names
D. Queries too large to fit in memory
E. Object does not exist or not authorized
Q
For Directory tables, what stage allows for automatic refreshing of metadata?
A. User stage
B. Table stage
C. Named internal stage
D. Named external stage
Q
What are characteristic of Snowsight worksheet? (Select TWO.)
A. Worksheets can be grouped under folder, and a folder of folders.
B. Each worksheet is a unique Snowflake session.
C. Users are limited to running only one on a worksheet.
D. The Snowflake session ends when a user switches worksheets.
E. Users can import worksheets and share them with other users.
Q
Which privilege is needed for a SnowFlake user to see the definition of a secure view?
A. OWNERSHIP
B. MODIFY
C. CREATE
D. USAGE
…………….