Question No : 1
An organization recently acquired a competitor A business analyst needs to merge me custom databases with 20 years of customer and order transactions. The data must be integrated into the existing app to show the past two years of data Performance degradation must be minimized
What should the business analyst do to meet this requirement?

• A.• Add the new Customers and Orders tables and associate the new tables to me existing data model • Filter the data from the Customers and Orders table to bring only data created within the past two years
• B.• Add the new Customers and Orders tables and concatenate the new tables to the existing data model • Filter the data from the Orders table to bring only data created within the past two years
• C.• Add the new Customers and Orders tables and associate the new tables to the existing data model • Filter the data from the Orders table to bring only data created within the past two years
• D.• Add the new Customers and Orders tables and concatenate the new tables to the existing data model • Filter the data from the Customers and Orders table to bring only data created within the past two years

Show Answers

Answer:

Question No : 2
To improve efficiencies a hospital mustanalyze how often a surgery is started late by operating room and surgeon.
The business analyst must consider several factors
• Dates of each surgery
• Number of minutes the start of the surgery is delayed
• Operating room
• Surgeon name
Which visualization should the business analyst use to meet these requirements?

• A.A combo chart that shows total minutes of delayed starts by operating room and surgeon
• B.A bar chart with total minutes of delayed starts and a drill-down from operating room to surgeon
• C.A scatter plot with delayed start minutes per day operating room and surgeon
• D.A line chart with total minutes of delayed starts and a drill-down from operating room to surgeon

Show Answers

Answer:

Question No : 3
Refer to the exhibit.






A business analyst must add a list of interns to the current sates app. The app contains an existing employees table When the business analyst profiles the data the association vow displays possible associations as shown.
Which action should the business analyst take to meet the requirements?

• A.Create a concatenated key to associate the Employees and internEmp tables
• B.Force an association between the InternEmp and the Orders tables
• C.Create an association between the EmpID and EmployeelD fields
• D.Concatenate the InternEmp table to the Employees tables within data manager

Show Answers

Answer:

Question No : 4
A business analyst is developing an app that contains a data model with fields Country. City. Sales ProductName and ProductCategory. The global sales manager wants to add new visualizations to this app
The business analyst must include the following
• Ability to dynamically change the number of countries and cities
• Display a maximum of 10 countries
• Display a maximum of 5 cities per country
Which steps should the business analyst take?

• A.1 Create two variables vCountry and vCity 2 Add a slider for vCountry and vCity 3 Apply the vanable to each virtualization
• B.1 Add an input field for vCountry and vCity 2 Sat the dimension limitation to the required maximum values 5 and 10 3 Apply the variable to each visualization 4 Add a bookmark Country and City
• C.1Add an input field for vCountry and vCity 2 Set the dimension limitation to the required maximum values 5 and 10 3 Apply the variable to each visualization
• D.1 Create two variables vCountry and vCrty 2 Add a slider for vCountry and vCity 3 Apply the variable to each virtualization 4 Set a sheet action that limits the data displayed

Show Answers

Answer:

Question No : 5
A business analyst is creating an app for technicians. The app must meet several requirements
• Visualization labels must change according to the selected tame period
• A button to toggle between Month and Year to Date (YTD)
• Two fields combine to create one dimension that is used m several visualizations.
What three options are needed to meet the requirements? (Select three.)

• A.Master items
• B.Variables
• C.Calculated fields
• D.Alternate states
• E.Set analysis

Show Answers

Answer:

Question No : 6
A sales manager needs to visualize the company's sales. The sales manager needs to understand how sates and profitability are related over time. The visualization will be used in a printed annual report.
The business analyst has access to the following data:
• Order Dates
• Order ID
• Total Safes by Order
• Net profit margin%
• Cost of Goods Sow (COGS)
Which visualization should the business analyst use?

• A.Scatter Plot
• B.Combo Chart
• C.Distribution Plot
• D.Line Chart

Show Answers

Answer: