Online Access Free DAA-C01 Exam Questions

Which query will provide this data without incurring additional storage costs?

• A.CREATE TABLE DEV.PUBLIC.TRANS_HIST LIKE PROD.PUBLIC.TRANS_HIST;
• B.CREATE TABLE DEV.PUBLIC.TRANS_HIST CLONE PROD.PUBLIC.TRANS_HIST;
• C.CREATE TABLE DEV.PUBLIC.TRANS_HIST AS (SELECT * FROM PROD.PUBLIC.TRANS_HIST WHERE extract(year from (TRANS_DATE)) = 2019);
• D.CREATE TABLE DEV.PUBLIC.TRANS_HIST AS (SELECT * FROM PROD.PUBLIC.
  TRANS_HIST);

A Data Analyst needs to create a custom filter called state in a Snowflake dashboard using a SQL query.
Which query will include this custom filter?

• A.select avg(total_income), state from taxpayer_wages group by state having state = 'state';
• B.select avg(total_income), state from taxpayer_wages group by state having state = :state;
• C.select avg(total_income), state from taxpayer_wages group by state having state = state;
• D.select avg(total_income), state from taxpayer_wages group by state having state = @state;

While loading data into Snowflake using named file formats, a file format defined in which location has precedence?

• A.The schema definition
• B.The COPY INTO statement
• C.The stage definition
• D.The table definition

Consider the following chart.

What can be said about the correlation for sales over time between the two categories?

• A.There is a non-linear correlation.
• B.There is a positive correlation.
• C.There is a negative correlation.
• D.There is no correlation. (Selected)

A Data Analyst needs to rotate a table by transforming a wide table's columns into rows.

Which operator will be MOST beneficial for producing this output?

• A.INTERSECT
• B.EXCEPT
• C.UNPIVOT
• D.PIVOT