Find Interview Questions for Ontario teachers' pension plan

Right Answer:
The different types of market research are:

1. Primary Research
- Surveys
- Interviews
- Focus Groups
- Observations

2. Secondary Research
- Market Reports
- Academic Journals
- Industry Publications
- Online Databases

3. Qualitative Research
- In-depth Interviews
- Focus Groups
- Ethnographic Studies

4. Quantitative Research
- Surveys with numerical data
- Experiments
- Statistical Analysis

5. Descriptive Research
6. Exploratory Research
7. Causal Research

Right Answer:
To conduct a market survey, follow these steps:

1. Define the objective: Determine what information you need.
2. Identify the target audience: Decide who you want to survey.
3. Choose the survey method: Select between online, phone, face-to-face, or mail surveys.
4. Design the questionnaire: Create clear and concise questions.
5. Collect data: Distribute the survey to your target audience.
6. Analyze the results: Review the responses and extract insights.
7. Report findings: Summarize the results and present them to stakeholders.

Right Answer:
Focus groups involve a small group of people discussing a topic guided by a moderator, while interviews are one-on-one conversations between an interviewer and a participant.

Right Answer:
To test the module that loads data from a text file into the SQL Server database, follow these steps:

1. **Prepare Test Data**: Create a variety of text files with different data scenarios, including valid, invalid, and edge cases.

2. **Set Up Database**: Ensure the database is in a known state before the test (e.g., empty or with specific pre-loaded data).

3. **Execute the Load Process**: Run the module to load the data from the text file into the database.

4. **Verify Data Integrity**:
- Check that the correct number of records were inserted into each of the 10 tables.
- Validate that the data in the tables matches the data in the text file, including data types and formats.

5. **Check Referential Integrity**: Ensure that any foreign key relationships are maintained correctly across the tables.

6. **Test Error Handling**: Use invalid data to verify that the module handles errors gracefully and logs them appropriately.

7

Right Answer:
A QA engineer is responsible for designing test plans, creating and executing test cases, identifying and documenting defects, ensuring software quality, collaborating with development teams, and verifying that products meet specified requirements before release.

Right Answer:
In SAS, I use features like the DATA step with conditional statements (IF-THEN/ELSE), the OPTIONS statement for error handling (e.g., OPTIONS OBS=0), the PUTLOG statement for logging messages, and PROC SQL with the VALIDATE option for data validation. Additionally, I utilize the SAS macro facility for creating reusable error-checking code and PROC CONTENTS to validate dataset structures.

Right Answer:
a. Different from pattern - `NOT LIKE`
b. Match pattern - `LIKE`
c. Both and - `AND`
d. Except - `MINUS`