- All Exams Instant Download
Which of the below select query will fail for this table?
You have created a table as below CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR); Which of the below select query will fail for this table?A . SELECT * from snowflake; B. SELECT * from Snowflake; C. SELECT * from "snowflake"; D. SELECT * FROM "SNOWFLAKE";View AnswerAnswer: C Explanation: Try it...
Secure views cannot take advantage of the internal optimizations which require access to the underlying data in the base tables for the view.
Secure views cannot take advantage of the internal optimizations which require access to the underlying data in the base tables for the view.A . TRUE B. FALSEView AnswerAnswer: A Explanation: Some of the internal optimizations for views require access to the underlying data in the base tables for the view....
When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME() or CURRENT_TIMESTAMP() what will occur?
When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME() or CURRENT_TIMESTAMP() what will occur?A . All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted. B. Any rows loaded...
What is the most optimal solution that you will suggest to the business team?
You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the...
How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)
How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)A . Shared databases are read-only. B. Shared databases must be refreshed in order for new data to be visible. C. Shared databases cannot be cloned. D. Shared databases are...
What are the MINIMUM object privileges required for the Snowpipe user to execute Snowpipe?
A Data Engineer is designing a near real-time ingestion pipeline for a retail company to ingest event logs into Snowflake to derive insights. A Snowflake Architect is asked to define security best practices to configure access control privileges for the data load for auto-ingest to Snowpipe. What are the MINIMUM...
Which command below will only copy the table structure from the existing table to the new table?
Which command below will only copy the table structure from the existing table to the new table?A . CREATE TABLE … AS SELECT B. CREATE TABLE … LIKE C. CREATE TABLE … CLONEView AnswerAnswer: B Explanation: CREATE TABLE … LIKE Creates a new table with the same column definitions as...
How can this data be shared?
A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition. How can this data be shared?A . The healthcare company will need to change the institute’s Snowflake edition in the accounts...
Which permission sets must be granted to this role?
There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db...
How can a Snowflake Architect meet this requirement with the LEAST amount of coding?
Files arrive in an external stage every 10 seconds from a proprietary system. The files range in size from 500 K to 3 MB. The data must be accessible by dashboards as soon as it arrives. How can a Snowflake Architect meet this requirement with the LEAST amount of coding?...
