Name:
Email:

Monthly Archives: January 2012

MCITP Certification, MCITP: Server Administrator

QUESTION NO: 1

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to a Microsoft SQL Server database. You use the ADO.NET Entity Framework to model entities.

You need to add a new type to your model that organizes scalar values within an entity. You also need to map stored procedures for managing instances of the type.

What should you do?

A. Add the stored procedures in the SSDL file along with a Function attribute. Define a complex type in the CSDL file. Map the stored procedure in the MSL file with a
ModificationFunctionElement.

B. Add the stored procedures in the SSDL file along with a Function attribute. Define a complex type in the CSDL file. Map the stored procedure in the MSL file with an AssociationEnd element.

C. Use the edmx designer to import the stored procedures. Derive an entity class from the existing entity as a complex type. Map the stored procedure in the MSL file with an AssociationEnd element.

D. Add the stored procedures in the SSDL file along with a Function attribute. Derive an entity class from the existing entity as a complex type. Map the stored procedure in the MSL file with a ModificationFunctionElement.

Answer: A
Explanation:

QUESTION NO: 2

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application that uses the Entity Framework.

You need to execute custom logic when an entity is attached to the ObjectContext. What should you do?

A. Create a partial method named OnStateChanged in the partial class for the entity.

B. Create a partial method named OnAttached in the partial class for the entity.

C. Create an event handler to handle the ObjectStateManagerChanged event.

D. Create an event handler to handle the ObjectMaterialized event.

Answer: C
Explanation:

QUESTION NO: 3

You use Microsoft Visual Studio 2010 and Microsoft ADO.NET Framework 4 to create an application. The application connects to a Microsoft SQL Server 2008 database. You use the ADO.NET LINQ to SQL model to retrieve data from the database. You use stored procedures to return multiple result sets.

You need to ensure that the result sets are returned as strongly typed values.

What should you do?

A. Apply the FunctionAttribute and ResultTypeAttribute to the stored procedure function. Use the GetResult method to obtain an enumerator of the correct type.

B. Apply the FunctionAttribute and ParameterAttribute to the stored procedure function and directly access the strongly typed object from the results collection.

C. Apply the ResultTypeAttribute to the stored procedure function and directly access the strongly typed object from the results collection.

D. Apply the ParameterAttribute to the stored procedure function. Use the GetResult method to obtain an enumerator of the correct type. MCITP Certification

Answer: A
Explanation:

MCITP Administrator, Configuring Incoming Email Settings

Configuring Incoming Email Settings

Before you enable incoming email, you must have preinstalled the Internet Informa- tion Services (IIS6 or newer is required for WSS 3.0) and Simple Mail Transfer Protocol (SMTP) server. This can be done from the Add/Remove programs option in Control Panel on your server.

Why do you need to bother with using the incoming email settings section? Say your users have started to use your new SharePoint site only to to store email from other teams, they have to open the SharePoint site and upload the con- tent. This would not only decrease productivity, it would also discourage users from using the information management features. Constore their email-based information in lists and libraries and allows the site to receive email directly. The lists and libraries can be assigned an email address that will make the team sites more efsupport in your organization? Perhaps you could create a form for IT support. Conincoming email would allow your users to create an email message that can be sent to your staff. With some custom coding, you could use this feature to trace the progress of requests and have WSS alert them anytime a change is made to a request. And there are other ben-
e
Archiving email
Creating a place to share information
Adding content via email
To conincoming email. This page is found by following these steps:
1. On the navigation bar on the Central Administration site, click Operations.
2. Locate the Topology and Services section and select Incoming E-Mail settings, which will take you to the Configure Incoming E-mail Settings page (Figure 7.2).

Configuring Windows SharePoint Services

FIGURE 7.2 Configuring email settings
image001

