Microsoft 070-515 Value Pack (Frequently Bought Together)

You are adding new capabilities to an ASP.NET web site. The site currently connects to a Microsoft SQL Server database by using the credentials of the CONTOSO\AppIdentity account, which has been granted access to only objects within the database.
The application requires the following implementation:
Database objects that support ASP.NET roles must be added to the existing database.
The Contoso\AppIdentity user must be granted only the minimum privileges that are required to support all features of ASP.NET roles.
You need to add the ASP.NET roles support.
Which two actions should you perform? (Each correct answer presents part of the complete solution. Choose two.)

• A. Add the CONTOSO\AppIdentity user to the db_accessadmin database role.
• B. Use the aspnet_regsql tool.
• C. Use the aspnet_regiis tool.
• D. Add the CONTOSO\AppIdentity user to the asp_Roles_FullAccess database role.

You are preparing to deploy an ASP.NET application to a production server by publishing the application in
Release configuration.
You need to ensure that the connection string value that is stored in the web.config file is updated to the
production server's connection string value during publishing.
What should you do?

• A. Add the following code to the web.release.config file.
  <connectionStrings>
  <add name="DB"
  connectionString="Server=ProdServer;Database=ProdDB;Integrated
  Security=SSPI;" providerName="Release" />
  </connectionStrings>
• B. Add the following code to the web.release.config file.
  <connectionStrings>
  <add name="DB"
  connectionString="Server=ProdServer;Database=ProdDB;Integrated
  Security=SSPI;" xdt:Transform="Replace" xdt:Locator="Match(name)" />
  </connectionStrings>
• C. Add the following code to the web.config file.
  <connectionStrings>
  <add name="DB"
  connectionString="Server=ProdServer;Database=ProdDB;Integrated
  Security=SSPI;" xdt:Transform="Replace" xdt:Locator="Match(name)" />
  </connectionStrings>
• D. Add the following code to the web.config file.
  <connectionStrings>
  <add name="DB"
  connectionString="Server=ProdServer;Database=ProdDB;Integrated
  Security=SSPI;" providerName="Release" />
  </connectionStrings>

Which of the following is the correct syntax to specify the path to a file that generates the strong type?

• A. <%@ PreviousPageType VirtualPath ="~/MyPage.aspx"% >
• B. <%@ PreviousPageType VirtualPath ="/MyPage.aspx/ ~"% >
• C. <%@ PreviousPageType VirtualPath ="~/MyPage.master"% >
• D. <%@ PreviousPageType VirtualPath ="~/MyPage"% >

You are implementing a read-only page that includes the following controls.
<asp:Button ID="btnRefresh" runat="server" Text="Button" /> <asp:GridView ID="gvCustomers" runat="server" EnableViewState="False" OnDataBinding="gvCustomers_DataBinding"></asp:GridView>
You disable view state to improve performance.
You need to ensure that the page is updated to display the latest data when the user clicks the refresh
button.
Which code segment should you use?

• A. protected void Page_PreRender(object sender, EventArgs e)
  {
  if (!IsPostBack)
  {
  gvCustomers.DataSource = GetCustomers();
  gvCustomers.DataBind();
  }
  }
• B. protected void gvCustomers_DataBinding(object sender, EventArgs e)
  {
  gvCustomers.DataSource = GetCustomers();
  gvCustomers.DataBind();
  }
• C. protected void Page_PreInit(object sender, EventArgs e)
  {
  if (!IsPostBack)
  {
  gvCustomers.DataSource = GetCustomers();
  gvCustomers.DataBind();
  }
  }
• D. protected void Page_Load(object sender, EventArgs e)
  {
  gvCustomers.DataSource = GetCustomers();
  gvCustomers.DataBind();
  }

You are developing an ASP.NET Web application.
The application must pass an object that contains user-specific data between multiple pages.
The object is more than 100 KB in size when serialized.You need to minimize the amount of data is sent to
the user.
What should you do?

• A. Use a cookie that contains the object data.
• B. Pass the object data in a hidden field.
• C. Store the object instance in a session variable.
• D. Encode the object data and pass it in a query string parameter.