DAA-C01 무료 덤프문제 온라인 액세스

A Data Analyst creates and populates the following table:
create or replace table aggr(v int) as select * from values (1), (2), (3), (4); The Analyst then executes this query:
select percentile_disc(0.60) within group (order by v desc) from aggr;
What will be the result?

• A.2
• B.3
• C.1
• D.4

A Data Analyst needs to add address details based on a customer's latitude and longitude to a customer sales database. The Analyst found a free Worldwide Address Data listing on the Snowflake Marketplace. The ACCOUNTADMIN placed the data set into a new database called ADDRESS_DATA. The Data Analyst needs to join the ADDRESS_DATA.OPENADDRESS table with the ORDERS table which is stored in the GLOBAL_DWH database. The combined data set needs to be created as a view. How can this be achieved?

• A.Ask the ACCOUNTADMIN to grant the Data Analyst the IMPORTED_PRIVILEGES on the ADDRESS_DATA database and then create a view in the ADDRESS_DATA database.
• B.Create a view in the GLOBAL_DWH database.
• C.Create a new schema called ENRICHED in the ADDRESS_DATA database and create this view in the ENRICHED schema.
• D.Create a view in the ADDRESS_DATA database.

What option would allow a Data Analyst to efficiently estimate cardinality on a data set that contains trillions of rows?

• A.HLL(*)
• B.Count(Distinct *)
• C.SYSTEM$ESTIMATE
• D.Count(Distinct *)/Count(*)

A table named STUDENT is created:

What will be the output?

• A.
• B.
• C.
• D.

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;