Practice Free COF-C03 Exam Online Questions
The query is using only one large table
Which data object should be created to improve the performance?
- A . A secure view
- B . A materialized view
- C . A standard view
- D . A hybrid table
Which view or feature can be used to analyze query performance to identify which operations are the most time-consuming?
- A . The search optimization service
- B . The QUERY_HISTORY view
- C . The Query Profile
- D . The WAREHOUSE_LOAD_HISTORY view
Which feature is used to optimize storage performance?
- A . Search optimization service
- B . Materialized view
- C . Automatic Clustering
- D . Hybrid table
A size Medium standard virtual warehouse is being used to continuously load data. The data will be consumed using reports.
Which step will optimize costs?
- A . Create separate warehouses for each workload.
- B . Enable the query acceleration service.
- C . Change to a multi-cluster warehouse.
- D . Resize the warehouse to size Small.
A size Medium standard virtual warehouse is being used to continuously load data. The data will be consumed using reports.
Which step will optimize costs?
- A . Create separate warehouses for each workload.
- B . Enable the query acceleration service.
- C . Change to a multi-cluster warehouse.
- D . Resize the warehouse to size Small.
Which scaling feature will start a new cluster only when the system estimates there is enough query load to keep the cluster busy for at least 6 minutes?
- A . The Standard scaling policy
- B . The Economy scaling policy
- C . Auto-scale mode
- D . Maximized mode
How does the search optimization service use the search access path?
- A . By generating a real-time index for all data in a database
- B . By creating an up-to-date catalog of all tables in a database
- C . By listing all queries that have been executed on the table data
- D . By identifying where column-level values are in each micro-partition
Which security features are used to control inbound access to Snowflake and internal stages? (Choose two.)
- A . Network rules
- B . Feature policies
- C . Network policies
- D . Packages policies
- E . Authentication policies
Which queries can be executed in parallel using the query acceleration service? (Choose two.)
- A . Large scans that delete many rows and columns
- B . Large scans that use an aggregation or selective filter
- C . Queries with complex joins on small tables
- D . Small scans that read and write rows very slowly
- E . Large scans that insert many new rows
Bulk data is being loaded from an external stage every day, using this command:
COPY INTO source_table –
FROM s3://source/data/files –
STORAGE_INTEGRATION = s3_source_int
FILE_FORMAT = (FORMAT_NAME = source_format)
PATTERN=’sales.*[.]csv’;
How will the data be loaded?
- A . All files that match the specified format will be appended.
- B . Only new files will be loaded, previously-loaded files will be skipped.
- C . All s3://source/data/files/*.csv files will be loaded from a stage.
- D . The source_table will be truncated and all files from s3://source/data/files will be loaded.