無料にMicrosoftのMB7-841 70-685 70-658 70-686 MB7-840 70-565 70-561の試験問題集をダウンロード する

君が後悔しないようにもっと少ないお金を使って大きな良い成果を取得するためにIT-Passports.comを選択してください。IT-Passports.comはまた一年間に無料なサービスを更新いたします。

Microsoft MB7-841 70-685 70-658 70-686 MB7-840 70-565 70-561認証はIT業界にとても重要な地位があることがみんなが、たやすくその証本をとることはではありません。いまの市場にとてもよい問題集が探すことは難しいです。でも、IT-Passports.comにいつでも最新な問題を探すことができ、完璧な解説を楽に勉強することができます。

IT-Passports.comが提供したMicrosoftのMB7-841 70-685 70-658 70-686 MB7-840 70-565 70-561トレーニング資料はもうあなたの目の前に来ましたから、選択すべき時間になりました。もちろんあなたも他の製品を選べますが、IT-Passports.comがあなたに無限大な恩恵をもたらせることを知るべきです。１００パーセントの成功率を保証できるのはIT-Passports.comしかないです。IT-Passports.comがあなたに美しい未来を差し上げ、将来あなたはIT-Passports.com領域でより広い道が行くことができ、情報技術の領域で効率的に仕事することもできます。

MicrosoftのMB7-841 70-685 70-658 70-686 MB7-840 70-565 70-561の認定試験は当面いろいろな認証試験で最も価値がある試験の一つです。最近の数十年間で、コンピュータ科学の教育は世界各地の数多くの注目を得られています。MicrosoftのMB7-841 70-685 70-658 70-686 MB7-840 70-565 70-561の認定試験はIT情報技術領域の欠くことができない一部ですから、IT領域の人々はこの試験認証に合格することを通じて自分自身の知識を増加して、他の分野で突破します。IT-Passports.comのMicrosoftのMB7-841 70-685 70-658 70-686 MB7-840 70-565 70-561認定試験の問題と解答はそういう人たちのニーズを答えるために研究した成果です。この試験に合格することがたやすいことではないですから、適切なショートカットを選択するのは成功することの必要です。IT-Passports.comはあなたの成功を助けるために存在しているのですから、IT-Passports.comを選ぶということは成功を選ぶのことと等しいです。IT-Passports.comが提供した問題と解答はIT領域のエリートたちが研究と実践を通じて開発されて、十年間過ぎのIT認証経験を持っています。

試験番号：MB7-841問題集
試験科目：Microsoft 「NAV 2009 C/SIDE Solution Development」
問題と解答：全95問

試験番号：70-685問題集
試験科目：Microsoft 「Pro: Windows 7, Enterprise Desktop Support Technician」
問題と解答：全191問

試験番号：70-658問題集
試験科目：Microsoft 「TS: System Center Data Protection Manager 2007, Configuring (English)」
問題と解答：全73問

試験番号：70-686問題集
試験科目：Microsoft 「Pro: Windows 7, Enterprise Desktop Administrator」
問題と解答：全185問

試験番号：MB7-840問題集
試験科目：Microsoft 「NAV 2009 C/SIDE Introduction」
問題と解答：全109問

試験番号：70-565問題集
試験科目：Microsoft 「Pro: Designing and Developing Enterprise Applications Using the Microsoft .NET Framework 3.5」
問題と解答：全138問

試験番号：70-561問題集
試験科目：Microsoft 「TS: MS .NET Framework 3.5, ADO.NET Application Development」
問題と解答：全170問

購入前にお試し,私たちの試験の質問と回答のいずれかの無料サンプルをダウンロード：http://www.it-passports.com/70-561.html

NO.1 myConnection.Close();

