Microsoft-Microsoft Dynamics AX 2012 Process Manufacturing Production and Logistics Set 7

A new data analytics application is being implemented in your organization. Users will run a process that compares result sets before and after executing complex data modifications. The data will always be queried by using the same conditions. Some tables updated by the process will not need to be compared. Your need to design a locking strategy for the process that meets the following requirements: Enables other processes or users to modify tables that are not being compared Prevent other processes from performing data manipulation language activity on the tables that are being compared What should the strategy include?

You are a database developer. You design a database solution by using SQL Server 2008. There's a query which is used very often. You notice that this query executes quite slow. This query often uses full-table scans while not indexes. Because of this, other queries that modify the table are to be blocked. On the underlying tables,the indexing strategy that the query uses can change. Now you have to design a solution which performs the following asks: removes full-table scans allows the query optimizer to select the appropriate index. So what should you do?

A database contains two tables named Tablel and Tablel_Details. Tablel_Details contains details about the items in Tablel. You need to ensure that when an item is removed from Tablel, all related items are removed from Tablel_Details. You must achieve this goal by using the minimum amount of Transact-SQL code. What should you do?

You are a database developer. You plan to design a database solution by using SQL Server 2008. You have a Web site supported by a database that has the full-text search component installed. You plan to create a table named Courses that will have the following structure. Users of the Web site will search for courses based on the CourseTitle field. You need to construct a full-text query that ensures the following compliances when a user launches the search for a course: Rows are returned when the exact search phrase is found. Rows are in order of how well they match with the search phrase. What should you specify in the full-text query?

You need to design a database solution that meets the following requirements: Supports different types of databases Provides reliable messaging between databases Provides data workload distribution across several databases Which SQL Server component should you use?

You plan to deploy a new application. The application will perform the following operations: Create a new database Back up the new database You need to configure a login to support the deployment of the new application. The solution must ensure that the application uses the most restrictive permissions possible. What should you do?

You plan to implement a Web-based application that will save XML data to a column in a table. You need to design a query that ensures that before saving the XML data to the table, the data contains valid elements. The solution must be developed by using the minimum amount of effort. What should you include in the query?

You are a database developer. You plan to create a database by using SQL Server 2008. The database has a table named Employees. The table contains records of employees and their managers. The table includes the EmployeelD and ManagerlD fields. The EmployeelD values are unique. The value in the ManagerlD field is the employee ID of the employee's manager. A Web site requires XML formatted output of all managers and employees to be displayed as a tree diagram. You need to produce the required output by querying the database without using system stored procedures. What should you do?

You have a table that contains an XML column named XMLData1. The column contains the following nodes: Title Description Author Weight NumPages You need to design a stored procedure that will return only the title and description in a tabular result set. The document must be developed by using minimum amount of effort. How should you extract the information?

You work in an International company named TAKEEEN. And you're in charge of the database of your company. You intend to use SQL Server 2008 to create a database solution. A database will contain 10 tables that are used to generate reports. The range of the data in the tables varies from 50,000 to 100,000 records. During a query execution that joins four tables, you discover the following problems: It takes a quite long time for the query to execute. The size of the tempdb database grows considerably. Now you have to analyze the execution plan to identify the most likely cause for the problems. So what should you do?