Snowflake SnowPro Advanced: Data Analyst Certification Sample Questions:
1. When sharing views across accounts, which function should be used on the row access policy for the secure views to give users access to rows in a base table?
A) CURRENT_ROLE
B) CURRENT_USER
C) CURRENT_AVAILABLE_ROLES
D) CURRENT_ACCOUNT
2. 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;
3. A Data Analyst for a ride-sharing company needs to assess the relationship between the number of active drivers in a city, and the average waiting time for passengers. Which query will determine if an increase in the number of active drivers is associated with a decrease in the average waiting time?
A) SELECT CITY, VARIANCE(ACTIVE_DRIVERS, AVERAGE_WAITING_TIME) FROM
RIDE_DATA GROUP BY CITY;
B) SELECT CITY, SUM(ACTIVE_DRIVERS), AVG(AVERAGE_WAITING_TIME) FROM
RIDE_DATA GROUP BY CITY;
C) SELECT CITY, CORR(ACTIVE_DRIVERS, AVERAGE_WAITING_TIME) FROM RIDE_DATA GROUP BY CITY;
D) SELECT CITY, SUM(ACTIVE_DRIVERS), VARIANCE(AVERAGE_WAITING_TIME) FROM RIDE_DATA GROUP BY CITY;
4. This command was executed:
SQL
SELECT seq4(), uniform(1, 10, RANDOM(12))
FROM TABLE(GENERATOR(TIMELIMIT => NULL))
ORDER BY 1;
How many rows will be generated?
A) 12
B) 0
C) An infinite number
D) 10
5. A Data Analyst wants to transform query results. Which transformation option will incur compute costs?
A) Increasing or decreasing decimal precision.
B) Formatting date and timestamp columns.
C) Sorting a column by using the column options.
D) Showing a thousand separator for numeric columns.
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: B | Question # 3 Answer: C | Question # 4 Answer: B | Question # 5 Answer: C |
896 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
