How To Do Etl Testing Manually Open DvdQuality Center Certification Questions ~ Software Testing Quality Center Certification Questions. What web client can be used with Quality Center 9. A. Netscape. B. Safari. C. Firefox. D. Internet Explorer. Answer: D2 Which term describes the main function of Quality Center? A. test cases. B. C. load test. D. defects. Answer: B3 What database can be used with Quality Center 9. Select two. A. Access. B. Sybase. C. Microsoft SQL Server. D. Paradox. E. Oracle. Answer: C, E4 What HP functional testing tools integrate with Quality Center? Select two.)A. HP Open. Test automation - How it was few years ago and where is it heading now. Do we need dedicated automation experts to do the test automation or the normal testers can do. An open source extensible workflow engine written in C# with a cross platform manager app that works on Windows, macOS, Linux and Android.; Author: Akram El Assas. Dmitry, How do you automatically convert a load runner generated load analysis report to word or plain document via command line instead of manually using the load. ![]() View. B. HP Win. Runner. C. HP Quick. Test Professional. D. HP Load. Runner. E. HP Change Control Management. Answer: B, C5 Which component provides an executive- level view of the entire qualityprocess? A. Quality Center Foundation. B. Business Process Insight. C. Service Test Component. D. Quality Center Dashboard. Answer: D6 When designing test steps it is important to ensure that all aspects of theapplication are tested. When writing test steps, what are two things that should be done to ensure clearand accurate steps? Select two.)A. specify all actual results. B. use parameters in the step names. C. specify pass and fail conditions for the step. D. use the numbering system for the step names. E. use consistent terminology throughout the test. Answer: C, E7 Where can you link tests to requirements? A. from the Test Lab module. B. from the Requirements module. C. on the test details page (Test Plan)D. Test Plan)Answer: B8 When a called test has parameters, when can you assign values to theparameters? A. values are assigned from within the calling test. B. values must be assigned when the test is executed. C. values are assigned during test design or execution. D. values must be assigned when the test is called, during test design. Answer: C9 What are the steps, in the correct order, to convert a requirement to a test? A. make changes to the automatic conversion, select an automatic method. B. select convert to test, select the destination path, convert to automated test. C. select an automatic method, make changes to the automatic conversion, select the destination subject path. D. select the destination subject path, select an automatic method, make changes to the automatic conversion. Answer: C1. 0 How is a test configured as a template test? A. The test type chosen must be MANUAL- TEMPLATEB. The first step in the test must be named template test. C. Right- click on the test name and choose Template Test. D. During test planning, mark the checkbox, under details, labeled template Test. Answer: C1. 1 Click the Exhibit button. What does the icon in the exhibit indicate in the Test Plan module, under the Test Script tab? A. there is a test script. B. there is not a test script. C. there is a manual test case. D. the test script has changed. Answer: A1. 2 While designing the test plan tree, you accidentally delete a folder thatcontained some tests that you need. Can you recover the tests? A. no, once a test is deleted, it is gone. B. yes, the tests can be recovered from the Subject folder. C. yes, the test can be recovered from the Unattached folder. D. no, only Project Managers have permission to recover deleted tests. Answer: C1. 3 When you define tests inside of Quality Center, it is important that the testsare accurate and traceable. What are two other key pointers when defining tests? Select two. A. simple. B. consistent. C. D. convertible. E. F. appropriate. Answer: B, F1. What test types can be created in Quality Center? Select three. A. batch- test. B. vugen- test. C. D. system- test. E. F. wr- automated test. Answer: C, D, F1. In order to reuse a test across other tests, must the reused test be a templatetest? A. yes, only template tests are reusable. B. no, the test must be a VAPI test to be reusable. C. yes, template tests are reusable automated tests. D. no, tests do not need to be template tests to be reused. Answer: D1. 6 What does a live analysis graph illustrate in a visual overview? A. all the tests in the Test Plan. B. all the cycles or releases the test is linked to. C. all the requirements linked to the specified test. D. all the tests in a specified folder in the Test Plan. Answer: D1. 7 How can you create a test plan tree? A. convert releases to tests. B. define test folders and tests manually. C. save automated tests in Quality Center. D. define test names for each test needed. Answer: B1. 8 Can you change the values of a called test's parameters? A. no, values are assigned at run time. B. yes, if the called test is a template test. C. no, you must delete the called test and call it again. D. yes, right- click and choose Called Test Parameters. Answer: D1. 9 When you generate an Excel report, why is it an advantage to useparameters? A. enables the report to be saved. B. enables the user to name the report. C. enables the report to be used across projects. D. enables the report to be used for different purposes. Answer: D2. 0 Using the Excel Macro, what type of data can be imported into Quality. Center? (Select three.)A. B. test set data. C. test plan data. D. releases data. E. test Instance data. F. requirements data. Answer: A, C, F2. Once the Word macro is installed on your computer, what Quality Centertoolbars will Word display? A. Test Plan, Requirements and Export. B. Requirements, Defects and Common. C. Test Plan, Requirements and Defects. D. Test Plan, Requirements and Common. Answer: D2. 2 What graph types are available in each of the Quality Center modules? A. age and summary. B. trend and progress. C. summary and progress. D. requirements, coverage and age. Answer: C2. 3 When a predefined report is saved, what is the file extension? A. txt. B. xls. C. D. doc. Answer: C2. Which modules in Quality Center provide predefined graph templates? A. Requirements, Test Lab and Defects. B. Releases, Test Plan, Test Lab and Defects. C. Requirements, Test Plan, Test Lab and Defects. D. Releases, Requirements, Test Plan and Defects. Answer: C2. 5 How is data defined for use in an Excel report? A. with an SQL query. B. with an XML query. C. with ETL data extraction. D. with a Web. Data. Scraper. Answer: A2. On the General page of the Excel Report Generator window, what name isdisplayed, by default, in the designer field? A. the project manager. B. the site administrator. C. the user currently logged in. D. the user who created the report. Answer: D2. 7 Which menu allows you to generate a predefined report? A. Help. B. Tools. C. Analysis. D. Favorites. Answer: C2. 8 What elements can be linked directly to a requirement in the releasesmodule? A. a cycle. B. release tree. C. cycle details. D. a cycle progressa cycle? Answer: A2. 9 Which module, in Quality Center, starts the testing process? A. Defects. B. Releases. C. Dashboard. D. Requirements. Answer: B3. 0 What details about a cycle can you define in the details tab? Select two.)A. name. B. end date. C. attachments. D. release version. E. linked test sets. Answer: A, B3. 1 What constitutes a release folder? A. cycles of the release. B. test plan for the release. C. releases of the application. D. requirements for the release. Answer: C3. 2 Why do you create a release tree? A. to define the framework of releases. B. to define the workflow for the project. C. to define the requirements hierarchy. D. to define the test plan for the release. Answer: A3. 3 How many buttons are available to create a Release Tree? A. two. B. three. C. four. D. five. Answer: B3. 4 What types of attachments can be added to a cycle? Select three.)A. snapshot. B. test plans. C. D. release versions. E. system properties. F. linked requirements. Answer: A, C, E3. Which module allows you to view coverage by cycle? A. Cycle. B. Releases. C. Test Plan. D. Requirements. Answer: D3. 6 What is the function of the New Release button? A. creates a release tree. B. creates a cycle within a release. C. creates a release within a release folder. D. creates a new Release folder in the release tree. Answer: C3. 7 What is the foundation of the Releases module? A. the release tree. B. the cycle versions. C. the release cycles. D. the release folders. Answer: A3. 8 What is an example of an indicator column in the Defect module? A. status. B. priority. C. attachments. D. Answer: C3. 9 Where can you find an audit trail of the changes made to a defect? A. audit tab in the Defect module. B. status column in the defect grid. C. history tab in the Defect module. D. summary column in the defect grid. Answer: C4. 0 How can you save a filter that you set in the Defect module? A. choose Defects> Save. B. click the Favorites button. SQL Server SSIS Pivot Transformation. In this post I will be covering the Pivot Transformation. Due to the lack of a GUI or wizard for this component, it’s difficult to configure properly and painful to use, so I will try to walk through it as thoroughly as possible. I found the MSDN documentation on this component a bit confusing as well, so hopefully this will prove to be clearer. The sample package can be found here for 2. What does the Pivot Transformation do? This bit is fairly straightforward – it takes row values and converts them to columns, moving – but not aggregating – a value as it does so. So if your data looked like this: Fig 1: Pre Pivot Data. Pivoting on “Food Type” using “Cost” as a value would turn it into this: Fig 2: Post Pivot Data. How to configure the Pivot Transformation. In the sample package Data Flow 1 I start with a query which delivers Line Totals and Order Quantities summarised by Product and Order Year. What I want to do is Pivot so I have Order Year on the rows, the values from Product Category as the Columns and the sum of Line Totals as the Value, as laid out below: Fig 3: The Desired Pivot Results. Step 1: Configure the Inputs. The first step is to open the Pivot Transformation and on the Input Columns tab select the columns that are going to be used in the Pivot. Once that is done, switch to the Input and Output Properties tab. Here we are going to set how each column is used in the Pivot operation. This is done by setting the Pivot. Usage property of the Input Columns. This can be found by expanding Pivot Default Input > Input Columns and selecting the relevant Input Column. Down at the bottom of the list under the Custom header is the property Pivot. Usage. This can be set to one of four values: 0 – the column is passed through unaffected. Set Key)2 – the columnvalues become the column names of the pivot (aka the Pivot Column)3 – the column values that are pivoted in the pivot. So, in my example, I set Order. Year to 1, Product to 2 and Line Totals to 3. Fig 4: Configuring the Pivot Transformation Inputs. Now something you have to configure upstream from this is that whatever column will be the rows of the pivot (Pivot. Key. Usage = 1) needs to be sorted for the component to work properly. The Pivot component iteslf doesn’t force this (as it does in a Merge Join) so you need to go back and make sure that your column is sorted by the time it hits the pivot. Setting the Is. Sorted and Sort. Key. Position properties of the Set Key column upstream will make no difference as the Pivot Transformation won’t actually pay any attention to these settings, but it may cause unexpected results if the data itself isn’t sorted. You can see how this affects the output by running Data Flow 1a, which is the same as Data Flow 1 but not sorted properly. Step 2: Configure the Outputs. Despite everything you’ve done so far, this component will have exactly zero outputs – each has to be manually defined. So you will need an output for your Rows (In my example, Order. Year) and an output for each of your Pivoted column’s values that you want to output. So in my example I will need to create an output for each Product Category that is in the source data – you cannot ignore a value as the component will return an error. For example, if I forgot to add a column for Components, I would get the error “The pivot key value “Components” is not valid” when I tried to execute. To create an output, on the Inputs and Outputs tab expand the Pivot Default Output > Output. Columns and start clicking the Add Column button until you have enough columns. Then for each column you need to set the following properties: Name – the name for the output column – so if you were pivoting a value of Bike, you could rename it to Bicycle in the output. Pivot. Key. Value – the value in the pivoted column that will go into this output. Source. Column – the Lineage ID of the column that is to be used in the pivot. What this means is you need to go back to your input columns, and get the value of the Lineage. ID property of the column that you set the Pivot. Usage of to 3 for pivoted columns, and the Lineage. ID of the Column you set to Pivot. Usage of 1 for the Row Column. Fig 5: Configuring the Pivot Transformation Outputs. Having fun yet? Unlikely, but fortunately you are done. Multiple Pivots and the T- SQL Alternative. In the sample package Data Flow 2, I demonstrate a configuration of the Pivot Transformation that actually pivots two data values. This is achieved by adding a duplicate set of columns for the Pivot Column to receive the pivoted values in, and can be achieved mostly by duplicating the actions in Step 2 to create a new set of Pivot Columns. I also demonstrate the Pivot T- SQL command in Data Flow 3 – this generates the same output as in Data Flow 1 but the aggregation and pivoting is done in a single operation with none of the awkward configuration required by the Pivot Transformation in SSIS. I won’t be going into the syntax for these queries here but lkinks to the MSDN documentation are at the end of this post. Where to use the Pivot Transformation? Because of the pain involved in configuring it, I would suggest you only use it when you absolutely have to and can’t push the operation back to the source. This is not least because the pivot – unlike Excel Pivot Tables or a T- SQL pivot – cannot aggregate, it needs aggregation first on the pivoted column. In my example, if I didn’t have an aggregate operation in the query, I would get the error “Duplicate pivot key value “Bikes”” as it tried to pivot another row which had a Product Category of “Bike”. The T- SQL Pivot query in SQL Server is far more powerful with its variety of aggregation options – even though it will initially be a bit awkward to write those queries to a non- expert. Additionally using T- SQL will allow you to lock down the number of columns – if you get a new value in the Pivot Column it won’t kill your package. All in all the Pivot Transformation is badly implemented from a UI perspective, and weak from a data processing viewpoint due to it’s lack of aggregation capability. MSDN Documentation for the Pivot Transformation can be found here for 2. MSDN Documentation for the Pivot T- SQL command can be found here for 2. If you’re still struggling, try looking at these other posts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
October 2017
Categories |