70-516 무료 덤프문제 온라인 액세스

You use Microsoft Visual Studio 2010 and Microsoft. NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database. You use Entity SQL of the ADO.NET Entity
Framework to retrieve data from the database.
You need to define a custom function in the conceptual model. You also need to ensure that the function
calculates a value based on properties of the object.
Which two XML element types should you use? (Each correct answer presents part of the solution. Choose
two.)

• A.FunctionImport
• B.Dependent
• C.DefiningExpression
• D.Association
• E.Function

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database.
The application uses a DataTable named OrderDetailTable that has the following columns:
-ID
-OrderID
-ProductID
-Quantity
-LineTotal
Some 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 column = new DataColumn("UnitPrice", typeof(double));
02 ...
03 OrderDetailTable.Columns.Add(column);
You need to add a calculated DataColumn named UnitPrice to the OrderDetailTable object.
You also need to ensure that UnitPrice is set to 0 when it cannot be calculated.
Which code segment should you insert at line 02?

• A.column.Expression = "LineTotal/ISNULL(Quantity, 1)";
• B.column.Expression = "iif(Quantity > 0, LineTotal/Quantity, 0)";
• C.column.Expression = "if(Quantity > 0, LineTotal/Quantity, 0)";
• D.column.Expression = "LineTotal/Quantity";

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database.
The application has two DataTable objects that reference the Customers and Orders tables in the
database.
The application contains the following code segment. (Line numbers are included for reference only.)
01 DataSet customerOrders = new DataSet();
02 customerOrders.EnforceConstraints = true;
03 ForeignKeyConstraint ordersFK = new ForeignKeyConstraint("ordersFK",
04 customerOrders.Tables
["Customers"].Columns["CustomerID"],
05 customerOrders.Tables["Orders"].Columns
["CustomerID"]);
06 ...
07 customerOrders.Tables["Orders"].Constraints.Add(ordersFK);
You need to ensure that an exception is thrown when you attempt to delete Customer records that have related Order records.
Which code segment should you insert at line 06?

• A.ordersFK.DeleteRule = Rule.None;
• B.ordersFK.DeleteRule = Rule.SetNull;
• C.ordersFK.DeleteRule = Rule.SetDefault;
• D.ordersFK.DeleteRule = Rule.Cascade;

The application must be configured to run on a new development computer.
You need to configure the connection string to point to the existing named instance.
Which connection string fragment should you use?

• A.Data Source=SQL01\INST01
• B.Data Source=INST01\SQL01
• C.Initial Catalog= SQL01\INST01
• D.Initial Catalog= INST01\SQL01

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server 2008 database.
SQLConnection conn = new SQLConnection(connectionString);
conn.Open();
SqlTransaction tran = db.BeginTransaction(IsolationLevel. ...);
...
You must retrieve not commited records originate from various transactions. Which method should you use?

• A.ReadUncommited
• B.ReadCommited
• C.RepeatableRead
• D.Serializable