There are four different sections that you should understand how to con
Enable Incoming E-Mail When incoming email is enabled, sites can accept email and
store incoming messages in list and libraries.
Directory Management Service This is how SharePoint connects your SharePoint site to
your userscreation and management of email distribution groups, creation of contacts in users tories, and allowing users to MCITP Administrator
Incoming E-Mail Server Display Address This is usually something like @yourcompany.com .
Safe E-Mail Servers This is where you specify if you want to lock down your SharePoint
environment to just certain email servers or if you want to allow any email server to be able to route email to your site. Now that you have a basic overview of the options, youexample scenario. In Exercise 7.1, you

MCITP Certification, MCITP Enterprise Administrator

QUESTION NO: 1

You are developing a Silverlight 4 application. You have a resource dictionary contained in a file named myDictionary.XAML that is embedded in a separate assembly named myResources.dll. The App.XAML file contains the following XAML fragment. (Line numbers are included for reference only.)

01

02

03

You need to add the myDictionary.XAML file to the resource dictionaries in the application. Which XAML fragment should you use to replace line 02?

A.

B.

A.

D.

Answer: A
Explanation:

QUESTION NO: 2

You are developing a Silverlight 4 application. The application contains a Person class that has a public nullable DateTime property named Birthday. You display a list of Person objects in a DataGrid control. One of the columns in the DataGrid control is bound to Birthday. You need to ensure that the data-bound column displays Birthday by using the long date format. Which binding expression should you use?

A. Binding Path=Birthday, FallbackValue='D'

B. 0:D\

C. 0:D\

D. Binding Path=Birthday, TargetNullValue='LongDatePattern'

Answer: B
Explanation:

QUESTION NO: 3

You are creating a Silverlight 4 application. The application contains a Person class that has a public property named Address. The application contains a TextBox control that is data bound to the Address property. You need to ensure that the following requirements are met: When the Address property changes, the TextBox control is automatically updated.When the TextBox control changes, the Addressproperty is not automatically updated. Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two.) MCITP Certification

A. Use TwoWay data binding.

B. Use OneWay data binding.

C. Use OneTime data binding.

D. Create a PropertyChanged event handler in the Person object.

E. Implement the INotifyPropertyChanged interface in the Person object.

Answer: B,E
Explanation:

MCITP Certification, Configuring Policy Template

Configuring Policy Template

To confi gure a Policy Template, do the following:

1. Expand the local server.
2. Click on Rights Policy Templates.
3. In the Actions pane, click Create Distributed Right Policy Template.

image001

4. In the Template Identifi cation page, click Add.
5. In the Name box, enter the name for this policy.
6. In the Description box, enter a description for this policy.
7. Click Add.
8. Back at the Template Identifi cation page, click Next.
9. On the Add User Rights page, add the users and permissions required.
image003

Configuring Digital Rights Management (DRM)

10. When fi nished, click Next.
11. Next, you are able to specify an expiration policy. Enter the dates, if any, on which you want the content being protected by this policy to expire.
12. Click Next.
13 On the Specify Extended Policy page, choose any additional conditions that you
require for this template.
14. Click Next.
15. In the Specify Revocation Policy page, check the box next to Require Revocation if you need to deny permission based on other factors. Those factors can include users, application, content ID, or operating systems. MCITP Certification

16. Click Finish to create the template.

MCTS Exam, MCTS Windows 7

QUESTION NO: 1

You develop a SQL Server 2008 Integration Services (SSIS) package. The package downloads several files from a remote FTP server by using multiple FTP tasks, and then processes data by using multiple Execute SQL tasks. You need to configure the package to restart at the point of failure after the package downloads the files. What should you do?

A. Configure the FTP tasks to support transactions.

B. Configure the Execute SQL tasks to support transactions.

C. Move all the FTP tasks to a sequence container.

D. Configure the package to use a checkpoint.

Answer: D

QUESTION NO: 2

You develop a SQL Server 2008 Reporting Services (SSRS) report. The report uses the "User!UserID" expression in a text box within the report header. You need to ensure that data- driven subscriptions successfully execute for this report. What should you do?

A. Remove the expression from the report header.

B. Configure the report to use no credentials.

C. Configure the report to use stored credentials.

D. Modify the expression in the report header as "User!UserName."

Answer: C
Explanation:

QUESTION NO: 3

