stion 41 yet While importing Data from a flat file into an Access Database file, you find that there is row which contains wered information about the data in the column such as 'Name', 'Work Package Number', "Start Date' etc. In order to ensure data quality, you would: ked out of O a. Do nothing. Access is smart enough to take care of this lag question O b. Transfer text file data into Excess file format and then import into Access O c. Delete the first row containing non-data information O d. Check the box "first row contains field names' Clear my choice022 Question 39 As project manger you are working with your data analyst. Which of the following is not a component of the Data Not yet Analysis Cycle? answered Marked out of O a. Data Acquisition 1.00 O b. Data Analysis I Flag question O c. Data Storage O d. Data Securitystion 40 A project has experienced significant delays due to equipment problems, staff attrition, and slow client reviews. yet The project is 40% complete and has used 60% of the available calendar time. What is the FIRST thing you should vered do? ked out of O a. Identify activities that have required more time than planned lag question O b. Re-baseline the schedule to reflect the new date O c. Document the lack of progress and associated issues to management O d. Analyze the critical path activities for potential to fast track or crash the schedule35 Activity A is worth $300, is 100% complete, and cost $350. Activity B is worth $100, is 95% complete and cost $85 so far. Activity C is worth $200, is 75% complete, and has cost $175 so far. The total budget is $1500. What is the ed schedule variance for the project? d out of O a. $-55.00 g question O b. $-65.00 O C. $-45.00 O d. $20.00 O Clear my choiceYou are working on a project, which is 25 million dollars in value, with a duration of 4 years. There are 375 employees working at the peak level on the project, whereas at the slack level only 36 employees are active. You need to enter data of workers in the system. Which one of the following will be your preferred instrument for this? of O a. Text File stion O b. Excel, with Validation rules O c. MS Word O d. MS Access Forms38 We have learned that in MS Access we can use query for many purposes. Which of the following can not be achieved by using query in access? ered ted out of O a. to export data to an excel file O b. for a simple question, lag question H O c. to perform calculations, O d. to combine data from different tables,ummer 2022 3 Which of the following is not correct about a Database Table? O a. It is an object which acts like a container to store data in a row and column format t of O b. Tables may contain master data or transaction data. c. In case of Master data, it is called 'Principle Data Table'; in case of transaction data, it is called 'Subsidiary estion Data Table' O d. A database table may be empty or full of data Clear my choiceQuestion 31 If project time and cost are not as important as the number of resources used each month, which of the following Not yet is the BEST course of action? answered Marked out of O a. Perform resource leveling 1.00 O b. Fast track the project Flag question O c. Perform a Monte Carlo analysis O d. Analyze the life-cycle costs Clear my choiceIn Access, which of the following statements about a Primary Key is false? a. Primary key is always a numeric field O b. Primary key is identical in characteristics to a column of data in related tables; O c. Primary key is a column of data O d. Primary key serves as the basis of connecting two or more tables Clear my choiceIn an excel sheet you write '1' in Cell 4. If you select the cell from the right-hand bottom corner and drag down, you get the following values in Cells C5 to C8 O a. 1,1, 1, 1 O b. 2, 3,4,5 O c. Error, Error, Error, Error O d. 2,2,2,228 In an excel sheet you write '1' in Cell C3 and 'A' in Cell 4. If you select both the cells together, hold these from the right-hand bottom corner, and drag down, you get the following values in Cells C5 to C8 d out of O a. 2,B,3.C O b. 2,A,3,A question O c. 1,A, 1,A O d. B.C,D,E Clear my choiceYou want to see the cost associated with your resources. It is not visible on your screen. You will: O a. You will use resource sheet view O b. You will use Cost Sheet View O c. You will use a customised view O d. Add "Cost" column from the drop-down list of 'Add Column'Activity A is worth $300, is 100% complete, and cost $350. Activity B is worth $100, is 95% complete and cost $85 so far. Activity C is worth $200, is 75% complete, and has cost $175 so far. The total budget is $1500. What is the cost performance index for this project? O a. 0.90 tion O b. 0.89 O c. Cannot be determined. O d. 0.79Activity A is worth $300, is 100% complete, and cost $350. Activity B is worth $100, is 95% complete and costs $85 so far. Activity C is worth $200, is 75% complete, and has cost $175 so far. The total budget is $1500. What is the estimate to complete this project? O a. $3075.39 O b. $1068.90 O C. $2000.00 O d. $1050.39You are about to take over a project from another project manager and find out that there are eleven stakeholders on the project. Task Z has an early start of day 15 and a late start of day 20, task Z is a difficult task. The Cost Performance Index (CPI) is 1.1 and the Schedule Performance Index (SPI) is 0.8. Based on this t of information, which of the following would you be the MOST concerned about? estion O a. Cost O b. Float O c. The number of available resources O d. Schedule Next