单选题You create a Web Form that displays a GridView. The GridViews data source is a DataSet named dsOrders. The DataSet contains two DataTables named Orders and OrderDetails. You create a relation between the two DataTables using the following code segment. (Line numbers are included for reference only.)01 dtOrders = dsOrders.Tables[“Orders”]; 02 dtOrderDetails = dsOrders.Tables[“OrderDetail”]; 03 colParent = dtOrders.Columns[“OrderID”]; 04 colChild = dtOrderDetails.Columns[“ParentOrderID”]; 05 dsOrders.Relations.Add(“Rell”, colParent, colChild, false); You need to find the cause of the exception being raised in line 05. What should you do? （）AEnsure that the child column and the parent column have the same names.BEnsure that the child table and the parent table have the same names.CEnsure that the child column and the parent column have the same data types.DEnsure that each row in the child table has a corresponding row in the parent table.EEnsure that the tables have an explicit relationship defined by a foreign key constraint in the database.
单选题
You create a Web Form that displays a GridView. The GridViews data source is a DataSet named dsOrders. The DataSet contains two DataTables named Orders and OrderDetails. You create a relation between the two DataTables using the following code segment. (Line numbers are included for reference only.)01 dtOrders = dsOrders.Tables[“Orders”]; 02 dtOrderDetails = dsOrders.Tables[“OrderDetail”]; 03 colParent = dtOrders.Columns[“OrderID”]; 04 colChild = dtOrderDetails.Columns[“ParentOrderID”]; 05 dsOrders.Relations.Add(“Rell”, colParent, colChild, false); You need to find the cause of the exception being raised in line 05. What should you do? （）
A
Ensure that the child column and the parent column have the same names.
B
Ensure that the child table and the parent table have the same names.
C
Ensure that the child column and the parent column have the same data types.
D
Ensure that each row in the child table has a corresponding row in the parent table.
E
Ensure that the tables have an explicit relationship defined by a foreign key constraint in the database.
参考解析
解析：
暂无解析
相关考题：
You use Microsoft .NET Framework 4 to create a Windows Forms client application.You write the following code segment.The application contains a form of type Form1 that contains a FormSettings object named frmSettings1.You need to maintain the user‘s form size preference each time the user executes the application.Which code segment should you use? （）A.B.C.D.
You are creating a mobile Web Form that dynamically displays news items. You want to display news items by using an instance of a mobile TextView control named TextViewNews. You need to configure the Web Form that contains TextViewNews. The Web Form must enable pagination in casea users device does not display the full text of a news item.Which code segment should you use? （）A.B.C.D.
You are creating a Web Form. The Web Form allows users to rename or delete products in a list. You create a DataTable named dtProducts that is bound to a GridView. DataTable has the following four rows. dtProducts.Rows(0)(ProductName) = SoapdtProducts.Rows(1)(ProductName) = BookdtProducts.Rows(2)(ProductName) = ComputerdtProducts.Rows(3)(ProductName) = SpoondtProducts.AcceptChanges()The user utilizes a Web Form to delete the first product. You need to set the RowStateFilter property of the DataTables DefaultView so that only products that have not been deleted are shown. To which value should you set the DataTabless DefaultView.RowStateFilter?（）A. Data View Row State.Modified OriginalB. Data View Row State.Modified CurrentC. Data View Row State.Current RowsD. Data View Row State.Added
You create a Web Form that contains connected Web Parts. You write the following declaration in your Web Form.You need to ensure that your Web Part connection is valid. Which two actions should you perform? （）A. Include a data source identified as WebPartConnection1 on the Web Form.B. Include a Web Part identified as customerPart on the Web Form.C. Include a Web Part identified as ordersPart on the Web Form.D. Ensure that you declare an interface named IOrdersPart.E. Ensure that you declare an interface named ICustomerPart.F. Ensure that each Web Part declares either a GetInterface or ProvideInterface method.
You are the administrator of a SQL Server 2000 database. You import a table of geographic information from a Microsoft access database into a SQL Server 2000 database. The table has 12,000 rows. Each row averages 5,000 bytes. The table contains lockup data that does not change.You want to minimize the size of the data file and the time required to back up the data. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)A. Create a 60-MB data file named geography.ndfB. Create a 95-MB data file named geography.ndfC. Create a 60-MB data file named geography.mdfD. Create a 95-MB data file named geography.mdfE. Place the table in the PRIMARY filegroup.F. Place the table in a new filegroup named LOCATION.
You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）A、Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.B、Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’C、Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）D、Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport
You use Microsoft .NET Framework 4 to create a Windows Forms application. You add a new class named Customer to the application. You select the Customer class to create a new object data source. You add the following components to a Windows Form: A BindingSource component named customerBindingSource that is data-bound to the Customer object data source. A set of TextBox controls to display and edit the Customer object properties. Each TextBox control is data-bound to a property of the customerBindingSource component. An ErrorProvider component named errorProvider that validates the input values for each TextBox control. You need to ensure that the input data for each TextBox control is automatically validated by using the ErrorProvider component. Which two actions should you perform?（）A、Implement the validation rules inside the Validating event handler of each TextBox control by throwing an exception when the value is invalid.B、Implement the validation rules inside the TextChanged event handler of each TextBox control by throwing an exception when the value is invalid.C、Implement the validation rules inside the setter of each property of the Customer class by throwing an exception when the value is invalid.D、Add the following code segment to the InitializeComponent method of the Windows Form.this.errorProvider.DataSource = this.customerBindingSource;E、Add the following code segment to the InitializeComponent method of the Windows Form. this.errorProvider.DataSource = this.customerBindingSource.DataSource; this.errorProvider.DataMember = this.customerBindingSource.DataMember;
You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services （SSRS） solution that contains five sales dashboard reports. Users must be able to manipulate the reports’ parameters to analyze data. You need to ensure that the following requirements are met： Users can manipulate the parameters for data analysis in a single trip to the data source. Reports are automatically rendered as soon as they are accessed for the first time. Which two tasks should you perform？（）A、 Filter data by using expressions.B、 Specify the default values for each parameter.C、 Create an available values list for each parameter.D、 Create report parameters by using query parameters to filter data at the data source.
You create a Web Form that contains connected Web Parts. You write the following declaration in your Web Form. You need to ensure that your Web Part connection is valid. Which two actions should you perform? （）A、Include a data source identified as "WebPartConnection1" on the Web Form.B、Include a Web Part identified as "customerPart" on the Web Form.C、Include a Web Part identified as "ordersPart" on the Web Form.D、Ensure that you declare an interface named "IOrdersPart".E、Ensure that you declare an interface named "ICustomerPart".F、Ensure that each Web Part declares either a GetInterface or ProvideInterface method.
You create a Web Form that displays a GridView. The GridViews data source is a DataSet named dsOrders. The DataSet contains two DataTables named Orders and OrderDetails. You create a relation between the two DataTables using the following code segment. (Line numbers are included for reference only.)01 dtOrders = dsOrders.Tables[“Orders”]; 02 dtOrderDetails = dsOrders.Tables[“OrderDetail”]; 03 colParent = dtOrders.Columns[“OrderID”]; 04 colChild = dtOrderDetails.Columns[“ParentOrderID”]; 05 dsOrders.Relations.Add(“Rell”, colParent, colChild, false); You need to find the cause of the exception being raised in line 05. What should you do? （）A、Ensure that the child column and the parent column have the same names.B、Ensure that the child table and the parent table have the same names.C、Ensure that the child column and the parent column have the same data types.D、Ensure that each row in the child table has a corresponding row in the parent table.E、Ensure that the tables have an explicit relationship defined by a foreign key constraint in the database.
You design a SQL Server 2008 Reporting Services （SSRS） solution. You create a report by using Microsoft Visual Studio .NET 2008. The report contains the following components： A dataset named Customer that lists all active customers and their details. The dataset accepts no parameters. A dataset named SalesHistory that lists all sales transactions for a specified time period and accepts year and month as parameters. You need to ensure that a summary of sales transactions is displayed for each customer after the customer details. Which component should you add to the report？ （）A、 ListB、 TableC、 MatrixD、 Subreport
You are implementing an ASP.NET page. The page includes a method named GetCustomerOrderDataSet that returns a DataSet. The DataSet includes a DataTable named CustomerDetailsTable and a DataTable named OrderDetailsTable. You need to display the data in OrderDetailsTable in a DetailsView control named dtlView. Which code segment should you use？（）A、 dtlView.DataSource = GetCustomerOrderDataSet（）； dtlView.DataMember = "OrderDetailsTable"； dtlView.DataBind（）；B、dtlView.DataSource = GetCustomerOrderDataSet（）； dtlView.DataSourceID = "OrderDetailsTable"； dtlView.DataBind（）；C、dtlView.DataSource = GetCustomerOrderDataSet（）； dtlView.DataKeyNames = new string [] { "OrderDetailsTable"}； dtlView.DataBind（）；D、DataSet dataSet = GetCustomerOrderDataSet（）； dtlView.DataSource = new DataTable（"dataSet"， "OrderDetailsTable"）； dtlView.DataBind（）；
You create a Web Form. The Web Form contains two Web Parts named CustomerPart and OrdersPart. CustomerPart contains a drop-down list of customers. OrdersPart contains a list of orders that a customer has placed. You need to create a static connection between CustomerPart and OrdersPart. When a user selects a customer from CustomerPart, OrdersPart must update. Which four actions should you perform? （）A、Add the ConnectionProvider attribute to OrdersPart.B、Add the ConnectionProvider attribute to CustomerPart.C、Add the ConnectionConsumer attribute to CustomerPart.D、Add the ConnectionConsumer attribute to OrdersPart.E、Add OrdersPart and CustomerPart to the WebParts directory.F、Add OrdersPart and CustomerPart to the App_Code directory.G、Declare the connections within a StaticConnections subtag of a WebPartZone class.H、Declare the connections within a StaticConnections subtag of a WebPartManager class.I、Define an interface specifying the methods and properties that are shared between the Web Parts.
Your network contains an Active Directory domain named contoso.com. The domain contains a member server named Server1. Server1 runs Windows Server 2012 R2 and has the File Server server role installed. On Server1， you create a share named Documents. You need to ensure that users can recover files that they accidently delete from Documents. What should you do？（）A、Enable shadow copies by using Computer ManagementB、Modify the Startup type of the Volume Shadow Copy Service （VSS） by using the Services consoleC、Create a recovery partition by using Windows Assessment and Deployment Kit （Windows ADK）.D、Create a storage pool that contains a two-way mirrored volume by using Server Manager
You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services （SSRS） solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements： ·Uses minimum amount of development effort. ·Provides two sets of tables in SSRS to the developers group and the power users group. Which strategy should you use？（）A、 Create two Report Builder models.Include the four frequently used tables in the first model and all the tables in the second model.B、 Create a Report Builder model by using all the tables.Create a perspective within the model to use only the four frequently used tables.C、 Create a Report Builder model by using all the tables. Create two folders.Place the four frequently used tables in the first folder and the remaining tables in the second folder.D、 Create two Data Source Views.Include all the tables in one Data Source View and the four frequently used tables in the other Data Source View.Create two Report Builder models so that each model uses one of the Data Source Views.
You create a Web Form. The Web Form allows users to log on to a Web site. You implement the login logic using a Login control named Login1. The membership data for the application is stored in a SQL Express database in the App_Data directory. You need to configure your application so that the membership data is stored in a local Microsoft SQL Server database. You add the following code segment to the Web.config file. Which two additional actions should you perform?（）A、Use Aspnet_regsql.exe to create the Microsoft SQL Server database.B、Set Login1's MembershipProvider property to MySqlProviderConnection.C、Add the following code segment to the Web.config file.connectionStrings add name="MySqlProviderConnection" connectionString="valid connection string" //connectionStringsD、Add the following code segment to the Web.config file.appSettingsadd key="MySqlProviderConnection" value="valid connection string" //appSettingsE、In the ASP.NET configuration settings within IIS, ensure that Role Management Enabled is selected.F、Use the Web Site Administration Tool to select AspNetSqlMembershipProvider as the membership provider for your application.
Your network contains two data centers named Datacenter1 and Datacenter2. An Active Directory site exists for each data center. The data centers connect to the Internet by using a direct link. The data centers connect to each other by using a high-speed WAN link. You plan to deploy Exchange Server 2010 Mailbox servers in both data centers. You need to plan message routing to meet the following requirements：.Ensure outbound delivery of e-mail messages if a single server fails .Automatically load balance the Hub Transport server in each site .Deploy the minimum number of servers What should you include in the plan？（）A、In each data center， deploy one Hub Transport server. Create and configure one Send connector.B、In each data center， deploy two Hub Transport servers. Create and configure one Send connector.C、In each data center， deploy one Edge Transport server. Create and configure two Send connectors.D、In each data center， deploy two Edge Transport servers. Create and configure two Send connectors.
You are creating a Web Form. The Web Form allows users to rename or delete products in a list. You create a DataTable named dtProducts that is bound to a GridView. DataTable has the following four rows. dtProducts. Rows[0]["ProductName"] = “Soap”;dtProducts. Rows[1][“ProductName”]= “Book”;dtProducts. Rows[2][“ProductName”]= “Computer”;dtProducts. Rows[3][“ProductName”]= “Spoon”;dtProducts. AcceptChanges（ ）; The user utilizes a Web Form to delete the first product. You need to set the RowStateFilter property of the DataTables DefaultView so that only products that have not been deleted are shown. To which value should you set the DataTabless DefaultView.RowStateFilter? （）A、Data V iewRowState.ModifiedOriginal;B、Data V iewRowState.ModifiedCurrent;C、Data V iewRowState.CurrentRows;D、Data V iewRowState.Added;
单选题You are creating a Web Form. The Web Form allows users to rename or delete products in a list. You create a DataTable named dtProducts that is bound to a GridView. DataTable has the following four rows. dtProducts. Rows[0]["ProductName"] = “Soap”;dtProducts. Rows[1][“ProductName”]= “Book”;dtProducts. Rows[2][“ProductName”]= “Computer”;dtProducts. Rows[3][“ProductName”]= “Spoon”;dtProducts. AcceptChanges（ ）; The user utilizes a Web Form to delete the first product. You need to set the RowStateFilter property of the DataTables DefaultView so that only products that have not been deleted are shown. To which value should you set the DataTabless DefaultView.RowStateFilter? （）AData V iewRowState.ModifiedOriginal;BData V iewRowState.ModifiedCurrent;CData V iewRowState.CurrentRows;DData V iewRowState.Added;
单选题You are implementing an ASP.NET page. The page includes a method named GetCustomerOrderDataSet that returns a DataSet. The DataSet includes a DataTable named CustomerDetailsTable and a DataTable named OrderDetailsTable. You need to display the data in OrderDetailsTable in a DetailsView control named dtlView. Which code segment should you use？（）A dtlView.DataSource = GetCustomerOrderDataSet（）； dtlView.DataMember = OrderDetailsTable； dtlView.DataBind（）；BdtlView.DataSource = GetCustomerOrderDataSet（）； dtlView.DataSourceID = OrderDetailsTable； dtlView.DataBind（）；CdtlView.DataSource = GetCustomerOrderDataSet（）； dtlView.DataKeyNames = new string [] { OrderDetailsTable}； dtlView.DataBind（）；DDataSet dataSet = GetCustomerOrderDataSet（）； dtlView.DataSource = new DataTable（dataSet， OrderDetailsTable）； dtlView.DataBind（）；
单选题You are creating a Web Form. The Web Form allows users to rename or delete products in a list. You create a DataTable named dtProducts that is bound to a GridView. DataTable has the following four rows. dtProducts. Rows(0)("ProductName") = "Soap"dtProducts. Rows(1)("ProductName") = "Book"dtProducts. Rows(2)("ProductName") = "Computer"dtProducts. Rows(3)("ProductName") = "Spoon"dtProducts. AcceptChanges（ ） The user utilizes a Web Form to delete the first product. You need to set the RowStateFilter property of the DataTables DefaultView so that only products that have not been deleted are shown. To which value should you set the DataTabless DefaultView.RowStateFilter?（）AData View Row State.Modified OriginalBData View Row State.Modified CurrentCData View Row State.Current RowsDData View Row State.Added
单选题You design a Business Intelligence （BI） solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services （SSAS） solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers： ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do？（）A Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.B Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.C Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.D Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.
单选题You create a Web Form that displays a GridView. The GridViews data source is a DataSet named dsOrders. The DataSet contains two DataTables named Orders and OrderDetails. You create a relation between the two DataTables using the following code segment. (Line numbers are included for reference only.)01 dtOrders = dsOrders.Tables[“Orders”]; 02 dtOrderDetails = dsOrders.Tables[“OrderDetail”]; 03 colParent = dtOrders.Columns[“OrderID”]; 04 colChild = dtOrderDetails.Columns[“ParentOrderID”]; 05 dsOrders.Relations.Add(“Rell”, colParent, colChild, false); You need to find the cause of the exception being raised in line 05. What should you do? （）AEnsure that the child column and the parent column have the same names.BEnsure that the child table and the parent table have the same names.CEnsure that the child column and the parent column have the same data types.DEnsure that each row in the child table has a corresponding row in the parent table.EEnsure that the tables have an explicit relationship defined by a foreign key constraint in the database.
单选题Your network contains two data centers named Datacenter1 and Datacenter2. An Active Directory site exists for each data center. The data centers connect to the Internet by using a direct link. The data centers connect to each other by using a high-speed WAN link. You plan to deploy Exchange Server 2010 Mailbox servers in both data centers. You need to plan message routing to meet the following requirements：.Ensure outbound delivery of e-mail messages if a single server fails .Automatically load balance the Hub Transport server in each site .Deploy the minimum number of servers What should you include in the plan？（）AIn each data center， deploy one Hub Transport server. Create and configure one Send connector.BIn each data center， deploy two Hub Transport servers. Create and configure one Send connector.CIn each data center， deploy one Edge Transport server. Create and configure two Send connectors.DIn each data center， deploy two Edge Transport servers. Create and configure two Send connectors.
单选题You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）ACreate a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.BCreate a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’CCreate a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）DCreate services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport
单选题You design a SQL Server 2008 Reporting Services （SSRS） solution. You create a report by using Microsoft Visual Studio .NET 2008. The report contains the following components： A dataset named Customer that lists all active customers and their details. The dataset accepts no parameters. A dataset named SalesHistory that lists all sales transactions for a specified time period and accepts year and month as parameters. You need to ensure that a summary of sales transactions is displayed for each customer after the customer details. Which component should you add to the report？ （）A ListB TableC MatrixD Subreport
多选题You create a Web Form. The Web Form contains two Web Parts named CustomerPart and OrdersPart. CustomerPart contains a drop-down list of customers. OrdersPart contains a list of orders that a customer has placed. You need to create a static connection between CustomerPart and OrdersPart. When a user selects a customer from CustomerPart, OrdersPart must update. Which four actions should you perform? （）AAdd the ConnectionProvider attribute to OrdersPart.BAdd the ConnectionProvider attribute to CustomerPart.CAdd the ConnectionConsumer attribute to CustomerPart.DAdd the ConnectionConsumer attribute to OrdersPart.EAdd OrdersPart and CustomerPart to the WebParts directory.FAdd OrdersPart and CustomerPart to the App_Code directory.GDeclare the connections within a StaticConnections subtag of a WebPartZone class.HDeclare the connections within a StaticConnections subtag of a WebPartManager class.IDefine an interface specifying the methods and properties that are shared between the Web Parts.
单选题You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services （SSRS） solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements： ·Uses minimum amount of development effort. ·Provides two sets of tables in SSRS to the developers group and the power users group. Which strategy should you use？（）A Create two Report Builder models.Include the four frequently used tables in the first model and all the tables in the second model.B Create a Report Builder model by using all the tables.Create a perspective within the model to use only the four frequently used tables.C Create a Report Builder model by using all the tables. Create two folders.Place the four frequently used tables in the first folder and the remaining tables in the second folder.D Create two Data Source Views.Include all the tables in one Data Source View and the four frequently used tables in the other Data Source View.Create two Report Builder models so that each model uses one of the Data Source Views.