تست چهارم کلاسی CBDA

An analyst has just completed building a data model that shows the table structures including table names, table relationships with primary and foreign keys and column names with respective data types. What type of data model has the analyst just built?

A job satisfaction survey is being developed. Half of the employees will be asked the question “Do you enjoy working in your workplace?” The other half will be asked “Do you like the current work benefits?”. The business analyst raises concern over the survey. What is concerning to the business analyst?

A government agency is conducting a study on the performance of 12th grade students’ in mathematics across the country. In particular, they want to understand if there is a relationship between intelligence and scores, as well as the difference in performance between various locations. Which combination of inferential statistics procedures should be used?

A colleague proposes measuring job satisfaction by asking the question “What is your salary?”. What is the concerning factor about this question?

While creating a dataset for analysis, the analyst reviews the data collected and finds a large percentage of records are missing values. Which activity would the analyst perform in order to use this dataset?

The analytics team has completed analyzing a dataset and unfortunately the data didn’t deliver the kinds of insights that the team was hoping for. After much contemplation, they decide to:

An analyst is using a Data Flow Diagram (DFD) to depict the flow of data across a data security company. Which of the following is true about DFDs?

The analytics team has been asked to assess sales data from their company’s website with the hopes of providing insights to help increase online sales. It’s the first time the team is looking at this specific data and they are concerned about the quality of data that has been captured. They decide to use the following approach as the next step:

A Data Dictionary is being developed for an employee database. When reviewing the data dictionary, the analyst recommends adding another primitive data element. Which element would be suggested?

An analyst is looking at a particular dataset that includes the scores across all 8th grade students, across three schools. The analyst is trying to determine which type of statistics average to use to best represent the results. On looking through the dataset, the analyst has identified a few extreme outliers. As a result, the analyst was led to use the following type of average:

A database analyst is modelling a database for a large toy manufacturer. Which statement describes a logical database model?

Which attributes from the Order entity will need to be normalized to avoid redundancies?
. Orderld
. OrderDate
. Itemld
. ItemName
. Quantity
. ItemPrice

An analytics team is interested in reviewing the results of a public opinion poll that is going to be conducted at the end of the month. One of the factors the team is interested in, is ensuring the result set is statistically significant. Why would this factor be important to the team?

An analytics team employed at a leading credit card company is utilizing data analytics to identify unusual credit card purchases. They have created the following visual. How many extreme outliers exists in this dataset?

What is the relationship between a Customer entity and an Order entity, where a customer entry will be present in the Customer entity only if they have made an order?

There were 7 students enrolled in the Introduction to Artificial Intelligence course. These were the student’s scores from the final exam: 64, 70, 80, 80, 90, 98, 100 What is the mean and mode for the outlined scores?

After analyzing sales data, the analytics team finds that the older the customer, the more expensive the neckties purchased. The team felt this was a breakthrough insight but on closer analysis realized that other factors could account for this relationship. This is a clear indication that:

Based on the financial analysis that’s been completed by the analytics team, the business analysis professional reminds the team that the most financially feasible option is the one with the:

A movie production company wants to use analytics to decide which customers would choose to watch or not watch a particular movie after seeing a promotional teaser. The business analysis professional suggests they could make that prediction by identifying characteristics of the new movie and determining if the customer has watched other movies with similar characteristics. This is an example of using the following technique:

A job satisfaction study is being considered. Half of the employees of the company will be interviewed by senior managers and the other half of the employees will be interviewed by an
external market research company, using the same set of questions. Which of the following might be a concern for using this approach to collect study data?

An insurance company would like to develop a range of insurance products for different types of customers. The analytics team is asked to conduct some research and share their insights with senior management. Which technique would be useful to divide the customer base into groups?

A pharmaceutical company is conducting research to determine whether a new medicine in development is more successful in reducing the pain associated with rheumatoid arthritis then their current drug in the market. A group of volunteers are selected for the research. One set of participants is provided the existing drug while a second set of participants is given the new drug. Which technique is being applied?

To ensure their recommendation can be acted upon, the business analysis professional on the analytics team helps the team complete financial analysis to support their recommendation. As part of the financial analysis that’s completed, the cost-benefit analysis shows positive net benefits starting in the 2nd year. The team feels this is sufficient to proceed with their strong endorsement of the recommendation. The business analysis professional:

The CustomerOrder entity will include information on all customer orders. Applying database normalization rules, which set of attributes will need to be normalized to avoid redundancies?
• Customerld
• CustomerPhone
• Orderld
• OrderDate
• ProductName
• ProductQuantity
• OrderTotal

When reviewing the results of their analysis, the team is determining if the data supports their hypothesis and can be presented to decision makers. They are reviewing measures of variation, sample size and statistical significance. They realize that the p-value of 0.02 is lower than the initial target. This clearly indicates the team can:

Results of the data analysis have been analyzed and the team was confident with the results but also quite surprised the outcome was not what was expected. In pondering the value of what can be gleaned from the data, the team has no feasible solution to put forth to address the business need. A logical next step would be to:

A data scientist is analyzing a dataset to determine if there is a strong relationship between two variables. A measure of covariance is done. Which of the following graphs indicate Zero Covariance between variables?

A data dictionary is being developed for a dataset describing a company’s customer base. Within the data dictionary, which of the following represents a composite data element?

What is the relationship between a Customer entity and an Order entity, where a customer entry will be present in the Customer entity regardless of whether an order was made?

A future state data model is created to depict how information will be structured in a proposed solution but the analyst is also interested in modeling how and when data is transformed throughout various processes across the organization. In which model would the analyst find this information?

The results for a certification exam were revealed in percentage and percentile. How would you infer the results for an attendee at: 75%, 90th percentile?

An analyst is interested in determining whether their company is charging the right prices for their products. Before creating a research question to frame their data analysis, they review a research study provided by the sales department and review several competitor websites. Which statement is true about document analysis?

A large retail chain has asked their analytics team to complete a study on their customers’ purchasing patterns. The analyst assigned to the study has decided to draw further insight by grouping customers based on their purchasing habits. This clustering approach is an example of:

A clinical research organization is using predictive analytics to improve patient safety and decrease costs on its clinical trials. To ensure that a standard set of tools/techniques is identified and best practices adhered to, teams are required to create scenarios to generate appropriate data for initial analysis. This practice is required because it is almost certain that data will be difficult to come by for most research. Which concern would lead the team to establish scenario development as a required technique?

An analyst is performing regression analysis and reviewing the results. They would like to rescale the variables in the model to more clearly reflect the relationship between the regression coefficients. Which technique could be used to rescale the variables?

An analyst is working through data on comparing performance scores in different schools across the state, for ranking purposes. Since there is a lot of data and some extreme outliers, the analyst is trying to determine which type of statistical average would best represent the results. Which of the following is a concern when relying too heavily on summary statistics during data analysis?

An analyst is doing a clinical study on the value of analyte among a large population of healthy people. The analyst is going to use a Gaussian Distribution to share the results. Which of the following represents a Gaussian Distribution? (IMAGE TAKEN)

There were 7 students enrolled in the Introduction to Artificial Intelligence course. The scores from the final exam were as follows: 64, 70. 80, 80, 90, 98, 100 What is the mean and median for the outlined scores?