Microsoft 70-454 Q & A / Study Guide

Best Microsoft MCTS Certification, Microsoft MCITP Training at certkingdom.com

---

QUESTION 1
You are employed as a database developer at Certkingdom.com. You make use of SQL Server 2008 to develop database strategies.
You are in the process of developing a strategy that has three tables named Certkingdom1, Certkingdom2, and
Certkingdom3. The Certkingdom1 and Certkingdom2 have the integer and varchar data type column types configured
respectively. Certkingdom3 has both the integer and varchar data types configured as column types.
You have configured rowlevel compression on Certkingdom1, and page-level compression on Certkingdom2 and Certkingdom3.
Which of the following describes the reason for this configuration?

A. It allows for the reduction of disk space usage, while modifying the data types in the tables of the database
B. It allows for the reduction of disk space usage without modifying the data types in the tables of the database
C. It allows for the increase of disk space usage, while modifying the data types in the tables of the database
D. It allows for the increase of disk space usage, while modifying the data types in the tables of the database

Answer: B

Explanation:

---

QUESTION 2
You are employed as a database developer at Certkingdom.com. You make use of SQL Server 2008 to
develop database strategies.
You have received instructions to design a database strategy that includes a table which hosts
data imported from an outside source. This data includes a field named TransactionTime that
should be configured to make use of hh:mm:ss[.n] format.
You have been informed that the data type selected for the TransactionTime field must allow for
storage to be kept to a minimum.
You, therefore, make use of the time(1) data type.
Which of the following is TRUE with regards to the time data type?

A. The default fractional precision is 7 (100ns).
B. The default fractional precision is 3 (100ns).
C. The time produced by the time data type is not time zone aware and is based on a 24-hour clock.
D. The time produced by the time data type is time zone aware and is based on a 12-hour clock.

Answer: A,D

Explanation:

---

QUESTION 3
You are employed as a database developer at Certkingdom.com. You make use of SQL Server 2008 to
develop database strategies.
You have received instructions to design a strategy that has two tables named CertkingdomVendor and
CertkingdomItem. You have configured a foreign key constraint between the CertkingdomVendor and CertkingdomItem
tables on the CertkingdomVendorID column.
You have configured the CertkingdomVendor table to display a 0 value for the CertkingdomVendorID when a
vendor is removed. You also want make sure that the CertkingdomVendorID value in the CertkingdomItem table is
set to 0 when a vendor is removed.
You then create a default constraint on the CertkingdomVendorID column in the CertkingdomItem table, which is
used to set the value to 0.
Which of the following actions should you take NEXT?

A. You should consider setting the ON DELETE property of the foreign key constraint to Null.
B. You should consider setting the ON DELETE property of the foreign key constraint to Default.
C. You should consider setting the ON DELETE property of the foreign key constraint to Cascade.
D. You should consider setting the ON DELETE property of the foreign key constraint to No Action.

Answer: B

Explanation:

---

QUESTION 4
You are employed as a database developer at Certkingdom.com. You make use of a SQL Server 2008
instance to develop database strategies.
You are in the process of designing a database strategy that makes use of the Integration
Services and Microsoft Sync Framework SQL Server components.
Which of the following is TRUE with regards to the use of these components?

A. Microsoft Sync Framework allows for collaboration and offline access for applications, services, and devices.
B. Microsoft Sync Framework prevents collaboration and offline access for applications, services, and devices.
C. Integration Services allows for the merging of data from Heterogeneous Data Stores.
D. Integration Services prevents the merging of data from Heterogeneous Data Stores.

Answer: A,C

Explanation:

---

QUESTION 5
You are employed as a database developer at Certkingdom.com. You make use of SQL Server 2008 to
develop database strategies.
You have received instructions to design a strategy that helps Certkingdom.com’s administration manager.
You have created three entities named User, UserTask, and UserAssignment. You have
configured the User entity to make use of the UserID attribute, the UserTask entity to make use of
the UserTaskID attribute, and the UserAssignment entity to make use of the UserAssignmentID attribute.
You have been informed that the strategy must allow for users to be assigned multiple tasks. You
also need to ensure that a task is deleted when it has been completed, and that the assignment
linked to that task is also deleted. Furthermore, a NULL value has to replace the user reference to
the user assignment as soon as a user becomes unavailable to finish a task.
Which combination of the following actions should you take? (Choose all that apply.)

A. You should consider configuring Foreign Key constraints on the UserTaskID and UserID
attributes in the UserAssignment entity.
B. You should consider configuring Foreign Key constraints on the UserTaskID and UserID
attributes in the UserTask and User entities respectively.
C. You should consider referencing the UserTask and User entities respectively.
D. You should consider referencing the UserAssignment and User entities respectively.
E. You should consider specifying the On Delete property as NULL.
F. You should consider specifying the On Delete property as Default.

Answer: A,C,E

Explanation:

Best Microsoft MCTS Certification, Microsoft MCITP Training at certkingdom.com