Free IT Certification Braindumps

VUE/Prometric Code: 70-448
Exam name:  TS: MS SQL Server 2008, Business Intelligence Dev & Maintenance

1.You are developing a SQL Server 2008 Integration Services (SSIS) data flow that loads data to a SQLServer 2008 database. You needto ensure that the data flow updates theexisting records in the SQL Server database by using data from the rows in your data flow. Which data flow component should you use?
A. SQLServer Destination
B. OLE DB Destination
C. OLE DB Command Transformation
D. Data ConversionTransformation
Answer: C

2.Youdesign a SQL Server 2008 IntegrationServices (SSIS) data flow that inserts data from a source query to a destinationtable.You need to insert only those rows that do not already exist in the destination table. What are two possible
ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
A. Use the Merge transformation.
B. Use theLookup transformation.
C. Use the UnionAll transformation.
D. Use the Merge Join transformation.
E. Use the Fuzzy Lookup transformation.
F. Use the Fuzzy Grouping transformation.

Answer: B,D

3.You implement a SQL Server 2008Integration Services (SSIS) package. The package contains the following com ponents: Adata flow task contained in a For Loop containerA Flat File destination component that uses a Flat File connection manager An OnError event handler When an error occurs in the package, you plan to write diagnostic information from an expression that includes the version of the package to atext file. You needto ensure that the required information is written to the text file. What should you do?
A. Use the VersionGUID variable.
B. Use the ExecutionGUID variable.
C. Use the SourceID variable.
D. Use the TaskID variable.
Answer: A

Related Certifications: Microsoft Certified Technology Specialist (MCTS)

VUE/Prometric Code: 70-620
Exam name:  TS: Microsoft Windows Vista, Configuring

1. You have a computer that runs Microsoft Windows XP. Your computer has the following hardware installed:
·CD-ROM drive
·1024 megabytes (MB) of RAM
·120 gigabytes (GB) hard disk drive that has 30 GB of free space
·DirectX 9–class graphics adapter that supports Windows Display Driver Model (WDDM) and Pixel Shader 2.0
·128 megabytes (MB) of dedicated video memory
You want to install Windows Vista on your computer by using the retail installation media. You also want to enable
Windows Aero.
You need to ensure that your computer hardware supports the planned installation.
What should you do?
A. Install a network card.
B. Install a DVD-ROM drive.
C. Replace the hard disk drive.
D. Replace the graphics adapter.
Answer: B

2. You need to configure a new computer to dual-boot to the following operating systems:
·Microsoft Windows XP Professional
·Microsoft Windows Vista
Which two procedures should you perform? (Each correct answer presents a complete solution. Choose two.)
A. Create two partitions. Install Windows XP Professional on the first partition. Boot the computer from the Windows
Vista DVD-ROM. Install Windows Vista on the second partition.
B. Create two partitions. Install Windows Vista on the first partition. Boot from the Windows XP Professional
installation CD-ROM. Install Windows XP Professional on the second partition.
C. Create one partition. Install Windows XP Professional on the partition. From Windows XP Professional launch the
Windows Vista setup utility. Install Windows Vista in the same partition.
D. Create two partitions. Install Windows XP Professional on the first partition. From Windows XP Professional
launch the Windows Vista setup utility. Install Windows Vista on the second partition.
Answer: A, D

3. You perform a clean installation of Microsoft Windows Vista on the first partition. Then, you install Microsoft
Windows XP Professional on the second partition of the same machine. You are able to log on to Windows XP Professional but

do not have the option to boot to Windows Vista. You need to be able to dual boot the computer. What should you do?
A. Run the bootcfg.exe application with the /fastdetect option.
B. Perform a clean installation of Windows Vista on the first partition.
C. Run the msconfig.exe application and change the order of the operating systems in the boot.ini file.
D. Edit the boot.ini file. Add the following line: Multi(0)Disk(0)Rdisk(0)Partition(1)\Microsoft Windows
Answer: B

Related Exams :

Microsoft 70-270 – Installing, Configuring, and Administering Microsoft Windows XP Professional
Microsoft 70-290 – Managing and Maintaining a Microsoft Windows Server 2003 Environment
Microsoft 70-291 – Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
Microsoft 70-293 – Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
Microsoft 70-294 – Planning, Implementing, and Maintaining a Microsoft Windows Server 2003 AD Infrastructure

Related Certifications: MCSE 2003, MCTS, MCSA 2008, MCSE 2008, MCSA 2003

Vendor: Microsoft
Exam Code: 70-432
Exam Name: TS: Microsoft SQL Server 2008, Implementation and Maintenance

1. You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use?
A. You should use local Service account
B. You should use network Service account
C. You should use domain account
D. You should use local System account
Answer:C

2. You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. On DB1, quite few logged operations are performed. Now according to the requirement of the company CIO, you must validate that the database can be restored to a specific point in time. So what action should you perform to achieve this goal?
A. You should verify that the simple recovery model is used by the database
B. You should verify that the full recovery model is used by the database.
C. You should verify that the checksum page verify option is used by the database
D. You should verify that the bulk-logged recovery model is used by the database
Answer:B

3. You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the
administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a SQL
Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement,
you must make sure that suspect pages can be detected in the database. So what action should you perform to
achieve this goal?
A. For the database, you should turn on the TRUSTWORTHY database option
B. For the database, the PAGE_VERIFY database option should be set to CHECKSUM
C. For the database, the database compatibility level option should be set to 10.
D. For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.
Answer:B

4. You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the
administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You configure the
SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure
recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal?
A. You should backup the master database
B. You should backup the default.trc file
C. You should backup the SQL Server registry hive.
D. You should backup the resource database
Answer:C

Related Certifications:  MCTS