What should you use?
You need to create a Multi-Dimensional Expression (MDX) query for 3 Key Performance Indicators.
What should you use?
Which code segment should you use?
You are creating an administrative Web Part for a Microsoft Windows SharePoint Services application.
You write the following code segment.
Dim mySPFarm As SPFarm = SPWebService.ContentService.Farm
Dim mySPServerCollection As SPServerCollection = mySPFarm.Servers
Dim contentDatabases As ArrayList = New ArrayList ()
You need to add the names of the content databases for non-administrative sites that are available within the server farm to the ArrayList object.
Which code segment should you use?
What should you do?
You create Microsoft Windows-based applications. You create a Microsoft Windows-based application that stores information in a Microsoft SQL Server 2005 database. Your company requires that all database access is done by using stored procedures.
The stored procedures must meet the following requirements:
The procedures return data that can be used in any data-bound control in the application. The procedures return data in the most compact format available.
No complex logic is needed in the procedures. You need to implement the most appropriate technology to write stored procedures that meet these requirements. You also need to ensure that the stored procedures can be easily updated as application requirements change. What should you do?
What should you do?
You create an Office Visio 2007 stencil named NewShapes.vss. NewShapes.vss contains a master named AutoConfig. You can only add AutoConfig to Visio 2007 diagrams by using Automation. You need to prevent AutoConfig from appearing on the NewShapes.vss stencil. What should you do?
How should you accomplish this goal?
You create Web-based client applications. You are creating a data access component. Several Web user controls will use the component to populate bound controls from a data source. The data source has end-user inputs. You need to ensure that the data source communicates all relevant information to the Web user controls that call your component. How should you accomplish this goal?
What are two possible code segments you can use to achieve this goal?
You need to configure the settings of your Virtual Earth 6.0 map to display apartments at a specified location using the bird’s eye view. What are two possible code segments you can use to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
Which code segment should you add at line 6?
You have a Microsoft Office InfoPath form that is published using InfoPath Services. You plan to publish a new version of the InfoPath form. You need to take the current InfoPath form offline and must ensure that users who currently have the form open have one hour to complete the form.
You write the following code segment:
01: Dim services as SPServiceCollection = SPFarm.Local.Services
02: Create svc as SPService in services
03: Dim fs As FormService = Try Cast(svc, formService)
04: If fs is not Nothing Then
05: Dim ft as FormTemplate = fs.FormTemplates(“myForm”)
06: …
07: End If
08: Next
Which code segment should you add at line 6?
Which code segment should you use?
You are creating a Microsoft Windows SharePoint Services application that uses a tasks list.
The application must notify the project manager each time a new task is inserted into the tasks list. You write an event receiver in the class named TaskEventClass and compile the class in the assembly named TaskEventAssembly.
You need to register the event receiver. You also need to ensure that the event receiver is fired only when an item is added to the tasks list.
Which code segment should you use?
Which code segment should you insert?
You create Microsoft Windows-based applications. You create a banking application that will be used by the account managers of the bank.
You identify a method to simulate the deposit functionality of a savings account. The method will calculate the final balance when monthly deposit, number of months, and quarterly rate are given. The application requirements state that the following criteria must be used to calculate the balance amount:
Apply the quarterly interest rate to the balance amount of the account every three months. Apply the quarterly interest rate before the monthly deposit is calculated for the third month.
You translate the outlined specification into pseudo code. You write the following lines of code. (Line
numbers are included for reference only.)
Method
public static decimal SimulateSavings
Input parameters
int months
decimal monthlyPayment
decimal quarterlyRate
Pseudo code
01 Declare balance variable, initialize it to zero
03 Return balance
You need to insert the appropriate code in line 02. Which code segment should you insert?
What should you do?
You have a stencil named Stencil1 and a stencil named Stencil2. Both stencils contain different master shapes named Master1. From Stencil1, you drag Master1 to your drawing, and then from Stencil2, you drag Master1 to your drawing. You notice that both new shapes are based on Master1 from Stencil1. You need to ensure that when you drag Master1 to the drawing from Stencil2, the shape is based on Master1 from Stencil2. What should you do?