Superexam

The Microsoft Certified Application Developer (MCAD) certification is the mid level programming certification offered by Microsoft, leading to the MCSD. To fulfill the requirements of the certification, a total of three exams (two core exams, one elective exam) must be passed. Microsoft has declared that this certification will be focused towards the needs of developers using .NET Framework 1.0 and 1.1 versions. Developers using .NET Framework 2.0 and Microsoft Visual Studio 2005 are expected to consider undergoing Microsoft Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified Professional Developer (MCPD) certification.

Free demo download http://pdf.pass4side.com/HP0-M28.pdf

6. Which key benefits does Asset Manager provide customers? (Select three.)
A. It is used as a discovery solution.
B. It aligns IT with business objectives.
C. It optimizes service and asset costs.
D. It highlights software compliance risk.
E. It is used as a stand-alone uCMDB solution.
Answer: BCD
7. If a customer is in the chaos (initial) stage of the evolutionary model, which approach is recommended?
A. Asset tracking
B. Expense control
C. Asset optimization
D. Process automation
Answer: A
8. How can asset optimization help an organization? (Select three.)
A. by improving reporting tools
B. by using business intelligence and advanced analytics
C. by identifying trends and opportunities for improvement
D. by increasing the transparency of IT fiscal performance
E. by increasing maintenance costs involved in infrastructure
Answer: BCD
Testinside
TestInside Help You Pass Any IT Exam http://www.TestInside.com
9. Which modules are integrated within the Software Asset Management module? (Select two.)
A. Portfolio
B. Contracts
C. Reconciliation
D. Cable and Circuit
Answer: AB
10. Which items are part of the purchase request? (Select two.)
A. Models
B. Quotes
C. Invoices
D. Reservations
Answer: AD

HP0-M28 demo http://www.pass4side.com/HP0-M28.htm

1. When does the Automated Process Manager automatically create expense lines? (Select two.)
A. when creating invoice lines
B. when split billing expenses exist
C. when periodic rent calculations exist
D. when receiving a purchase order line
Answer: BC
2. Which table indicates business level units when creating chargeback rules?
A. Cost types
B. Cost centers
C. Expense lines
D. Employees and departments
Answer: B
3. Which contract types are within the Contracts module? (Select two.)
A. License
Testinside
TestInside Help You Pass Any IT Exam http://www.TestInside.com
B. Warranty
C. Lease schedule
D. Business service
Answer: AC
4. Which tool is used to integrate a customization from one Asset Manager database to another?
A. Connect-It
B. Export Utility
C. Application Designer
D. Automated Process Manager
Answer: C
5. Which modules are utilized for the Software asset management module? (Select three.)
A. Portfolio
B. Contract
C. Financials
D. Procurement
E. Reconciliation
F. Cable and Circuit
Answer: ABC

10. Araba is considering using a single licensing agreement for the entire organization. Which single
licensing solution can be used for the entire organization to meet their business goals?
A. Enterprise Agreement
B. Open License
C. Open Value Subscription
D. Open Value Companywide
Answer: A
11. At the end of the current agreement of the company, the company decides to enter into an Enterprise
Agreement. Which price level does the Wikigo company qualifies?
A. Enterprise Agreement Level A
B. Enterprise Agreement Level B
C. Enterprise Agreement Level C
D. Enterprise Agreement Level D
Answer: B
12. On the basis of the business goals of the company, which payment option is suit for the company?
A. Leasing
B. Upfront payment
C. Annual payments
D. Microsoft Financing
Testinside
TestInside Help You Pass Any IT Exam http://www.TestInside.com
Answer: C
13. Currently, which purchasing model is used by the Wikigo company? In the options below, which
statement is true?
A. The Wikigo company uses Decentralized decision-making and centralized purchasing
B. The Wikigo company uses Decentralized decision-making and decentralized purchasing
C. The Wikigo company uses the Centralized decision-making and centralized purchasing
D. The Wikigo company uses Centralized decision-making and decentralized purchasing
Answer: B
14. In the options below, which Volume Licensing program meets their business goals and planned
changes?
A. Enterprise Agreement
B. Open Value Companywide
C. Select Plus
D. Select License
Answer: A
15. Since the company aims to reduce its licensing costs, which of the following Volume Licensing
programs meet this company goal? In the options below, which statement is true?
A. Select Plus can meet this company goal
B. Select License can meet this company goal.
C. Enterprise Agreement can meet this company goal
D. Enterprise Subscription Agreement can meet this company goal.
Answer: C

