IT认证 MCITP 70-454认证认证全真题库.pdfVIP

The safer , easier way to help you pass any IT exams. Exam : 70-454 Title : UPG: Transiton MCITP SQL Serv 2005 to SQL Serv 2008 DBD Version : DEMO 1 / 4 The safer , easier way to help you pass any IT exams. 1. Youareadatabasesolutions architect.Yourcompanyplans todevelopasolutionbyusingaSQLServer 2008 instance. Thesolutionhas the following business requirements: Import datafromvarious datasources suchas MicrosoftOffice Excel, MicrosoftSQLServer2000, Microsoft SQL Server 2005, and CSV files. Profile the source data before it is imported. Provide collabor ation andoffline capabilities to mobile users. Allowmobile users to use heterogeneous data stores. You need to configure the appropriate SQL Server components to accomplish the business requirement s. You want to achieve this goal by using the minimumamount of administrative effort.Which twoSQLSer vercomponents shouldyouuse?(Eachcorrect Answerpresents part ofthesolution. Choose two.) A. Analysis Services B. Reporting Services C. Integration Services D. Notification Services E. Microsoft Sync Framework Answer:CE 2. You need to create a column that allows you to createa unique constraint. Which twocolumndefinitions should youchoose?(Eachcorrect Answerpresents acompletesolution. Choose two.) A. nvarchar(100) NULL B. nvarchar(max) NOT NULL C. nvarchar(100) NOT NULL D. nvarchar(100) SPARSE NULL Answer:AC 3. You area databasedeveloper. You plan to design a database solution byusing SQL Server 2008. Youa recreatingadatabasetosupport theofficemanager. Yourdatabasemodel has thefollowingstructure. 2 / 4 The safer , easier way to help you pass