You are managing the security in SQL Server 2008 Reporting Services (SSRS). You assign a new user to a role. You need to grant the permissions to the user to publish reports and manage content only in a private folder. What should you do?

A. Assign the user to the Publisher role.

B. Assign the user to the My Reports role.

C. Assign the user to the Content Manager and the Browser roles.

D. Assign the user to the Content Manager and the Report Builder roles.

Answer: B

QUESTION NO: 4

You install and configure SQL Server 2008 Reporting Services (SSRS) instance. The users of the report server plan to deliver reports through e-mail messages. You need to configure the report server for e-mail message delivery by using a remote SMTP server. What should you do? MCITP Certification

A. Modify the rssrvpolicy.config file.

B. Modify the RSReportServer.config file.

C. Modify the Web.config file.

D. Modify the Global.asax file.

Answer: B

MCITP Certification, Creating an ACL List

Creating an ACL List
ACL list can be confi gured by following these steps:

1. In Server Manager expand Roles\Streaming Media Services\\ Publishing Points.
2. Click on your broadcast and click the Properties tab.
3. In the Category section, click Authorization.
4. Right-click on WMS Publishing Points ACL Authorization and click properties.
5. On the Properties dialog box, you can do the following:
image001

Add or remove a user or group

Set permissions for a new user or group

Change the permissions for a group

Configuring Digital Rights Management (DRM)

6. Click OK.

Configuring Digital Rights
Management (DRM)

Digital Rights Management, or DRM, is a technology that allows the owner of some forms of media to enforce the terms to the people who have access to use it. Those who own the copyright to music, You or your company may own media that you deliver on your media server or provide
in email or SharePoint sites. Itcritical information to be sent from one company to a competing company or media outlet. This can cause public relations, legal, or competition problems for an organization. For example, a company may create a widget that is far superior to the competitorThe company has spent thousands of man hours and millions of dollars to create and docu- ment this new widget. A disgruntled employee could easily send these documents to the competitor or post them to a weblog for the world to see. If the company protected these documents using a DRM solution, it would be able to avoid theft.

250 Chapter 6

DRM Controversy

Much debate has sprung from companies using DRM to protect the media they own. This is especially true of the entertainment industry. Over the past fi ve years, controversy over audio fi les such as MP3s try to adopt DRM protection.

Those in favor of DRM state that it is necessary for the copyright holders to be able to prevent others from duplicating and sharing their work illegally. Those opposed take the stand that as long as they are not using the media in a way that would violate commercial use, they should not have restrictions on content that they have purchased.
Despite the controversy around DRM, companies like Apple and Microsoft continue to use this form of protection. It allows the companies to provide content, such as music, on a subscription basis. Some companies are listening to the cries of the users and are now are providing content that is DRM free.

As bandwidth speeds increase to consumersappear to be heading to a similar pay-per-view model. Will DRM continue to be a method to protect the rights of those who create or publish the content? Time will tell.
Although music and videos are often in the middle of this controversy, many companies are adopting DRM to protect internal documentation from prying eyes.

How Does DRM work?
When media is created, it is encrypted in order to protect it. For a user to access this encrypted media, they have to have a license. This license contains information such as the following:
How long the content can be used
What actions can be done on the media
Simply put, the license or key unlocks the content and allows it to be played. The nice thing about DRM is that you get to control how long it will be unlocked. For example, say you want to provide content as a promotion that lasts only tion, you can set the key to expire in users copying material and giving it to others because no matter who plays the content, they still need to acquire a key or license.
DRM rights are stored in the key and not the content. This means that you can create different keys for the same tent with DRM protection. Then it would be posted so that users could download it. After the content is downloaded, the userlicense provider site to get the needed key. After the user pays for the key, they are able to play the content.

Configuring Digital Rights Management (DRM)

251

DRM also can be used to protect other types of
Office documents
Email
Word, Excel, PowerPoint, and other important company Active Directory Rights Management Service (AD RMS). A typical example would be using a SharePoint intranet that has or allows external users to view content.
The following sections, it is assumes that you have installed the AD RMS role and have reviewed the event log for any errors.