5. Since the Tipkey has to view and manage its licenses and Software Assurance benefits. Which Web site
is suit for this?
A. explore.ms
B. LicenseWise
C. MS Gear Up
D. Volume Licensing Service Center
Answer: D
6. When desktops are replaced, the company wants to reduce the costs for Office licenses to the least,
which volume license rights can cut down the costs to the least? In the options below, which
statement is true?
A. Downgrade rights can cut down the costs to the least.
B. Re-imaging rights can cut down the costs to the least.
C. New version rights can cut down the costs to the least.
D. Reassignment rights can cut down the costs to the least.
Answer: D
7. In the options below, which Volume Licensing program meets the company's business goals?
A. Select License
B. Enterprise Agreement
C. Select Plus
D. Open License
Answer: B
8. Supposing that now the Tipkey company grows as it expected, which Enterprise Agreement level would
Litware qualify for in three years?
A. Level A
B. Level B
C. Level C
D. Level D
TestInside Help You Pass Any IT Exam http://www.TestInside.com
Answer: C
9. In the options below, which Software Assurance benefit meets the company's business goals?
A. New Version Rights
B. 24x7 Problem Resolution Support
C. eLearning
D. Training Vouchers
Answer: A

http://pdf.pass4side.com/70-672.pdf

http://www.pass4side.com/70-672.htm

1. In the options below, which program excludes Forefront Security Suite?
A. Open Value
B. Open License
C. Select License
D. Enterprise Agreement
Answer: B
2. The company wants to change its existing Web portal. Which licenses should be used?
A. Microsoft Office SharePoint Server for Internet sites and Windows Server External Connector (EC)
B. Microsoft Search Server and Microsoft Office SharePoint Server CAL, Eterprise Edition
C. Microsoft Office SharePoint Server and Microsoft Office SharePoint Server CAL, Standard Edition
D. Microsoft Office SharePoint Server and Windows Server External Connector (EC)
Answer: A
3. Now the company needs to decide the license terms associated with the company’s Office Professional
Plus volume licenses. Which document should be used?
A. Product Use Rights (PUR) should be used
B. Certificated of Authenticity (COA) should be used.
C. End User License Agreement (EULA) should be used.
D. Microsoft volume Licensing Fulfillment User Guide should be used.
Answer: A

6. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
You write the following code segment.
string query = "Select EmpNo, EmpName from dbo.Table_1;
select Name,Age from dbo.Table_2";
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
You need to ensure that the application reads all the rows returned by the code segment.
Which code segment should you use?
A. while (reader.NextResult())
Testinside
TestInside Help You Pass Any IT Exam http://www.TestInside.com
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
reader.Read();
}
B. while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
reader.NextResult();
}
C. while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
reader.NextResult();
while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
D. while (reader.NextResult())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
reader.Read();
while (reader.NextResult())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
Answer: C
7. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
Testinside
TestInside Help You Pass Any IT Exam http://www.TestInside.com
The application has a DataTable object named OrderDetailTable. The object has the following columns:
·ID
·OrderID
·ProductID
·Quantity
·LineTotal
The OrderDetailTable object is populated with data provided by a business partner. Some of the records
contain a null value in the LineTotal field and 0 in the Quantity field.
You write the following code segment. (Line numbers are included for reference only.)
01 DataColumn col = new DataColumn("UnitPrice", typeof(decimal));
02
03 OrderDetailTable.Columns.Add(col);
You need to add a DataColumn named UnitPrice to the OrderDetailTable object.
Which line of code should you insert at line 02?
A. col.Expression = "LineTotal/Quantity";
B. col.Expression = "LineTotal/ISNULL(Quantity, 1)";
C. col.Expression = "LineTotal.Value/ISNULL(Quantity.Value,1)";
D. col.Expression = "iif(Quantity > 0, LineTotal/Quantity, 0)";
Answer: D

3. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
You need to separate the security-related exceptions from the other exceptions for database operations at
run time.
Which code segment should you use?
A. catch (System.Security.SecurityException ex)
{
Testinside
TestInside Help You Pass Any IT Exam http://www.TestInside.com
//Handle all database security related exceptions.
}
B. catch (System.Data.SqlClient.SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++){
if (ex.Errors[i].Class.ToString() == "14") {
//Handle all database security related exceptions.
}
else{
//Handle other exceptions
}
}
}
C. catch (System.Data.SqlClient.SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++){
if (ex.Errors[i].Number == 14){
//Handle all database security related exceptions.
}
else{
//Handle other exceptions
}
}
}
D. catch (System.Data.SqlClient.SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++){
if (ex.Errors[i].Message.Contains("Security")){
//Handle all database security related exceptions.
}
Testinside
TestInside Help You Pass Any IT Exam http://www.TestInside.com
else{
//Handle other exceptions
}
}
}
Answer: B
4. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
You write the following code segment.
string queryString = "Select Name, Age from dbo.Table_1";
SqlCommand command = new SqlCommand(queryString,
(SqlConnection)connection));
You need to get the value that is contained in the first column of the first row of the result set returned by the
query.
Which code segment should you use?
A. var value = command.ExecuteScalar();
string requiredValue = value.ToString();
B. var value = command.ExecuteNonQuery();
string requiredValue = value.ToString();
C. var value = command.ExecuteReader(CommandBehavior.SingleRow);
string requiredValue = value[0].ToString();
D. var value = command.ExecuteReader(CommandBehavior.SingleRow);
string requiredValue = value[1].ToString();
Answer: A
5. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
You write the following code segment. (Line numbers are included for reference only.)
01 using (SqlConnection connection = new
Testinside
TestInside Help You Pass Any IT Exam http://www.TestInside.com
SqlConnection(connectionString)) {
02 SqlCommand cmd = new SqlCommand(queryString, connection);
03 connection.Open();
04
05 while (sdrdr.Read()){
06 // use the data in the reader
07 }
08 }
You need to ensure that the memory is used efficiently when retrieving BLOBs from the database.
Which code segment should you insert at line 04?
A. SqlDataReader sdrdr =
cmd.ExecuteReader();
B. SqlDataReader sdrdr =
cmd.ExecuteReader(CommandBehavior.Default);
C. SqlDataReader sdrdr =
cmd.ExecuteReader(CommandBehavior.SchemaOnly);
D. SqlDataReader sdrdr =
cmd.ExecuteReader(CommandBehavior.SequentialAccess);
Answer: D

1. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
You need to ensure that the application can connect to any type of database.
What should you do?
A. Set the database driver name in the connection string of the application, and then create the connection
object in the following manner.
DbConnection connection = new OdbcConnection(connectionString);
B. Set the database provider name in the connection string of the application, and then create the
connection object in the following manner.
DbConnection connection = new OleDbConnection(connectionString);
C. Create the connection object in the following manner.
DbProviderFactory factory =
DbProviderFactories.GetFactory("System.Data.Odbc");
DbConnection connection = factory.CreateConnection();
D. Create the connection object in the following manner.
DbProviderFactory factory =
DbProviderFactories.GetFactory(databaseProviderName);
DbConnection connection = factory.CreateConnection();
Answer: D
2. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
The application throws an exception when the SQL Connection object is used.
You need to handle the exception.
Which code segment should you use?
A. try
{
if(null!=conn)
conn.Close();
// code for the query
}
Testinside
TestInside Help You Pass Any IT Exam http://www.TestInside.com
catch (Exception ex)
{
// handle exception
}
finally
{
if(null==conn)
conn.Open();
}
B. try
{
conn.Close();
// code for the query
}
catch (Exception ex)
{
// handle exception
}
finally
{
if(null!=conn)
conn.Open();
}
C. try
{
conn.Open();
// code for the query
}
catch (Exception ex)
{
Testinside
TestInside Help You Pass Any IT Exam http://www.TestInside.com
// handle exception
}
finally
{
if(null!=conn)
conn.Close();
}
D. try
{
conn.Open();
// code for the query
}
catch (Exception ex)
{
// handle exception
}
finally
{
if(null==conn)
conn.Close();
}
Answer: C

Exam : IBM COG-122
Title : IBM Certified Cognos 8 BI Administrator exam

6. An administrator wants to show the folder hierarchy of Cognos Connection in a portlet. Which portlet
must the administrator use?
A. Cognos Viewer
B. Cognos Search
C. Cognos Navigator
D. Cognos Extended Applications
Answer: C
7. Why would an administrator want to copy a user profile?
A. The user was deleted using a third-party authentication provider.
B. The administrator wants to copy trusted credentials for multiple users.
C. The user has changed names and the administrator is setting up an account in the new name.
D. The user requires enhanced security permissions before logging on to Cognos 8 for the first time.
Answer: C
8. An administrator creates a shortcut that points to an invoice report. What happens if the invoice report is
renamed?
A. The shortcut contains the original name and can be used to view the latest output before the report was
renamed.
B. The shortcut contains the original name and no longer works because the link to the report is broken.
C. Cognos Connection automatically updates the report name in the shortcut, and the shortcut remains fully
Testinside
TestInside Help You Pass Any IT Exam http://www.TestInside.com
functional.
D. Cognos Connection automatically deletes the shortcut.
Answer: B
9. A user must be able to only view the contents of the Americas Inventory folder. What permissions must
be granted to the user for the folder?
A. Write
B. Execute
C. Traverse
D. Set policy
Answer: C
10. Before sending a report by email, where must the administrator specify the mail server account?
A. Cognos Connection
B. Cognos Administration
C. Framework Manager
D. Cognos Configuration
Answer: D