Related InterviewSolutions

• In order to use the Analyze in Excel feature, you must have ___________ installed on the system.(a) SSDT(b) SSMS(c) SSMA(d) None of the mentionedI have been asked this question in an interview.This intriguing question originated from Analyzing Data With Excel topic in division Business Intelligence of SQL Server
• Scenario Analysis tool allows you to model _______ types of scenarios.(a) 2(b) 3(c) 4(d) 5I have been asked this question during an interview.This intriguing question comes from Analyzing Data With Excel in section Business Intelligence of SQL Server
• Fill From Example tool also produces a patterns report similar to ___________(a) Analyze Key Influencers(b) Detect Categories(c) Fill From Example(d) None of the mentionedI have been asked this question in an international level competition.This key question is from Analyzing Data With Excel in chapter Business Intelligence of SQL Server
• Point out the wrong statement.(a) The Detect Categories tool detects the rows in the data table that contain similar characteristics and groups them into categories(b) The tool employs SQL Server Data Mining to detect patterns in the sample you provide and apply those to the remaining missing values(c) The Detect categories tool predicts future values based on trends in existing time series data(d) All of the mentionedThe question was posed to me in a national level competition.Question is taken from Analyzing Data With Excel topic in portion Business Intelligence of SQL Server
• Which of the following tool analyzes and highlights data rows that do not appear to match the general patterns found in the rest of the table?(a) Exceptions(b) Highlight(c) Scenario Analysis(d) Highlight ExceptionsThe question was asked in semester exam.Query is from Analyzing Data With Excel topic in section Business Intelligence of SQL Server
• ___________analyzes the patterns in data that have the strongest influence on a certain outcome.(a) Analyze Key Influencers(b) Detect Categories(c) Fill From Example(d) None of the mentionedThis question was posed to me in unit test.This question is from Analyzing Data With Excel topic in division Business Intelligence of SQL Server
• _____________ allows you to analyze your spreadsheet data in powerful ways.(a) Data Mining Templates for Visio(b) Table Analysis Tools for Excel(c) Data Mining Client for Excel(d) All of the mentionedI got this question in unit test.This interesting question is from Analyzing Data With Excel in portion Business Intelligence of SQL Server
• The functionality that SQL Server Agent provides to Reporting Services can be replaced with custom code that uses the _________ method to add schedule events to the queue.(a) FireEvent(b) FireEventdata(c) Eventdata(d) None of the mentionedThe question was posed to me in an internship interview.The doubt is from Reporting Services topic in portion Business Intelligence of SQL Server
• Point out the correct statement.(a) You cannot create and save connections to re-use data sources, repeat experiments, or re-train models(b) The add-ins are built on the capabilities of the .NET Framework 2.0 and the .NET programmability support provided by Office 2007(c) The SQL Server 2005 Data Mining Add-ins for Office 2007 allow you to uncover hidden patterns and relationships in your data(d) None of the mentionedI had been asked this question at a job interview.This interesting question is from Analyzing Data With Excel in portion Business Intelligence of SQL Server
• The Schedule and Delivery Processing feature must be enabled through the ____________ property.(a) ScheduleEventsDeliveryEnabled(b) ScheduleEventsAndReportDeliveryEnabled(c) ScheduleEventsAndReportDelivery(d) All of the mentionedI have been asked this question during an interview for a job.I'd like to ask this question from Reporting Services in chapter Business Intelligence of SQL Server