BIS 345 MENTOR Keep Learning /bis345mentor.com BIS 345 MENTOR Keep Learning /bis345mentor.com | Page 8

31. (TCO 6) Which of the data source credential options is the
least recommended because of security risks. (Points : 5)
Hard-code
Prompt
Windows Authentication
No Credentials
32. (TCO 6) Which of the following is not a type of data source
in SSRS. (Points : 5)
embedded
shared
calculated
expression
33. (TCO 3) Which of the following functions would you use in
an SQL statement to tally the number of values. (Points : 5)
Max()
Avg()
Sum()
Count()
34. (TCO 3)________functions are SQL mathematical
summaries. (Points : 5)
Summation
Summary
Aggregate
Cummalative
35. (TCO 5) When using the report server project wizard the
most crucial step is _______. (Points : 5)
selecting your data source
naming your project
selecting the location to save your project
selecting the correct template
36. (TCO 2) Refer to the tblCustomer table below. As a data
analyst, you have been requested to select rows that meet the
following requirements: For each city, list the city name in all