BIS 345 MENTOR Extraordinary Success /bis345mentor.com BIS 345 MENTOR Extraordinary Success /bis345mentor | Page 21

1. (TCO 6) Which of the following is not a type of data source in SSRS
2. (TCO 6) Which of the data source credential options is the least
recommended because of security risks
3. (TCO 5) All of the following are types of query for a data set except
________.
4. (TCO 6) _____ regions are items that must be associated with a data
set.
5. (TCO 6) Data regions support grouping and ______.
6. (TCO 6) _____ is the simplest report item and contains no data values
7. (TCO 7) ______ presents group data in a grid layout that's capable of
expanding both rows and columns
8. (TCO 5) Of the following four Tablix internal areas, which is a required
area?
9. (TCO 7) The chart _____ contains the plotting area of a chart
10. (TCO 7) A ________ report item is a great tool to graphically display
key performance indicators
=====================================================
BIS 345 Week 1 iLab
FOR MORE CLASSES VISIT
www.bis345mentor.com
Student Name: Name
Using Lab 1, answer the questions and provide copies of your SQL
Statements and/or results for each Section listed below
Part A: Customer List (4 points)
a.What does the ORDER BY clause do?
b.Screen print your results and paste here:
Part B: Customer List with only customers In France or Germany (4
points)
Part C: Using a Calculation in a Query (5 points)
Part D: Products that are discontinued (5 points)
Part E: Practice using the BETWEEN operator (5 points)
Part F: Practice using the “IN” operator (5 points)
Part G: Understanding “NULL” (5 points)