- All Exams Instant Download
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...
Which of the below query will you run to get the approximate number of distinct values in a table?
Which of the below query will you run to get the approximate number of distinct values in a table?A . select approx_count_distinct(column1) from table1; B. select approx_count(column1) from table1; C. select count_distinct(column1 approx) from table1;View AnswerAnswer: A Explanation: APPROX_COUNT_DISTINCT Uses HyperLogLog to return an approximation of the distinct cardinality of...
If your role does not own the share, but owns the objects in the share, how can you block access to the objects
If your role does not own the share, but owns the objects in the share, how can you block access to the objectsA . Revoking the USAGE or SELECT privileges with CASCADE on the objects from the share owner. B. Revoking the USAGE or SELECT privileges on the objects from...
Out of the three query optimization techniques(search optimization, clustering and materialized view) which one does not have storage cost
Out of the three query optimization techniques(search optimization, clustering and materialized view) which one does not have storage costA . Search Optimization Service B. Materialized View C. Clustering the TableView AnswerAnswer: C Explanation: The following table shows which of these three optimizations have storage or compute costs:
{"stuId":2000,"stuCourse":"Snowflake"}
{"stuId":2000,"stuCourse":"Snowflake"} How will you write a query that will check if stuId in JSON in #1 is also there in JSON in#2A . with stu_demography as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000, "stuName":"Amy"}')), B. stu_course as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000,"stuCourse":"Snowflake"}')) select case...
Loading data using snowpipe REST API is supported for external stage only
Loading data using snowpipe REST API is supported for external stage onlyA . TRUE B. FALSEView AnswerAnswer: B Explanation: Snowpipe supports loading from the following stage types:
Which of the below objects cannot be replicated from one region to the other?
Which of the below objects cannot be replicated from one region to the other?A . File Formats B. Sequences C. Pipes D. Views E. Materialized views F. StreamsView AnswerAnswer: C,F Explanation: As of today(27-Nov-2020), below objects cannot be replicated
By default, the maximum file size that can be unloaded to a single file in snowflake is
By default, the maximum file size that can be unloaded to a single file in snowflake isA . 10 MB B. 16 MB C. 5 GB for Azure, AWS and GCPView AnswerAnswer: B Explanation: Unloading to a Single File By default, COPY INTO location statements separate table data into a...
For which use cases, will you use cross-cloud and cross-region replication?
For which use cases, will you use cross-cloud and cross-region replication?A . Business continuity and disaster recovery B. Secure data sharing across regions/cloud C. Data portability and account migrations D. All of theseView AnswerAnswer: D Explanation: All of these are uses cases for cross-cloud/region replication
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...