MCITP Certification, MCITP Course

QUESTION NO: 1

You develop a SQL Server 2008 Integration Services (SSIS) package. The package downloads several files from a remote FTP server by using multiple FTP tasks, and then processes data by using multiple Execute SQL tasks. You need to configure the package to restart at the point of failure after the package downloads the files. What should you do? MCITP Course

A. Configure the FTP tasks to support transactions.

B. Configure the Execute SQL tasks to support transactions.

C. Move all the FTP tasks to a sequence container.

D. Configure the package to use a checkpoint.

Answer: D

QUESTION NO: 2

You develop a SQL Server 2008 Reporting Services (SSRS) report. The report uses the "User!UserID" expression in a text box within the report header. You need to ensure that data- driven subscriptions successfully execute for this report. What should you do?

A. Remove the expression from the report header.

B. Configure the report to use no credentials.

C. Configure the report to use stored credentials.

D. Modify the expression in the report header as "User!UserName."

Answer: C
Explanation:

QUESTION NO: 3

You are managing the security in SQL Server 2008 Reporting Services (SSRS). You assign a new user to a role. You need to grant the permissions to the user to publish reports and manage content only in a private folder. What should you do?

A. Assign the user to the Publisher role.

B. Assign the user to the My Reports role.

C. Assign the user to the Content Manager and the Browser roles.

D. Assign the user to the Content Manager and the Report Builder roles.

Answer: B

QUESTION NO: 4

You install and configure SQL Server 2008 Reporting Services (SSRS) instance. The users of the report server plan to deliver reports through e-mail messages. You need to configure the report server for e-mail message delivery by using a remote SMTP server. What should you do? MCITP Certification

A. Modify the rssrvpolicy.config file.

B. Modify the RSReportServer.config file.

C. Modify the Web.config file.

D. Modify the Global.asax file.

Answer: B

MCITP Certification, Configuring Advanced Streaming Solutions

Configuring Advanced Streaming Solutions

Windows Media Services allow you to control most aspects of how you stream content to your users. If you just need to get a small video out to a limited number of users, the default settings will most likely accomplish the task. However, if you have a media server that gets a lot of traf
In this section, we will review two areas:
Intelligent streaming
Fast streaming
The method that your server uses with Windows Media Player to detect and adjust the
properties of a stream automatically is called intelligent streaming . This type of streaming
allows for a continuous A userreduce the bit rate. For the most part, intelligent streaming is completely automatic and requires no additional con
Fast streaming refers to a group of features that Windows Media Services includes to
improve the quality of the user
Fast Cache
Fast Start
Advanced Fast Start
Fast Recovery
Fast Reconnect

Fast Cache
Fast caching is a way for the Windows Media Services and Windows media players to stream the content to the clients faster than the speciper second (Kbps) stream, using Fast Cache you can stream it at 700Kbps. This is accom- plished by streaming the content to the client machine and then the Windows Media Player is able to buffer it before playing at the speci
This is extremely useful when streaming over wireless networks that have high latency or when the quality of the content received is of top priority.

When Fast Cache is enabled, intelligent streaming cannot be used. In addi- tion, Fast Cache is used only by clients that connect to a unicast stream.

Exercise 6.8 shows you how to enable Fast Cache.

Configuring Media Server

EXERCISE 6.8

Enabling Fast Cache
Do the following to enable Fast Cache:

1. In Server Manager expand Roles\Streaming Media Services\Windows Media Services\\Publishing Points.
2. Click on your broadcast and click the Properties tab in the Content pane.
3. Now click on General in the Category section.
4. In the Property section, right-click Enable Fast Cache and choose Enable. (In the fol- lowing screen shot, the Enable option is grayed out because Fast Cache is already enabled.)
MCITP Certification

Fast Start
Fast Start allows users to start to receive content more quickly. It does this by allowing the player to provide data directly to the buffer at higher speeds than the request bit rate. This option is available to users with Windows Media Player for Windows XP or later. It helps reduce the delays and re-buffering that occur when a user fast-forwards and rewinds con- tent. It also aids in a smoother transition between content items. Fast Start also reduces the amount of playback errors due to packet loss as it pre-buffers data.

