70-445 TS Braindump
ExamSoon 70-445 Exams
Microsoft TS:MS SQL Server 2005 Business Intelligence-Implem & Mainte
O rder : 70-445 Exam
Practice Exam: 70-445
Exam Number/Code: 70-445
Exam Name: TS:MS SQL Server 2005 Business Intelligence-Implem & Mainte
Questions and Answers: 105 Q&As
Free 70-445 Braindumps
Exam : Microsoft 70-445
Title : TS:MS SQL Server 2005 Business Intelligence-Implem & Mainte
1. You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report uses a dataset that
is constructed from an SQL table named Employees. The table has an employeeID field and a managerID field. The
managerID field in each row represents the employeeID field.
You execute the following Transact-SQL query to get the dataset from the report:
SELECT CONVERT(varchar(255), c.FirstName + ' ' + c.LastName)
as Name,
e.EmployeeID,
e.ManagerID
FROM HumanResources.Employee AS e
JOIN Person.Contact AS c
ON e.ContactID = c.ContactID
You need to display the dataset as a hierarchical, organizational chart, as shown in the Exhibit. (Click the Exhibit
button.)
What should you do?
A. Use the Level function in the Left property of the Padding property of the cell.
B. Group the report by the employeeID field and set the managerID field as the group parent.
C. Group the report by the managerID field and set the employeeID field as the group parent. Use the Level function in
the Left property of the Padding property of the cell.
D. Group the report by the employeeID field and set the managerID field as the group parent. Use the Level function in
the Left property of the Padding property of the cell.
Answer: D
2. Microsoft SQL Server Management Studio (SSMS) is installed on your workstation. Microsoft Business Intelligence
Development Studio (BIDS) is not installed on your workstation.
You need to create a package that must meet the following requirements:
It must be transactional.
It must be optimized for 20 tables.
It must be stored securely in the msdb database of a remote server.
What should you do?
A