Monthly Archives: July 2014

  • Free Download Microsoft 70-462 VCE Test Engine Full Version Now (81-90)

    QUESTION 81
    Drag and Drop Question
    You administer a Microsoft SQL Server 2012 environment that contains a production SQL Server 2005 instance named SQL2005 and a development SQL Server 2012 instance named SQL2012. The development team develops a new application that uses the SQL Server 2012 functionality. You are planning to migrate a database from SQL2005 to SQL2012 so that the development team can test their new application. You need to migrate the database without affecting the production environment. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

    image
    Answer:

    image 

    (more…)

  • Free Download Microsoft 70-462 VCE Test Engine Full Version Now (71-80)

    QUESTION 71
    You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. The recovery model and backup schedule are configured as shown in the following table:

    image
    At 14:00 hours, you discover that pages 71, 520, and 713 on one of the database files are corrupted on the reporting database. You need to ensure that the databases are restored. You also need to ensure that data loss is minimal. What should you do?

    A.    Perform a partial restore.
    B.    Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup.
    C.    Restore the latest full backup.
    D.    Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
    E.    Perform a page restore.
    F.    Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.
    G.    Perform a point-in-time restore.
    H.    Restore the latest full backup. Then, restore the latest differential backup.

    Answer: H
    Explanation:
    File restore
    Restores a file or filegroup in a multi-filegroup database. Note that under the simple recovery model, the file must belong to a read-only filegroup. After a full file restore, a differential file backup can be restored.
    Page restore
    Restores individual pages. Page restore is available only under the full and bulk-logged recovery models
    Piecemeal restore
    Restores the database in stages, beginning with the primary filegroup and one or more secondary filegroups. A piecemeal restore begins with a RESTORE DATABASE using the PARTIAL option and specifying one or more secondary filegroups to be restored

    (more…)

  • Free Download Microsoft 70-462 VCE Test Engine Full Version Now (61-70)

    QUESTION 61
    You administer a Microsoft SQL Server 2012 failover cluster that contains two nodes named Node A and Node B. A single instance of SQL Server is installed on the cluster. An additional node named Node C has been added to the existing cluster. You need to ensure that the SQL Server instance can use all nodes of the cluster. What should you do?

    A.    Create a ConfigurationFile.ini file from Node B, and then run the AddNode command-line tool on Node A.
    B.    Use Node A to install SQL Server on Node C.
    C.    Run the Add Node to SQL Server Failover Cluster Wizard on Node C.
    D.    Use Cluster Administrator to add a new Resource Group to Node B.

    Answer: C

    (more…)

  • Free Download Microsoft 70-462 VCE Test Engine Full Version Now (51-60)

    QUESTION 51
    Drag and Drop Question
    You administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to use a local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server Agent job. The SSIS package accesses a network share when exporting data from a SQL Server database. When you execute the SQL Server Agent job, it fails due to a permissions failure on a share on a remote server. You need to ensure that the SQL Server Agent job can execute the SSIS package. Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

    image
    Answer:

    image 

    (more…)

  • Free Download Microsoft 70-462 VCE Test Engine Full Version Now (41-50)

    QUESTION 41
    You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording events and playing them back on a different test server. What should you create?

    A.    an Extended Event session
    B.    a Policy
    C.    a Database Audit Specification
    D.    an Alert
    E.    a Server Audit Specification
    F.    a SQL Profiler Trace
    G.    a Resource Pool

    Answer: F

    (more…)

  • Free Download Microsoft 70-462 VCE Test Engine Full Version Now (31-40)

    QUESTION 31
    You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail. You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation. You need to achieve this goal without taking the index offline. Which Transact-SQL batch should you use?

    A.    CREATE INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID WITH DROP EXISTING
    B.    ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REORGANIZE
    C.    ALTER INDEX ALL ON OrderDetail REBUILD
    D.    ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REBUILD

    Answer: B

    (more…)

  • Free Download Microsoft 70-462 VCE Test Engine Full Version Now (21-30)

    QUESTION 21
    You administer a Microsoft SQL Server 2012 database. The database contains a Product table created by using the following definition:

    image
    You need to ensure that the minimum amount of disk space is used to store the data in the Product table. What should you do?

    A.    Convert all indexes to Column Store indexes.
    B.    Implement Unicode Compression.
    C.    Implement row-level compression.
    D.    Implement page-level compression.

    Answer: D
    Explanation:
    http://msdn.microsoft.com/en-us/library/cc280449.aspx http://msdn.microsoft.com/en-us/library/cc280464.aspx http://msdn.microsoft.com/en-us/library/cc280576.aspx http://msdn.microsoft.com/en-us/library/ee240835.aspx

    (more…)

  • Free Download Microsoft 70-462 VCE Test Engine Full Version Now (11-20)

    QUESTION 11
    You administer a Microsoft SQL Server 2012 database. You provide temporary securityadmin access to User1 to the database server. You need to know if User1 adds logins to securityadmin. Which server-level audit action group should you use?

    A.    SERVER_STATE_CHANGE_GROUP
    B.    SERVER_PRINCIPAL_IMPERSONATION_GROUP
    C.    SUCCESSFUL_LOGIN_GROUP
    D.    SERVER_ROLE_MEMBER_CHANGE_GROUP

    Answer: D
    Explanation:
    http://technet.microsoft.com/en-us/library/cc280663.aspx
    SERVER_STATE_CHANGE_GROUP
    This event is raised when the SQL Server service state is modified. Equivalent to the Audit Server Starts and Stops Event Class.
    SERVER_PRINCIPAL_IMPERSONATION_GROUP
    This event is raised when there is an impersonation within server scope, such as EXECUTE AS <login>.
    Equivalent to the Audit Server Principal Impersonation Event Class.
    SUCCESSFUL_LOGIN_GROUP Indicates that a principal has successfully logged in to SQL Server. Events in this class are raised by new connections or by connections that are reused from a connection pool. Equivalent to the Audit Login Event Class.
    SERVER_ROLE_MEMBER_CHANGE_GROUP
    This event is raised whenever a login is added or removed from a fixed server role. This event is raised for the sp_addsrvrolemember and sp_dropsrvrolemember stored procedures. Equivalent to the Audit Add Login to Server Role Event Class.

    (more…)

  • Free Download Microsoft 70-462 VCE Test Engine Full Version Now (1-10)

    QUESTION 1
    You administer a Microsoft SQL Server 2012 database. The database has a table named Customers owned by UserA and another table named Orders owned by UserB.
    You also have a stored procedure named GetCustomerOrderInfo owned by UserB. GetCustomerOrderInfo selects data from both tables.
    You create a new user named UserC.
    You need to ensure that UserC can call the GetCustomerOrderInfo stored procedure.
    You also need to assign only the minimum required permissions to UserC.
    Which permission or permissions should you assign to UserC? Choose all that apply.

    A.    The Select permission on Customers
    B.    The Execute permission on GetCustomerOrderInfo
    C.    The Take Ownership permission on Customers
    D.    The Control permission on GetCustomerOrderInfo
    E.    The Take Ownership permission on Orders
    F.    The Select permission on Orders

    Answer: AB
    Explanation:
    The question seems to be missing something. Or the original answer is incorrect. I’ve changed it to what I believe to be the correct answer. The original answer included "The Select permission on Orders.", but due to ownership chaining, you would only need to give Execute permissions to UserC to access the Orders table since UserB is the owner.
    (BF) – need to test this
    Reference:
    http://msdn.microsoft.com/en-us/library/ms188676.aspx
    http://stackoverflow.com/questions/2212044/sql-server-how-to-permission-schemas
    http://sqlservercentral.com/blogs/steve_jones/2012/03/14/ownership-chains-in-sql-server

    (more…)

  • 2014 Latest 100% Pass Guaranteed Microsoft 70-511 Practice Tests (151-160)

    QUESTION 151
    You use Microsoft .NET Framework 4 to create a Windows Forms application. You have a dataset as shown in the following exhibit.
    image

    You plan to add a DataGridView to display the dataset. You need to ensure that the DataGridView meets the following requirements:
    – Shows Order Details for the selected order.
    – Shows only Order Details for items that have UnitPrice greater than 20.
    – Sorts Products by ProductName
    Which code segment should you use?

    A.    ordersBindingSource.DataSource = productsBindingSource ordersBindingSource.DataMember =
    "FK_Order_Details_Products" productsBindingSource.Filter = "UnitPrice > 20" productsBindingSource.
    Sort = "ProductName"
    B.    productsDataGridView.DataSource = ordersBindingSource productsBindingSource.Filter = "UnitPrice > 20"
    productsBindingSource.Sort = "ProductName"
    C.    order_DetailsBindingSource.DataSource = ordersBindingSource order_DetailsBindingSource.DataMember
    = "FK_Order_Details_Orders" order_DetailsBindingSource.Filter = "UnitPrice > 20" productsBindingSource.
    Sort = "ProductName"
    D.    order_DetailsDataGridView.DataSource = ordersBindingSource order_DetailsBindingSource.Filter "UnitPrice:>
    20" productsBindingSource.Sort = "ProductName"

    Answer: C

    (more…)

  • Pages:  1 2 3 4 5
Posts navigation