Which statement accurately describes a characteristic of a materialized view?
A. A materialized view can query only a single table.
B. Data accessed through materialized views can be stale.
C. Materialized view refreshes need to be maintained by the user.
D. Querying a materialized view is slower than executing a query against the base table of the view.
The use of which Snowflake table type will reduce costs when working with ETL workflows?
A. External
B. Permanent
C. Temporary
D. Transient
A user wants to unload data from a relational table into a CSV file in an external stage. The table must be named exactly as specified by the user.
Which file format option MUST be used to do this?
A. encoding
B. escape
C. file_extension
D. single
Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?
A. Directory table
B. Temporary table
C. Transient table
D. A table with a materialized view
What is a characteristic of the maintenance of a materialized view?
A. Materialized views cannot be refreshed automatically.
B. An additional set of scripts is needed to refresh data in materialized views.
C. A materialized view is automatically refreshed by a Snowflake managed warehouse.
D. A materialized view can be set up with the auto-refresh feature using the SQL SET command.
Which command should be used to implement a masking policy that was already created in Snowflake?
A. ALTER MASKING POLICY
B. APPLY MASKING POLICY
C. CREATE MASKING POLICY
D. SET MASKING POLICY
Which statement describes Snowflake tables?
A. Snowflake tables are logical representations of underlying physical data.
B. Snowflake tables are the physical instantiation of data loaded into Snowflake.
C. Snowflake tables require that clustering keys be defined to perform optimally.
D. Snowflake tables are owned by a user.
Which type of charts are supported by Snowsight? (Choose two.)
A. Flowcharts
B. Gantt charts
C. Line charts
D. Pie charts S3
E. Scatterplots
A user wants to upload a file to an internal Snowflake stage using a PUT command.
Which tools and/or connectors could be used to execute this command? (Choose two.)
A. SnowCD
B. SnowSQL
C. SQL API
D. Python connector
E. Snowsight worksheets
Which Snowflake view is used to support compliance auditing?
A. ACCESS_HISTORY
B. COPY_HISTORY
C. QUERY_HISTORY
D. ROW_ACCESS_POLICIES
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your SNOWPRO-CORE exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.