NO.2 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
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 Dim col As New DataColumn("UnitPrice", GetType(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

Microsoft問題集   70-561認定資格   70-561練習問題   70-561

NO.3 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a TextBox control named txtProductID. The application will return a list of active
products that have the ProductID field equal to the txtProductID.Text property.
You write the following code segment. (Line numbers are included for reference only.)
01 private DataSet GetProducts(SqlConnection cn) {
02 SqlCommand cmd = new SqlCommand();
03 cmd.Connection = cn;
04 SqlDataAdapter da = new SqlDataAdapter(cmd);
05 DataSet ds = new DataSet();
06
07 da.Fill(ds);
08 return ds;
09 }
You need to populate the DataSet object with product records while avoiding possible SQL injection
attacks.
Which code segment should you insert at line 06?
A. cmd.CommandText = string.Format("sp_sqlexec 'SELECT ProductID,
Name FROM Product WHERE ProductID={0} AND IsActive=1'", txtProductID.Text);
B. cmd.CommandText = string.Format("SELECT ProductID, Name FROM
Product WHERE ProductID={0} AND IsActive=1", txtProductID.Text);
cmd.Prepare();
C. cmd.CommandText = string.Format("SELECT ProductID, Name FROM
Product WHERE ProductID={0} AND IsActive=1", txtProductID.Text);
cmd.CommandType = CommandType.TableDirect;
D. cmd.CommandText = "SELECT ProductID, Name FROM Product WHERE
ProductID=@productID AND IsActive=1";
cmd.Parameters.AddWithValue("@productID", txtProductID.Text);
Answer: D

Microsoft参考書   70-561   70-561   70-561   70-561

NO.4 {

NO.5 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a DataSet object named OrderDS that has the Order and OrderDetail tables as
shown in the following exhibit.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Sub GetOrders(ByVal cn As SqlConnection)
02 Dim cmd As SqlCommand = cn.CreateCommand()
03 cmd.CommandText = "Select * from [Order]; " + _
"Select * from [OrderDetail];"
04 Dim da As New SqlDataAdapter(cmd)
05
06 End Sub
You need to ensure that the Order and the OrderDetail tables are populated.
Which code segment should you insert at line 05?
A. da.Fill(OrderDS)
B. da.Fill(OrderDS.Order)
da.Fill(OrderDS.OrderDetail)
C. da.TableMappings.AddRange(New DataTableMapping() _
{New DataTableMapping("Table", "Order"), _
New DataTableMapping("Table1", "OrderDetail")})
da.Fill(OrderDS)
D. Dim mapOrder As New DataTableMapping()
mapOrder.DataSetTable = "Order"
Dim mapOrderDetail As New DataTableMapping()
mapOrder.DataSetTable = "OrderDetail"
da.TableMappings.AddRange(New DataTableMapping() _
{mapOrder, mapOrderDetail})
da.Fill(OrderDS)
Answer: C

Microsoft認定資格   70-561認定資格   70-561   70-561

NO.6 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a SqlDataAdapter object named daOrder. The SelectCommand property of the
daOrder object is set.
You write the following code segment. (Line numbers are included for reference only.)
01 private void ModifyDataAdapter() {
02
03 }
You need to ensure that the daOrder object can also handle updates.
Which code segment should you insert at line 02?
A. SqlCommandBuilder cb = new SqlCommandBuilder(daOrder);
cb.RefreshSchema();
B. SqlCommandBuilder cb = new SqlCommandBuilder(daOrder);
cb.SetAllValues = true;
C. SqlCommandBuilder cb = new SqlCommandBuilder(daOrder);
daOrder.DeleteCommand = cb.GetDeleteCommand();
daOrder.InsertCommand = cb.GetInsertCommand();
daOrder.UpdateCommand = cb.GetUpdateCommand();
D. SqlCommandBuilder cb = new SqlCommandBuilder(daOrder);
cb.RefreshSchema();
cb.GetDeleteCommand();
cb.GetInsertCommand();
cb.GetUpdateCommand();
Answer: C

Microsoft過去問   70-561   70-561認定証   70-561認証試験   70-561

NO.7 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 conn IsNot Nothing Then
conn.Close()
' code for the query
End If
Catch ex As Exception
' handle exception
Finally
If conn Is Nothing Then
conn.Open()
End If
End Try
B. Try
' code for the query
conn.Close()
Catch ex As Exception
' handle exception
Finally
If conn IsNot Nothing Then
conn.Open()
End If
End Try
C. Try
' code for the query
conn.Open()
Catch ex As Exception
' handle exception
Finally
If conn IsNot Nothing Then
conn.Close()
End If
End Try
D. Try
' code for the query
conn.Open()
Catch ex As Exception
' handle exception
Finally
If conn Is Nothing Then
conn.Close()
End If
End Try
Answer: C

Microsoft   70-561   70-561

NO.8 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a TextBox control named txtProductID. The application will return a list of active
products that have the ProductID field equal to the txtProductID.Text property.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Function GetProducts(ByVal cn _
As SqlConnection) As DataSet
02 Dim cmd As New SqlCommand()
03 cmd.Connection = cn
04 Dim da As New SqlDataAdapter(cmd)
05 Dim ds As New DataSet()
06
07 da.Fill(ds)
08 Return ds
09 End Function
You need to populate the DataSet object with product records while avoiding possible SQL injection
attacks.
Which code segment should you insert at line 06?
A. cmd.CommandText = _
String.Format("sp_sqlexec 'SELECT ProductID, " + _
"Name FROM Product WHERE ProductID={0} AND IsActive=1'", _
txtProductID.Text)
B. cmd.CommandText = _
String.Format("SELECT ProductID, " + _
"Name FROM Product WHERE ProductID={0} AND IsActive=1", _
txtProductID.Text)
cmd.Prepare()
C. cmd.CommandText = _
String.Format("SELECT ProductID, " + _
"Name FROM Product WHERE ProductID={0} AND IsActive=1", _
txtProductID.Text)
cmd.CommandType = CommandType.TableDirect
D. cmd.CommandText = "SELECT ProductID, " + _
"Name FROM Product WHERE ProductID=@productID AND IsActive=1"
cmd.Parameters.AddWithValue("@productID", txtProductID.Text)
Answer: D

Microsoft認定資格   70-561   70-561認定証   70-561認定証

NO.9 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.
Dim connection As DbConnection = _ 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.
Dim connection As DbConnection = _ New OleDbConnection(connectionString)
C. Create the connection object in the following manner.
Dim factory As DbProviderFactory = _ DbProviderFactories.GetFactory("System.Data.Odbc")
Dim connection As DbConnection = _ factory.CreateConnection()
D. Create the connection object in the following manner.
Dim factory As DbProviderFactory = _ DbProviderFactories.GetFactory(databaseProviderName)
Dim connection As DbConnection = factory.CreateConnection()
Answer: D

Microsoft練習問題   70-561認定資格   70-561過去問

NO.10 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
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

Microsoft問題集   70-561   70-561   70-561認定資格   70-561認定試験

NO.11 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
}
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)
{
// 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

Microsoft問題集   70-561問題集   70-561   70-561練習問題   70-561認定証

NO.12 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())
{
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

Microsoft   70-561   70-561参考書   70-561参考書

NO.13 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a DataSet object named orderDS. The object contains a table named Order as
shown in the following exhibit.
The application uses a SqlDataAdapter object named daOrder to populate the Order table.
You write the following code segment. (Line numbers are included for reference only.)
01 private void FillOrderTable(int pageIndex) {
02 int pageSize = 5;
03
04 }
You need to fill the Order table with the next set of 5 records for each increase in the pageIndex value.
Which code segment should you insert at line 03?
A. string sql = "SELECT SalesOrderID, CustomerID, OrderDate FROM Sales.SalesOrderHeader";
daOrder.SelectCommand.CommandText = sql;
daOrder.Fill(orderDS, pageIndex, pageSize, "Order");
B. int startRecord = (pageIndex - 1) * pageSize;
string sql = "SELECT SalesOrderID, CustomerID, OrderDate FROM Sales.SalesOrderHeader";
daOrder.SelectCommand.CommandText = sql;
daOrder.Fill(orderDS, startRecord, pageSize, "Order");
C. string sql = string.Format("SELECT TOP {0} SalesOrderID, CustomerID,
OrderDate FROM Sales.SalesOrderHeader WHERE SalesOrderID > {1}", pageSize, pageIndex);
daOrder.SelectCommand.CommandText = sql;
daOrder.Fill(orderDS, "Order");
D. int startRecord = (pageIndex - 1) * pageSize;
string sql = string.Format("SELECT TOP {0} SalesOrderID, CustomerID,
OrderDate FROM Sales.SalesOrderHeader WHERE SalesOrderID > {1}",
pageSize, startRecord);
daOrder.SelectCommand.CommandText = sql;
daOrder.Fill(orderDS, "Order");
Answer: B

Microsoft   70-561   70-561参考書   70-561認定資格   70-561

NO.14 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 ex As System.Security.SecurityException
'Handle all database security related exceptions.
End Try
B. Catch ex As System.Data.SqlClient.SqlException
For i As Integer = 0 To ex.Errors.Count - 1
If ex.Errors(i).[Class].ToString() = "14" Then
'Handle all database security related exceptions.
Else
'Handle other exceptions
End If
Next
End Try
C. Catch ex As System.Data.SqlClient.SqlException
For i As Integer = 0 To ex.Errors.Count - 1
If ex.Errors(i).Number = 14 Then
'Handle all database security related exceptions.
Else
'Handle other exceptions
End If
Next
End Try
D. Catch ex As System.Data.SqlClient.SqlException
For i As Integer = 0 To ex.Errors.Count - 1
If ex.Errors(i).Message.Contains("Security") Then
'Handle all database security related exceptions.
Else
'Handle other exceptions
End If
Next
End Try
Answer: B

Microsoft認定資格   70-561認定資格   70-561問題集   70-561認証試験

NO.15 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.
Dim queryString As String = "Select Name, Age from dbo.Table_1"
Dim command As New _SqlCommand(queryString, DirectCast(connection, SqlConnection))
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. Dim value As Object = command.ExecuteScalar()
Dim requiredValue As String = value.ToString()
B. Dim value As Integer = command.ExecuteNonQuery()
Dim requiredValue As String = value.ToString()
C. Dim value As SqlDataReader = _command.ExecuteReader(CommandBehavior.SingleRow)
Dim requiredValue As String = value(0).ToString()
D. Dim value As SqlDataReader = _command.ExecuteReader(CommandBehavior.SingleRow)
Dim requiredValue As String = value(1).ToString()
Answer: A

Microsoft   70-561練習問題   70-561

NO.16 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a SqlDataAdapter object named daOrder. The SelectCommand property of the
daOrder object is set.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Sub ModifyDataAdapter()
02
03 End Sub
You need to ensure that the daOrder object can also handle updates.
Which code segment should you insert at line 02?
A. Dim cb As New SqlCommandBuilder(daOrder)
cb.RefreshSchema()
B. Dim cb As New SqlCommandBuilder(daOrder)
cb.SetAllValues = True
C. Dim cb As New SqlCommandBuilder(daOrder)
daOrder.DeleteCommand = cb.GetDeleteCommand()
daOrder.InsertCommand = cb.GetInsertCommand()
daOrder.UpdateCommand = cb.GetUpdateCommand()
D. Dim cb As New SqlCommandBuilder(daOrder)
cb.RefreshSchema()
cb.GetDeleteCommand()
cb.GetInsertCommand()
cb.GetUpdateCommand()
Answer: C

Microsoft   70-561問題集   70-561過去問   70-561

NO.17 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

Microsoft   70-561練習問題   70-561認定証

NO.18 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a DataSet object named OrderDS that has the Order and OrderDetail tables as
shown in the following exhibit.
You write the following code segment. (Line numbers are included for reference only.)
01 private void GetOrders(SqlDataConnection cn) {
02 SqlCommand cmd = cn.CreateCommand();
03 cmd.CommandText = "Select * from [Order];
Select * from [OrderDetail];";
04 SqlDataAdapter da = new SqlDataAdapter(cmd);
05
06 }
You need to ensure that the Order and the OrderDetail tables are populated.
Which code segment should you insert at line 05?
A. da.Fill(OrderDS);
B. da.Fill(OrderDS.Order);
da.Fill(OrderDS.OrderDetail);
C. da.TableMappings.AddRange(new DataTableMapping[] {
new DataTableMapping("Table", "Order"),
new DataTableMapping("Table1", "OrderDetail")});
da.Fill(OrderDS);
D. DataTableMapping mapOrder = new DataTableMapping();
mapOrder.DataSetTable = "Order";
DataTableMapping mapOrderDetail = new DataTableMapping();
mapOrder.DataSetTable = "OrderDetail";
da.TableMappings.AddRange(new DataTableMapping[]
{ mapOrder, mapOrderDetail });
Da.Fill(OrderDS);
Answer: C

Microsoft   70-561   70-561認証試験

NO.19 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application uses Microsoft SQL Server 2005.
You write the following code segment. (Line numbers are included for reference only.)
01 String myConnString = "User
02 ID=<username>;password=<strong password>;Initial
03 Catalog=pubs;Data Source=myServer";
04 SqlConnection myConnection = new
05 SqlConnection(myConnString);
06 SqlCommand myCommand = new SqlCommand();
07 DbDataReader myReader;
08 myCommand.CommandType =
09 CommandType.Text;
10 myCommand.Connection = myConnection;
11 myCommand.CommandText = "Select * from Table1;
Select * from Table2;";
12 int RecordCount = 0;
13 try
14 {
15 myConnection.Open();
16
17 }
18 catch (Exception ex)
19 {
20 }
21 finally

NO.20 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 analyzes large amounts of transaction data that are stored in a different database.
You write the following code segment. (Line numbers are included for reference only.)
01 using (SqlConnection connection = new
SqlConnection(sourceConnectionString))
02 using (SqlConnection connection2 = new
SqlConnection(destinationConnectionString))
03 using (SqlCommand command = new SqlCommand())
04 {
05 connection.Open();
06 connection2.Open();
07 using (SqlDataReader reader = command.ExecuteReader())
08 {
09 using (SqlBulkCopy bulkCopy = new
SqlBulkCopy(connection2))
10 {
11
12 }
13 }
14 }
You need to copy the transaction data to the database of the application.
Which code segment should you insert at line 11?
A. reader.Read()
bulkCopy.WriteToServer(reader);
B. bulkCopy.DestinationTableName = "Transactions";
bulkCopy.WriteToServer(reader);
C. bulkCopy.DestinationTableName = "Transactions";
bulkCopy.SqlRowsCopied += new
SqlRowsCopiedEventHandler(bulkCopy_SqlRowsCopied);
D. while (reader.Read())
{
bulkCopy.WriteToServer(reader);
}
Answer: B

Microsoft   70-561   70-561問題集

NO.21 }
You need to compute the total number of records processed by the Select queries in the RecordCount
variable.
Which code segment should you insert at line 16?
A. myReader = myCommand.ExecuteReader();
RecordCount = myReader.RecordsAffected;
B. while (myReader.Read())
{
//Write logic to process data for the first result.
}
RecordCount = myReader.RecordsAffected;
C. while (myReader.HasRows)
{
while (myReader.Read())
{
//Write logic to process data for the second result.
RecordCount = RecordCount + 1;
myReader.NextResult();
}
}
D. while (myReader.HasRows)
{
while (myReader.Read())
{
//Write logic to process data for the second result.
RecordCount = RecordCount + 1;
}
myReader.NextResult();
}
Answer: D

Microsoft   70-561認定試験   70-561認定資格   70-561問題集
22. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application uses Microsoft SQL Server 2005.
You write the following code segment. (Line numbers are included for reference only.)
01 Dim myConnString As String = _
02 "User ID=<username>;password=<strong password>;" + _
03 "Initial Catalog=pubs;Data Source=myServer"
04 Dim myConnection As New SqlConnection(myConnString)
05 Dim myCommand As New SqlCommand()
06 Dim myReader As DbDataReader
07 myCommand.CommandType = CommandType.Text
08 myCommand.Connection = myConnection
09 myCommand.CommandText = _
10 "Select * from Table1;Select * from Table2;"
11 Dim RecordCount As Integer = 0
12 Try
13 myConnection.Open()
14
15 Catch ex As Exception
16 Finally
17 myConnection.Close()
18 End Try
You need to compute the total number of records processed by the Select queries in the RecordCount
variable.
Which code segment should you insert at line 14?
A. myReader = myCommand.ExecuteReader()
RecordCount = myReader.RecordsAffected
B. While myReader.Read()
'Write logic to process data for the first result.
End While
RecordCount = myReader.RecordsAffected
C. While myReader.HasRows
While myReader.Read()
'Write logic to process data for the second result.
RecordCount = RecordCount + 1
myReader.NextResult()
End While
End While
D. While myReader.HasRows
While myReader.Read()
'Write logic to process data for the second result.
RecordCount = RecordCount + 1
End While
myReader.NextResult()
End While
Answer: D

Microsoft問題集   70-561練習問題   70-561認定試験   70-561   70-561参考書
23. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application uses data from a Microsoft SQL Server 2005 database table. A Web page of the
application contains a GridView server control.
You write the following code segment. (Line numbers are included for reference only.)
01 private void LoadGrid()
02 {
03 using (SqlCommand command = new SqlCommand())
04 {
05 command.Connection = connection;
06 command.CommandText = "SELECT * FROM Customers";
07 connection.Open();
08
09 }
10 }
You need to retrieve the data from the database table and bind the data to the DataSource property of the
GridView server control.
Which code segment should you insert at line 08?
A. SqlDataReader rdr = command.ExecuteReader();
connection.Close();
GridView1.DataSource = rdr;
GridView1.DataBind();
B. SqlDataReader rdr = command.ExecuteReader();
GridView1.DataSource = rdr.Read();
GridView1.DataBind();
connection.Close();
C. SqlDataReader rdr = command.ExecuteReader();
Object[] values = new Object[rdr.FieldCount];
GridView1.DataSource = rdr.GetValues(values);
GridView1.DataBind();
connection.Close();
D. DataTable dt = new DataTable();
using (SqlDataReader reader = command.ExecuteReader())
{
dt.Load(reader);
}
connection.Close();
GridView1.DataSource = dt;
GridView1.DataBind();
Answer: D

Microsoft   70-561   70-561認定試験   70-561認定試験
24. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application uses data from a Microsoft SQL Server 2005 database table. A Web page of the
application contains a GridView server control.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Sub LoadGrid()
02 Using command As New SqlCommand()
03 command.Connection = connection
04 command.CommandText = "SELECT * FROM Customers"
05 connection.Open()
06
07 End Using
08 End Sub
You need to retrieve the data from the database table and bind the data to the DataSource property of the
GridView server control.
Which code segment should you insert at line 06?
A. Dim rdr As SqlDataReader = command.ExecuteReader()
connection.Close()
GridView1.DataSource = rdr
GridView1.DataBind()
B. Dim rdr As SqlDataReader = command.ExecuteReader()
GridView1.DataSource = rdr.Read()
GridView1.DataBind()
connection.Close()
C. Dim rdr As SqlDataReader = command.ExecuteReader()
Dim values As Object() = New Object(rdr.FieldCount - 1) {}
GridView1.DataSource = rdr.GetValues(values)
GridView1.DataBind()
D. Dim dt As New DataTable()
Using reader As SqlDataReader = command.ExecuteReader()
dt.Load(reader)
End Using
connection.Close()
GridView1.DataSource = dt
GridView1.DataBind()
Answer: D

Microsoft   70-561   70-561認定資格   70-561   70-561練習問題

NO.22 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 connection string of the application is defined in the following manner.
"Server=Prod;Database=WingtipToys;Integrated
Security=SSPI;Asynchronous Processing=true"
The application contains the following code segment. (Line numbers are included for reference only.)
01 protected void UpdateData(SqlCommand cmd) {
02 cmd.Connection.Open();
03
04 lblResult.Text = "Updating ...";
05 }
The cmd object takes a long time to execute.
You need to ensure that the application continues to execute while cmd is executing.
What should you do?
A. Insert the following code segment at line 03.
cmd.BeginExecuteNonQuery(new AsyncCallback(UpdateComplete), cmd);
Add the following code segment.
private void UpdateComplete (IAsyncResult ar) {
int count = (int)ar.AsyncState;
LogResults(count);
}
B. Insert the following code segment at line 03.
cmd.BeginExecuteNonQuery(new AsyncCallback(UpdateComplete), cmd);
Add the following code segment.
private void UpdateComplete (IAsyncResult ar) {
SqlCommand cmd = (SqlCommand)ar.AsyncState;
int count = cmd.EndExecuteNonQuery(ar);
LogResults(count);
}
C. Insert the following code segment at line 03.
cmd.StatementCompleted += new
StatementCompletedEventHandler(UpdateComplete);
cmd.ExecuteNonQuery();
Add the following code segment.
private void UpdateComplete (object sender, StatementCompletedEventArgs e) {
int count = e.RecordCount;
LogResults(count);
}
D. Insert the following code segment at line 03.
SqlNotificationRequest notification = new
SqlNotificationRequest("UpdateComplete", "", 10000);
cmd.Notification = notification;
cmd.ExecuteNonQuery();
Add the following code segment.
private void UpdateComplete(SqlNotificationRequest notice) {
int count = int.Parse(notice.UserData);
LogResults(count);
}
Answer: B

Microsoft参考書   70-561参考書   70-561   70-561

NO.23 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)
{
//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.
}
else{
//Handle other exceptions
}
}
}
Answer: B

Microsoft認定資格   70-561   70-561認定証

NO.24 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 connection As New SqlConnection(connectionString)
02 Dim cmd As New SqlCommand(queryString, connection)
03 connection.Open()
04
05 While sdrdr.Read()
06 ' use the data in the reader
07 End While
08 End Using
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. Dim sdrdr As SqlDataReader = _ cmd.ExecuteReader()
B. Dim sdrdr As SqlDataReader = _ cmd.ExecuteReader(CommandBehavior.[Default])
C. Dim sdrdr As SqlDataReader = _ cmd.ExecuteReader(CommandBehavior.SchemaOnly)
D. Dim sdrdr As SqlDataReader = _ cmd.ExecuteReader(CommandBehavior.SequentialAccess)
Answer: D

Microsoft   70-561認証試験   70-561   70-561   70-561

NO.25 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.
Dim query As String = _ "Select EmpNo, EmpName from dbo.Table_1; " + _ "select Name,Age from
dbo.Table_2"
Dim command As New SqlCommand(query, connection)
Dim reader As SqlDataReader = 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()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
reader.Read()
End While
B. While reader.Read()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
reader.NextResult()
End While
C. While reader.Read()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
End While
reader.NextResult()
while reader.Read()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
End While
D. While reader.NextResult()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
End While
reader.Read()
while reader.NextResult()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
End While
Answer: C

Microsoft   70-561認定証   70-561参考書

NO.26 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 analyzes large amounts of transaction data that are stored in a different database.
You write the following code segment. (Line numbers are included for reference only.)
01 Using connection As New SqlConnection(sourceConnectionString)
02 Using connection2 As _
New SqlConnection(destinationConnectionString)
03 Using command As New SqlCommand()
04 connection.Open()
05 connection2.Open()
06 Using reader As SqlDataReader = command.ExecuteReader()
07 Using bulkCopy As New SqlBulkCopy(connection2)
08
09 End Using
10 End Using
11 End Using
12 End Using
13 End Using
You need to copy the transaction data to the database of the application.
Which code segment should you insert at line 08?
A. reader.Read()
bulkCopy.WriteToServer(reader)
B. bulkCopy.DestinationTableName = "Transactions"
bulkCopy.WriteToServer(reader)
C. bulkCopy.DestinationTableName = "Transactions"
AddHandler bulkCopy.SqlRowsCopied, _
AddressOf bulkCopy_SqlRowsCopied
D. While reader.Read()
bulkCopy.WriteToServer(reader)
End While
Answer: B

Microsoft問題集   70-561   70-561認定資格

NO.27 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a DataSet object named orderDS. The object contains a table named Order as
shown in the following exhibit.
The application uses a SqlDataAdapter object named daOrder to populate the Order table.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Sub FillOrderTable(ByVal pageIndex As Integer)
02 Dim pageSize As Integer = 5
03
04 End Sub
You need to fill the Order table with the next set of 5 records for each increase in the pageIndex value.
Which code segment should you insert at line 03?
A. Dim sql As String = "SELECT SalesOrderID, CustomerID, " + _
"OrderDate FROM Sales.SalesOrderHeader"
daOrder.SelectCommand.CommandText = sql
daOrder.Fill(orderDS, pageIndex, pageSize, "Order")
B. Dim startRecord As Integer = (pageIndex - 1) * pageSize
Dim sql As String = "SELECT SalesOrderID, CustomerID, " + _
"OrderDate FROM Sales.SalesOrderHeader"
daOrder.SelectCommand.CommandText = sql
daOrder.Fill(orderDS, startRecord, pageSize, "Order")
C. Dim sql As String = _
String.Format("SELECT TOP {0} SalesOrderID, " + _
"CustomerID, OrderDate FROM Sales.SalesOrderHeader " + _
"WHERE SalesOrderID > {1}", pageSize, pageIndex)
daOrder.SelectCommand.CommandText = sql
daOrder.Fill(orderDS, "Order")
D. Dim startRecord As Integer = (pageIndex - 1) * pageSize
Dim sql As String = _
String.Format("SELECT TOP {0} SalesOrderID, " + _
"CustomerID, OrderDate FROM Sales.SalesOrderHeader " + _
"WHERE SalesOrderID > {1}", pageSize, startRecord)
daOrder.SelectCommand.CommandText = sql
daOrder.Fill(orderDS, "Order")
Answer: B

Microsoft   70-561認証試験   70-561   70-561

NO.28 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
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

Microsoft参考書   70-561認証試験   70-561過去問

NO.29 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

Microsoft練習問題   70-561   70-561認定証   70-561

NO.30 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 connection string of the application is defined in the following manner.
"Server=Prod;Database=WingtipToys;Integrated
Security=SSPI;Asynchronous Processing=true"
The application contains the following code segment. (Line numbers are included for reference only.)
01 Protected Sub UpdateData(ByVal cmd As SqlCommand)
02 cmd.Connection.Open()
03
04 lblResult.Text = "Updating ..."
05 End Sub
The cmd object takes a long time to execute.
You need to ensure that the application continues to execute while cmd is executing.
What should you do?
A. Insert the following code segment at line 03.
cmd.BeginExecuteNonQuery(New AsyncCallback( _
AddressOf UpdateComplete), cmd)
Add the following code segment.
Private Sub UpdateComplete (ByVal ar As IAsyncResult)
Dim count As Integer = CInt(ar.AsyncState)
LogResults(count)
End Sub
B. Insert the following code segment at line 03.
cmd.BeginExecuteNonQuery(New AsyncCallback( _
AddressOf UpdateComplete), cmd)
Add the following code segment.
Private Sub UpdateComplete(ByVal ar As IAsyncResult)
Dim cmd As SqlCommand = DirectCast(ar.AsyncState, SqlCommand)
Dim count As Integer = cmd.EndExecuteNonQuery(ar)
LogResults(count)
End Sub
C. Insert the following code segment at line 03.
AddHandler cmd.StatementCompleted, AddressOf UpdateComplete
cmd.ExecuteNonQuery()
Add the following code segment.
Private Sub UpdateComplete(ByVal sender As Object, _
ByVal e As StatementCompletedEventArgs)
Dim count As Integer = e.RecordCount
LogResults(count)
End Sub
D. Insert the following code segment at line 03.
Dim notification As New _
SqlNotificationRequest("UpdateComplete ", "", 10000)
cmd.Notification = notification
cmd.ExecuteNonQuery()
Add the following code segment.
Private Sub UpdateComplete (ByVal notice As SqlNotificationRequest)
Dim count As Integer = Integer.Parse(notice.UserData)
LogResults(count)
End Sub
Answer: B

Microsoft   70-561   70-561認定試験   70-561   70-561問題集

Microsoft MB7-841認定試験の例題を体験しよう

IT-Passports.comのMicrosoftのMB7-841認証試験について最新な研究を完成いたしました。無料な部分ダウンロードしてください。きっと君に失望させないと信じています。最新MicrosoftのMB7-841認定試験は真実の試験問題にもっとも近くて比較的に全面的でございます。

弊社のIT業で経験豊富な専門家たちが正確で、合理的なMicrosoft MB7-841認証問題集を作り上げました。 弊社の勉強の商品を選んで、多くの時間とエネルギーを節約こともできます。

ここで無料にIT-Passports.comが提供したMicrosoftのMB7-841試験の部分練習問題と解答をダウンロードできて、一度IT-Passports.comを選ばれば、弊社は全力に貴方達の合格を頑張ります。貴方達の試験に合格させることができないと、すぐに全額で返金いたします。

試験番号：MB7-841問題集
試験科目：Microsoft 「NAV 2009 C/SIDE Solution Development」
問題と解答：全95問

ショートカットを選択し、テクニックを使用するのはより良く成功できるからです。MB7-841認定試験に一発合格できる保障を得たいなら、IT-Passports.com のMB7-841問題集はあなたにとってユニークな、しかも最良の選択です。これは賞賛の声を禁じえない参考書です。この問題集より優秀な試験参考書を見つけることができません。このMB7-841問題集では、あなたが試験の出題範囲をより正確に理解することができ、よりよく試験に関連する知識を習得することができます。そして、もし試験の準備をするが足りないとしたら、MB7-841問題集に出る問題と回答を全部覚えたらいいです。この問題集には実際のMB7-841試験問題のすべてが含まれていますから、それだけでも試験に受かることができます。

購入前にお試し,私たちの試験の質問と回答のいずれかの無料サンプルをダウンロード：http://www.it-passports.com/MB7-841.html

NO.1 You work in an international company which is called Wiikigo. And you're employed as the Developer
for Microsoft Dynamics NAV. A client of your company wants to know the use of Web services in Microsoft
Dynamics NAV 2009 and the most important reason that you recommend Web services. So what is your
answer?
A.It is because the client has to read data from Microsoft Dynamics NAV 2009.
B.It is because the client has to write data directly to Microsoft Dynamics NAV 2009.
C.It is because the client already has a Web page and a staff to maintain it.
D.It is because the client needs to have the ability of executing business logic within Microsoft Dynamics
NAV 2009 from an external application.
Answer:D

Microsoft認証試験   MB7-841   MB7-841

NO.2 You work in an international company which is called Wiikigo. And you're employed as the Developer
for Microsoft Dynamics NAV. At present you are working on a project with your working team. You work as
the programmer for the part of data conversion. Of the following methods, which can be used to convert
the current customer balances? (this area is complete and the data has been tested)
A.An XMLPort should be written to have the data imported into the Gen. Journal Line table.
B.After an XMLPort is written to have the data imported into a Gen. Journal Line record, call the Gen.
Jnl.-Post Line code unit by using it.
C.After an XMLPort is written to have the data imported into a Gen. Journal Line record, call the Gen.
Jnl.-Check Line code unit by using it.
D.After an XMLPort is written to have the data imported into the Gen. Ledger Entry table, call the
appropriate posting routing to validate the data.
Answer:B

Microsoft   MB7-841   MB7-841問題集   MB7-841認証試験   MB7-841参考書

NO.3 You work in an international company which is called Wiikigo. And you're employed as the Developer
for Microsoft Dynamics NAV. You are appointed to work with a client of your company. The client wants to
store information outside the standard Microsoft Dynamics NAV 2009 ledger tables. According to the
requirement of the client, you have to create a solution. You have selected a master table and created a
ledger table to support. Your solution must conform to Microsoft Dynamics NAV 2009 posting standards.
Of the following codeunits, which one will have to be created? (choose more than one)
A.Post Batch will have to be created.
B.Check-Line will have to be created.
C.Post Line will have to be created.
D.Sales-Post will have to be created.
Answer:A B C

Microsoft   MB7-841練習問題   MB7-841   MB7-841過去問   MB7-841認定試験

NO.4 You work in an international company which is called Wiikigo. And you're employed as the Developer
for Microsoft Dynamics NAV. As you know, either the Classic Database Server or SQL Server can be used
by Microsoft Dynamics NAV 2009. You know how the Classic Database Server implements keys. Do you
know how key(indexes) are implemented in SQL Server?(choose more than one)
A.Non-unique indexes are forbidden.
B.The primary key index is clustered by default.
C.A table is required to have a clustered index.
D.The remainder of the primary key is added to every secondary index, making the indexes unique.
Answer:B D

Microsoft認定証   MB7-841   MB7-841   MB7-841   MB7-841   MB7-841

NO.5 You work in an international company which is called Wiikigo. And you're employed as the Developer
for Microsoft Dynamics NAV. According to company requirement, you have created a Rental Equipment
add-on. This add-on needs a Card page for the master table. In Microsoft Dynamics NAV, most Card
pages have FactBoxes attached to them. Do you know the reason?
A.It is for using in the place of a CardPart so that the data is displayed more clearly to the user.
B.It is for making sure that all validation routines are located in the same place and run as the data is
entered.
C.It is for enabling you to make adjustments to transaction information after it is posted.
D.It is for viewing additional information associated with a selected entity in the primary page.
Answer:D

Microsoft   MB7-841認証試験   MB7-841練習問題   MB7-841   MB7-841

NO.6 You work in an international company which is called Wiikigo. And you're employed as the Developer for
Microsoft Dynamics NAV. There is a colleague who is named John in the company. He does not know the
reason of using a Virtual table in Microsoft Dynamics NAV 2009. Since you are the IT professional, he
asks for your answer. So what should you reply to him?
A.As a Dataitem in a report.
B.To store global information from C/AL variables.
C.To maintain current user statistics.
D.To know when to use the COMMIT statement.
Answer:A

Microsoft   MB7-841   MB7-841過去問   MB7-841   MB7-841   MB7-841

NO.7 You work in an international company which is called Wiikigo. And you're employed as the Developer for
Microsoft Dynamics NAV. A code has been written by you. For the Customer table which is called
Customer, a record variable is created by you. Now you are asked to identify which Customers reside in
one of the regions that supported by your company, hence you intend to loop through the table. Now you
are using a record variable which is to be filtered, before the record variable is filtered, what function do
you called?
A.Customer.FINDSET()
B.Customer.SETRANGE()
C.Customer.SETCURRENTKEY()
D.Customer.SETPERMISSIONFILTER
Answer:C

Microsoft過去問   MB7-841   MB7-841

NO.8 You work in an international company which is called Wiikigo. And you're employed as the Developer
for Microsoft Dynamics NAV. There is a colleague who is named John in the company. From the options
below, he is asked to identify C/SIDE standards for a Check Line codeunit. But he is not clear about it.
Since you are the technical support, he asks for your answer. So what is your answer? (choose more than
one)
A.It is called from both Post Batch and Post Line.
B.It writes to the Register table to track posting statistics.
C.It calls the Post Line function to write the record after it is checked.
D.After the first call, it has no interaction with the server.
Answer:A D

Microsoft認証試験   MB7-841   MB7-841

NO.9 You work in an international company which is called Wiikigo. And you're employed as the Developer for
Microsoft Dynamics NAV. There is a colleague who is named John in the company. A function is created in
a codeunit by him. He chose VAR when he sets up a parameter. But he is not clear about its meaning.
Since you are the IT professional, he asks for your answer. So what do you reply to him?
A.It means that the parameter is a variable while not a text constant.
B.It means that the parameter is passed as a variant.
C.It means that the parameter is passed by reference rather than value.
D.It means that the parameter is passed as a static copy.
Answer:C

Microsoft問題集   MB7-841   MB7-841練習問題   MB7-841練習問題   MB7-841   MB7-841

NO.10 You work in an international company which is called Wiikigo. And you're employed as the Developer for
Microsoft Dynamics NAV. There is a colleague who is named John in the company. He wants to know why
it is a good idea to have a separate codeunit created for code that uses automation. (choose more than
one)
A.It is because an object using automation can only be compiled on a machine on which the automation
server is installed.
B.It is because of better performance.
C.It is because processing of records on the client machine will be enhanced.
D.It is because the automation type cannot be exported across the network.
Answer:A B

Microsoft過去問   MB7-841   MB7-841   MB7-841問題集

NO.11 You work in an international company which is called Wiikigo. And you're employed as the Developer for
Microsoft Dynamics NAV. There is a colleague who is named John in the company. From the options
below, he is asked to identify the one that is a use for FlowFields in Microsoft Dynamics NAV 2009. But he
is not clear about the answer. Since you are the IT professional, he asks for your answer. So what should
you reply to him?
A.Calculate time between events.
B.Modify the sign of data in a table
C.Write replacement records to a Master table.
D.Lookup information in a related table.
Answer:D

Microsoft   MB7-841認証試験   MB7-841   MB7-841   MB7-841

NO.12 You work in an international company which is called Wiikigo. And you're employed as the Developer for
Microsoft Dynamics NAV. The company assigns a task to you. You have to train the users to use the
C/SIDE report writer to write reports. Of the following options, which describes correctly that you can use
of the OnInitReport trigger in a report?
A.The Request Form has not been processed.
B.Data from Data Item tables can be accessed.
C.The OnPreReport trigger can be called from a single instance codeunit.
D.You cannot call a private function cannot be called in the same report object.
Answer:A

Microsoft   MB7-841認定資格   MB7-841問題集   MB7-841問題集

NO.13 You work in an international company which is called Wiikigo. And you're employed as the Developer
for Microsoft Dynamics NAV. Another programmer has written a report. But it is not producing any output.
Therefore, your company asks you to find out the reason. So what may cause this?
A.The request form was not used.
B.Calcsums was not called in the OnAfterGetRecord trigger.
C.The report has been filtered with code so that no records match the filter(s).
D.The PrintOnlyIfDetail property has been set to true on the outermost indented DataItem.
Answer:D

Microsoft認定資格   MB7-841   MB7-841   MB7-841   MB7-841

NO.14 You work in an international company which is called Wiikigo. And you're employed as the Developer
for Microsoft Dynamics NAV. You have created an XMLPort. You want to run the XMLPort to export a list
of customers for sales representative in C/SIDE. Besides the XMLPort, which do you need to instantiate
to process the XMLPort?
A.A READSTREAM object
B.A MESSAGE object
C.An OUTSTREAM object
D.An INSTREAM object
Answer:C

Microsoft練習問題   MB7-841認定証   MB7-841認定試験

NO.15 You work in an international company which is called Wiikigo. And you're employed as the Developer
for Microsoft Dynamics NAV. Now you are modifying a function in a standard C/SIDE codeunit. The
function has a record variable passed to it by reference and is usually called from a report. In order to
check the filters that the user may have applied to the record variable, you need to have code added to
the function to perform this. Is this possible to do this? Why?
A.It is impossible since it is passed by reference and the information passed does not include filters.
B.It is impossible, the report keeps the set of records the user selected unless the variable is passed by
value.
C.It is possible, even though the record variable only gives you access to one record, there is a system
variable which contains all filters that the user has applied.
D.It is possible since the record variable represents a set of records from the associated table including
the filters and key.
Answer:D

Microsoft   MB7-841過去問   MB7-841

NO.16 You work in an international company which is called Wiikigo. And you're employed as the Developer
for Microsoft Dynamics NAV. In order to look at detail information in the Ledger table, a FlowField has
been designed in a Master table. Someone asked you to have a FlowFilter field added to the table as well.
Do you know what is a FlowFilter field used for?
A.It is used to filter the form view of the FlowField in the Microsoft SQL Server only.
B.It is used to limit write access to data in the FlowField detail table.
C.It is used to include in the CalcFormula of a FlowField, which will permit programmer- defined filters to
modify the SumIndexFields during the FlowField calculation.
D.It is used to include in the CalcFormula of a FlowField, which will permit user- defined filters to be
applied in the Flow Field calculation.
Answer:C

Microsoft参考書   MB7-841   MB7-841問題集   MB7-841参考書

NO.17 You work in an international company which is called Wiikigo. And you're employed as the Developer for
Microsoft Dynamics NAV. You are appointed to work with a client of your company. Now you are asked to
create a custom report which groups Customers by Sales representative. Of the following options, which
is the reason for applying grouping in a Microsoft Dynamics NAV 2009 report? (choose more than one)
A.It is for causing the report to print a sub-heading each time the salesperson code changes when printing
a list of customers.
B.It is for allowing the user to filter the report on the date of the transactions.
C.It is for causing the report to print a new page for each salesperson when printing a list of customers.
D.It is for causing two or more customer reports to print simultaneously for each salesperson.
Answer:A C

Microsoft   MB7-841認定証   MB7-841過去問   MB7-841

NO.18 You work in an international company which is called Wiikigo. And you're employed as the Developer for
Microsoft Dynamics NAV. An export XMLPort has been created by you. Now you are asked to run this
export XMLPort. Of the following options, which one is required to be instantiated to process the XMLPort?
(choose more than one)
A.The XMLPort is required to be instantiated to process the XMLPort.
B.A MESSAGE function is required to be instantiated to process the XMLPort.
C.A file to receive the data is required to be instantiated to process the XMLPort.
D.An OUTSTREAM object is required to be instantiated to process the XMLPort.
Answer:A C D

Microsoft問題集   MB7-841   MB7-841認定資格

NO.19 You work in an international company which is called Wiikigo. And you're employed as the Developer for
Microsoft Dynamics NAV. There is a page object. A number of familiar methods are exposed when the
page object is published as a Web service. Do you know which of the following belongs to the methods?
A.One of the methods is OnOpenPage
B.One of the methods is READ.
C.One of the methods is VALIDATE
D.One of the methods is OnAfterGetRecord
Answer:B

Microsoft認定資格   MB7-841   MB7-841認定資格   MB7-841練習問題   MB7-841過去問

NO.20 You work in an international company which is called Wiikigo. And you're employed as the Developer
for Microsoft Dynamics NAV. There is a colleague who is named John in the company. He is asked to
consider the snippet of code below: WITH RentalEquipment DO BEGIN
VALIDATE(Amount,RentalContractLine.Amount); "Late Fee" :=
CalcLateFee(EquipmentRentalContractLine); MODIFY; END; John is asked to describe the purpose of
the VALIDATE statement. But he is not clear about the purpose. Since you are the technical support, he
asks for your answer. So what do you reply to him?
A.The purpose is to decrement the value of the Amount field.
B.The purpose is to run any code in the field's ONValidate trigger.
C.The purpose is to avoid having to use the scope operator when addressing the field.
D.The purpose is to make sure that the RentalContractLine.Amount field is a decimal type.
Answer:B

Microsoft   MB7-841過去問   MB7-841   MB7-841認定試験

IT-Passports.comのMB7-841試験参考書は他のMB7-841試験に関連するする参考書よりずっと良いです。これは試験の一発合格を保証できる問題集ですから。この問題集の高い合格率が多くの受験生たちに証明されたのです。IT-Passports.comのMB7-841問題集は成功へのショートカットです。この問題集を利用したら、あなたは試験に準備する時間を節約することができるだけでなく、試験で楽に高い点数を取ることもできます。