Trouble Spots
As with any exam, it will vary from person to person as to what is deemed to be difficult. Be sure you are familiar with each of the topics in the exam objectives listed below.
- SQL Server Reporting Services[md]Reporting Services was initially released in 2004 as an add-on to SQL Server 2000. SQL Server Reporting Services (SSRS) is a simply a report generation software system. SSRS is used to prepare and deliver a many different interactive and printed reports and is administered using a web interface. SSRS is included in Developer, Standard, and Enterprise editions of Microsoft SQL Server as an install option.
- SQL Server Integration Services[md]SQL Server Integration Services (SSIS) is used to perform migration tasks. It can perform fast and flexible data extractions in a data warehousing environment. This is a tool that can be used to automate tasks such as maintenance of SQL Server databases.
- SQL Server Analysis Services[md]Microsoft SQL Server Analysis Services is part of Microsoft SQL Server. It allows data mining functionality for business intelligence applications. Analysis Services supports online analytical processing (OLAP) by allowing the user the ability to design, create, and manage multidimensional structures that contain data obtained from data sources such as relational databases.