Free Microsoft 070-462 Exam Dumps Questions & Answers

You administer a Microsoft Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory.
Users need to be able to SELECT from all tables in the database and execute the stored procedure.
You need to grant only the necessary permissions.
What should you do?

• A.Create a new database role. Grant EXECUTE permission on p_AddInventory to the new role. Add all users to the role. Add all users to the db_datareader role.
• B.Create a new database role. Grant EXECUTE permission on p_AddInventory to the new role. Grant VIEW DEFINITION to the role. Add all users to the role.
• C.Add all users to the db_datawriter role. Add all users to the db_datareader role.
• D.Grant EXECUTE permission on p_AddInventory to all users. Grant VIEW DEFINITION to all users.

Note: This question is part of a series of questions that use the same set of answers choices. An answer choice may be correct for more than one question in the series.
You administer a Microsoft SQL Server 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:

One of the hard disk drives that stores the reporting database fails at 23:32 hours.
You need to ensure that the reporting database is restored. You also need to ensure that data loss is minimal.
What should you do?

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

You are developing a SQL Server Integration Services (SSIS) package.
You need to design a package to change a variable value during package execution by using the least amount of development effort.
What should you use?

• A.Term Extraction transformation
• B.Expression task
• C.Script task
• D.Execute SQL task
• E.Execute Process task

Your database contains a table named Purchases. The table includes a DATETIME column named PurchaseTime that stores the date and time each purchase is made. There is a non-clustered index on the PurchaseTime column. The business team wants a report that displays the total number of purchases made on the current day. You need to write a query that will return the correct results in the most efficient manner.
Which Transact-SQL query should you use?

• A.SELECT COUNT(*)FROM PurchasesWHERE PurchaseTime = GETDATE()
• B.SELECT COUNT(*)FROM PurchasesWHERE PurchaseTime = CONVERT(DATE, GETDATE())
• C.SELECT COUNT(*)FROM PurchasesWHERE CONVERT(VARCHAR, PurchaseTime, 112) = CONVERT(VARCHAR, GETDATE(), 112)
• D.SELECT COUNT(*)FROM PurchasesWHERE PurchaseTime >= CONVERT(DATE,
  GETDATE())AND PurchaseTime < DATEADD(DAY, 1, CONVERT(DATE, GETDATE()))

You administer a Microsoft SQL Server server that has SQL Server Integration Services (SSIS) installed.
You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables.
You need to configure the SQL Server environment to support these packages.
What should you do?

• A.Create SSIS configuration files for the packages.
• B.Install Data Quality Services.
• C.Install Master Data services.
• D.Create an Integration Services catalog.