Page: 1
/ 13
Total 65 questions
A Data Engineer is investigating a query that is taking a long time to return. The Query Profile shows the following:
What step should the Engineer take to increase the query performance?
- A. Add additional virtual warehouses.
- B. Increase the size of the virtual warehouse.
- C. Rewrite the query using Common Table Expressions (CTEs).
- D. Change the order of the joins and start with smaller tables first.
Answer : B
How can the following relational data be transformed into semi-structured data using the LEAST amount of operational overhead?
- A. Use the TO_JSON function.
- B. Use the PARSE_JSON function to produce a VARIANT value.
- C. Use the OBJECT_CONSTRUCT function to return a Snowflake object.
- D. Use the TO_VARIANT function to convert each of the relational columns to VARIANT.
Answer : C
A Data Engineer executes a complex query and wants to make use of Snowflake’s query results caching capabilities to reuse the results.
Which conditions must be met? (Choose three.)
- A. The results must be reused within 72 hours.
- B. The query must be executed using the same virtual warehouse.
- C. The USED_CACHED_RESULT parameter must be included in the query.
- D. The table structure contributing to the query result cannot have changed.
- E. The new query must have the same syntax as the previously executed query.
- F. The micro-partitions cannot have changed due to changes to other data in the table.
Answer : EDF
A Data Engineer needs to load JSON output from some software into Snowflake using Snowpipe.
Which recommendations apply to this scenario? (Choose three.)
- A. Load large files (1 GB or larger).
- B. Ensure that data files are 100-250 MB (or larger) in size, compressed.
- C. Load a single huge array containing multiple records into a single table row.
- D. Verify each value of each unique element stores a single native data type (string or number).
- E. Extract semi-structured data elements containing null values into relational columns before loading.
- F. Create data files that are less than 100 MB and stage them in cloud storage at a sequence greater than once each minute.
Answer : BDE
Given the table SALES which has a clustering key of column CLOSED_DATE, which table function will return the average clustering depth for the SALES_REPRESENTATIVE column for the North American region?
- A. select system$clustering_information('Sales', 'sales_representative', 'region = ''North America''');
- B. select system$clustering_depth('Sales', 'sales_representative', 'region = ''North America''');
- C. select system$clustering_depth('Sales', 'sales_representative') where region = 'North America';
- D. select system$clustering_information('Sales', 'sales_representative') where region = 'North America’;
Answer : B
31 days access 