Which technologies should you recommend?
You need to recommend appropriate technologies for designing Web forms for entry and retrieval of news items.
Which technologies should you recommend? (Each correct answer presents a complete solution. Choose two.)
What should you do?
You are a database administrator for AIOTestKing.com. You manage a database named Invoicing. The Invoicing database is backed up with a full backup nightly and transaction log backups once every two hours from 08:00 to 17:00. You implement database snapshots for the Invoicing database. A database snapshot is created each day at 07:00.
At 09:30 today, a user inadvertently deleted all of the invoices that were entered into the CurrentInvoice table yesterday. None of these invoices had been changed today prior to the deletion. It is now 11:45 and many other changes have occurred in the database. You need to recover the lost rows with as few administrative steps as possible while minimizing data loss. What should you do?
Which expression should you use?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report contains financial data. An input parameter named TargetMfr is present in the report. When a value in the Machine_Mfr field matches the selected value in the input parameter, the color of the output in a column is red. Otherwise, the color of the output is green. You need to set the TextBox that contains the color property of the Machine_Mfr field to the appropriate expression. Which expression should you use?
Which approach should you recommend?
You need to design a solution for capturing an exception.
Which approach should you recommend?
What should you do?
You are a database administrator for AIOTestKing.com. The SQL 2005 Server computer has been in operation for more than one month. This past week, query performance problems have led you to investigate locking contention. The sys.dm_os_wait_stats dynamic management view (DMV) is showing a high value in the max_wait_time_ms column.
You need to find out if this value is a factor in the current performance problems. You also must minimize the impact on database users. What should you do?
Which three tasks should you perform?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report has three columns in a table. The columns are named MachineName, MachineMfr, and MachineModel. The report navigation options must allow users to click on a row from the MachineName column and drill through to another report, and then pass the contents of the MachineName column as a parameter named MachineName. You need to configure the report navigation options to satisfy the user requirements. Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)
Which two approaches could you recommend?
You are designing an ASP.NET Web application by using Microsoft Visual Studio 2010. The Web application uses dynamic HTML (DHTML).
You need to ensure that the application functions properly on multiple browser platforms without requiring the installation of a client-side component.
Which two approaches could you recommend? (Each correct answer presents a complete solution. Choose two.)
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. AIOTestKing A replicates with other SQL Server computers and manages multiserver automation jobs. It also exports data to staging databases for export to a data warehouse. After a few months without incident, AIOTestKing A fails to start after a reboot.
You review the security log, which returns the results that the Security Log Results exhibit shows.
You then review an individual audit entry, which the Individual Audit Entry exhibit shows.
The Default Domain Group Policy object (GPO) is configured with a Password Policy and Account Lockout Policy as shown in the following table.
You need to ensure that AIOTestKing A runs properly. What should you do?
What should you do?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report uses a dataset that is constructed from an SQL table named Employees. The table has an employeeID field and a managerID field. The managerID field in each row represents the employeeID field.
You execute the following Transact-SQL query to get the dataset from the report:
SELECT CONVERT(varchar(255), c.FirstName + ‘ ‘ + c.LastName) as Name, e.EmployeeID, e.ManagerID FROM HumanResources.Employee AS e JOIN Person.Contact AS c ON e.ContactID = c.ContactID You need to display the dataset as a hierarchical, organizational chart, as shown in the Exhibit. (Click the Exhibit button.)
What should you do?
Which event handler should you add?
You are implementing an ASP.NET page in an e-commerce application. Code in a btnAddToCart_Click event handler adds a product to the shopping cart.
The page should check the status of the shopping cart and always show a cart icon when one or more items are in the shopping cart. The page should hide the icon when the shopping cart has no items. You need to add an event handler to implement this requirement.
Which event handler should you add?