Advanced Fast Start
Advanced Fast Start is used for reducing startup times in Windows Media Player 10 and higher. It has all the same features and benebefore its buffer is full, unlike the Fast Start option, which makes the user must wait until the buffer is full. With Advanced Fast Start, as soon as the player receives the minimum amount of data, playback will begin. While the content is being played, the buffer will continue to and the stream continues to be received and played at its specimust be enabled because it is disabled by default (see Exercise 6.9).

MCITP Certification, MCITP Enterprise Administrator

QUESTION NO: 1

You are developing a SQL Server 2008 Integration Services (SSIS) data flow that extracts data from two sources. Each source database is located on a different server. Each source is based on a SELECT statement that uses an ORDER BY clause. The data flow is as shown in the following diagram.

When the paths from the two sources are connected to a Merge Join component, the following error message is displayed: "Data Flow Task: The input is not sorted. The 'input "Merge Join Left Input" (80)' must be sorted." You need to ensure that data from each query is included in each row in the data flow. You want to achieve this goal by using minimum amount of execution time. What should you do?

A. Add a Sort transformation for each data flow.

B. Add an OLE DB Command transformation for each data flow.

C. Update the sorting properties in each source component.

D. Replace the Merge Join transformation with a Union All transformation.

Answer: C

QUESTION NO: 2

You are developing a SQL Server 2008 Integration Services (SSIS) package. The package uses an OLE DB connection manager to connect to a third-party database server. The database does not support Integrated Windows authentication. You create an XML configuration file that provides configuration for the connection manager. You add the configuration file to the package. When the package executes, you receive an error message which indicates that login failure occurred. You need to execute the package successfully. What should you do? MCITP Certification

A. Edit the XML configuration file.

B. Use an indirect XML configuration.

C. Run the package on the same server as the third-party database server.

D. Use a Microsoft ADO.NET connection manager instead of an OLE DB connection manager.

Answer: A
Explanation:

QUESTION NO: 3

You create a SQL Server 2008 Reporting Services (SSRS) report. You plan to create a list of customers by using a List control. For each customer in the List control, you plan to include a table that contains the orders for that customer. The customer data is stored in the Customers table in the data source, and the order data is stored in the Orders table. You need to define the required dataset or datasets for this report. What should you do?

A. Create a query that joins the two tables in the data source by using the JOIN clause. Add the query as a single data set to the report. MCITP Enterprise Administrator

B. Create a query that combines the two tables in the data source by using the UNION operator. Add the query as a single data set to the report.

C. Create a query for each table. Group both tables on the column that is used to join the tables. Add both queries as separate data sets to the report.

D. Create a query for each table. Sort both tables on the column that is used to join the tables. Add both queries as separate data sets to the report.

Answer: A

MCITP Certification, Setting Client Connect Attempts

EXERCISE 6.11
Setting Client Connect Attempts
Confi gure client connect attempt with the following steps:

1. In Server Manager, expand Roles\Streaming Media Services\\ Publishing Points.
2. Click on your broadcast and click the Source tab.

3. In the Content Source section, click Change.
4. In the location box, add ?WMReconnect=3 to the end of your location. This will allow the clients to attempt a reconnect three times.
5. Click OK.

Options for Configuring Security in
a Windows Media Server
The content you provide to your users can be very valuable to your organization. Much time and money has been spent to create this content, and one of the more important tasks that you can do is control access to it. It is therefore important that you conoptions of your media server. This will ensure that your company tected from unauthorized access.
The following sections will cover these topics:MCITP Certification
Authentication
Authorization

Authentication
Authentication cona user is authenticated, authorization occurs so that the user gains proper access to the con- tent. When the user attempts to gain access, the server attempts to authenticate through the anonymous authentication plug-in. You would use this type of anonymous authentication if you do not want the users to have to enter a username and password. This is condefault, but if you want to change the Anonymous account, you must make sure the account you use has read permissions for any
In Exercise 6.12, you