We're so confident of our products that we provide no hassle product exchange.
Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform Sample Questions:
1. DRAG DROP
You plan to deploy SQL Server 2012.
You must create two tables named Table 1 and Table 2 that will have the following
specifications:
- Table1 will contain a date column named Column1 that will contain a null value approximately 80 percent of the time.
- Table2 will contain a column named Column2 that is the product of two other columns in Table2.
Both Table1 and Table2 will contain more than 1 million rows.
You need to recommend which options must be defined for the columns. The solution must minimize the storage requirements for the tables.
Which options should you recommend?
To answer, drag the appropriate options to the correct column in the answer area.
2. You have a SQL Server 2012 database named database1. Database1 has a data file named databasel_data.mdf and a transaction log file named databaseljog.ldf. Databasel_data.mdf is 1.5 GB. Databaseljog.ldf is 1.5 terabytes.
A full backup of Database1 is performed every day.
You need to reduce the size of the log file. The solution must ensure that you can perform transaction log backups in the future.
Which code segment should you execute?
To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.
A) Option B
B) Option E
C) Option D
D) Option A
E) Option C
F) Option F
3. You need to recommend a solution that meets the data recovery requirement.
What should you include in the recommendation?
A) a transaction log backup
B) a differential backup
C) snapshot isolation
D) a database snapshot
4. You execute usp_TestSpeakers.
You discover that usp_SelectSpeakersByName uses inefficient execution plans.
You need to update usp_SelectSpeakersByName to ensure that the most efficient execution plan is used.
What should you add at line 30 of Procedures.sql?
A) OPTION (OPTIMIZE FOR (@LastName = 'Anderson'))
B) OPTION (FORCESEEK)
C) OPTION (FCRCESCAN)
D) OPTION (OPTIMIZE FOR UNKNOWN)
5. You need to create a function that will use a SELECT statement in ProductsByProductType.sql.
Which code segment should you use to complete the function?
A) Option B
B) Option D
C) Option A
D) Option C
Solutions:
| Question # 1 Answer: Only visible for members | Question # 2 Answer: B,C,D,E | Question # 3 Answer: D | Question # 4 Answer: D | Question # 5 Answer: B |
By Murray
