InterviewSolution

Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

51.	In Microsoft SQL Server 2005 Analysis Services (SSAS), a _________ is a language-specific representation of the name of a dimension.(a) Translation(b) Dimension translation(c) Dim translation(d) None of the mentionedI got this question during an interview for a job.I would like to ask this question from Analysis Services topic in section Business Intelligence of SQL Server
Answer» Right answer is (b) DIMENSION translation The best I can explain: Translations provide server SUPPORT for CLIENT APPLICATIONS that can support multiple languages.

52.	Security for stored procedures is set with the _________ property on a stored procedure.(a) PermissionSet(b) SetPermissionSet(c) Permission(d) None of the mentionedThe question was posed to me during an online interview.My question is taken from Analysis Services in section Business Intelligence of SQL Server
Answer» Right OPTION is (a) PermissionSet The best explanation: You can USE stored PROCEDURES to CALL external routines from MICROSOFT SQL Server 2005 Analysis Services(SSAS).

53.	Which of the following namespace discover set of assemblies?(a) System.Reflection(b) System.Refraction(c) Sys.Reflection(d) All of the mentionedThis question was posed to me in semester exam.Question is from Analysis Services topic in chapter Business Intelligence of SQL Server
Answer» Right answer is (a) System.Reflection For explanation I WOULD say: ANALYSIS Services does not EXPOSE APPLICATION domains directly.

54.	If the __________ setting is used, the execution context corresponds to the Windows login user account IUSER_servername on the server.(a) ImpersonateAnon(b) Anonymous(c) ImpersonateAnonymous(d) None of the mentionedThis question was posed to me in class test.This interesting question is from Analysis Services in division Business Intelligence of SQL Server
Answer» Right ANSWER is (c) ImpersonateAnonymous To elaborate: The DEFAULT setting, ImpersonateCurrentUser, runs an ASSEMBLY under the current USER’s network login ACCOUNT.

55.	Which of the following permission setting provides internal computation permission?(a) Unsafe(b) ExternalAccess(c) Safe(d) All of the mentionedThis question was posed to me in examination.I want to ask this question from Analysis Services in chapter Business Intelligence of SQL Server
Answer» Correct answer is (C) Safe For explanation I would say: This permission bucket does not ASSIGN PERMISSIONS to access any of the protected resources in the .NET FRAMEWORK.

56.	Point out the wrong statement.(a) The SSAS host-level policy is a combination of Analysis Services fixed policy for system assemblies and user-specified policy for user assemblies(b) Security for assemblies is based on the .NET Framework security model, which is a code-access security model(c) Calling a user-defined function in an assembly is performed just like calling an intrinsic function(d) All of the mentionedThis question was addressed to me by my school principal while I was bunking the class.My question comes from Analysis Services topic in section Business Intelligence of SQL Server
Answer» RIGHT option is (a) The SSAS host-level policy is a combination of ANALYSIS SERVICES fixed policy for system assemblies and user-specified policy for user assemblies For EXPLANATION I would SAY: The Analysis Services host-level policy is a combination of Analysis Services fixed policy for system assemblies and user-specified policy for user assemblies.

57.	_________ let you create external, user-defined functions using any common language runtime (CLR) language.(a) Aggregate(b) Assemblies(c) Synonym(d) All of the mentionedI had been asked this question in a national level competition.My question is from Analysis Services topic in portion Business Intelligence of SQL Server
Answer» CORRECT choice is (b) ASSEMBLIES To explain: Assemblies LET you extend the business functionality of MDX and DMX.

58.	Which of the following role is created as a separate object in an Analysis Services database, and applies only to the database in which that role is created?(a) Database(b) Membership(c) Client(d) ServerI got this question in an interview for job.The doubt is from Analysis Services in division Business Intelligence of SQL Server
Answer» CORRECT ANSWER is (a) Database Explanation: An Analysis Services database role DEFINES user access to objects and data in an Analysis Services database.

59.	Point out the correct statement.(a) The permissions of a role may allow members to access and administer the database(b) Server roles, roles defined by administrators to control access to objects and data for non-administrator user(c) Database roles, roles defined by administrators to control access to objects and data for administrator user(d) None of the mentionedI got this question during an internship interview.The origin of the question is Analysis Services topic in division Business Intelligence of SQL Server
Answer» The correct choice is (a) The permissions of a role may allow members to access and administer the database Easiest EXPLANATION: Each permission has one or more access rights ASSOCIATED with it, which in TURN gives the permission finer control over access to a particular OBJECT in the database.

60.	The Analysis Services __________ role defines administrative access of Windows users and groups to an instance of Analysis Services.(a) database(b) server(c) user(d) none of the mentionedThe question was posed to me during an online exam.Question is taken from Analysis Services topic in chapter Business Intelligence of SQL Server
Answer» The correct choice is (b) server The EXPLANATION: Members of this role have access to all ANALYSIS SERVICES DATABASES and objects on an instance of Analysis Services.

61.	Which of the following is the process of basing an organization’s actions and decisions on actual measured results of performance?(a) Institutional performance management(b) Gap analysis(c) Slice and Dice(d) None of the mentionedI have been asked this question in final exam.This is a very interesting question from Business Intelligence topic in chapter Business Intelligence of SQL Server
Answer» Correct choice is (a) Institutional performance management The BEST explanation: INCORPORATES performance measures, benchmarks, and GOALS to attain the best results.

62.	________ is a performance management tool that recapitulates an organization’s performance from several standpoints on a single page.(a) Balanced Scorecard(b) Data Cube(c) Dashboard(d) All of the mentionedThe question was asked during an online exam.My query is from Business Intelligence topic in division Business Intelligence of SQL Server
Answer» The correct option is (a) Balanced Scorecard To elaborate: The balanced scorecard (BSC) is a strategy performance management tool – a semi-standard STRUCTURED REPORT, supported by design methods and AUTOMATION.

63.	_________ is a category of applications and technologies for presenting and analyzing corporate and external data.(a) Data warehouse(b) MIS(c) EIS(d) All of the mentionedThe question was asked during an internship interview.Enquiry is from Business Intelligence in portion Business Intelligence of SQL Server
Answer» Correct OPTION is (c) EIS The best EXPLANATION: EIS stands for Enterprise INFORMATION SYSTEM.

64.	__________ is a system where operations like data extraction, transformation and loading operations are executed.(a) Data staging(b) Data integration(c) ETL(d) None of the mentionedI got this question in an international level competition.My doubt stems from Business Intelligence topic in division Business Intelligence of SQL Server
Answer» Correct answer is (a) Data staging Easiest explanation: In COMPUTING, Extract, Transform and LOAD (ETL) refers to a process in database usage and especially in data WAREHOUSING

65.	Point out the wrong statement.(a) Data is factual information for analysis(b) BI is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data(c) Customer relationship management (CRM) entails all aspects of interaction that a company has with its customer(d) None of the mentionedThis question was addressed to me in a national level competition.My query is from Business Intelligence in portion Business Intelligence of SQL Server
Answer» Right option is (B) BI is a CATEGORY of database software that provides an interface to help users quickly and interactively scrutinize the RESULTS in a variety of dimensions of the data To elaborate: Online Analytical Processing is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data.

66.	Which of the following areas are affected by BI?(a) Revenue(b) CRM(c) Sales(d) All of the mentionedThe question was asked in quiz.This intriguing question originated from Business Intelligence in section Business Intelligence of SQL Server
Answer» Correct choice is (b) CRM For explanation: Customer relationship management (CRM) is a SYSTEM for managing a company’s interactions with current and future CUSTOMERS. It often involves using technology to ORGANIZE, automate and synchronize sales, marketing, customer service, and technical support.

67.	BI can catalyze a business’s success in terms of _____________(a) Distinguish the products and services that drive revenues(b) Rank customers and locations based on profitability(c) Ranks customers and locations based on probability(d) All of the mentionedI got this question in semester exam.Origin of the question is Business Intelligence in chapter Business Intelligence of SQL Server
Answer» CORRECT answer is (d) All of the mentioned To elaborate: SQL Server Business INTELLIGENCE delivers a comprehensive platform empowering ORGANIZATIONS to build and deploy SECURE, scalable and manageable BI apps.

68.	Point out the correct statement.(a) OLAP is an umbrella term that refers to an assortment of software applications for analyzing an organization’s raw data for intelligent decision making(b) Business intelligence equips enterprises to gain business advantage from data(c) BI makes an organization agile thereby giving it a lower edge in today’s evolving market condition(d) None of the mentionedThe question was asked in my homework.My doubt stems from Business Intelligence topic in chapter Business Intelligence of SQL Server
Answer» The correct answer is (b) Business intelligence equips ENTERPRISES to gain business advantage from data Explanation: Once an organization is powered with BI it can anticipate enhanced TURNAROUND TIME on data collection, come up with fresh ideas for novel business initiatives.

69.	Business intelligence (BI) is a broad category of application programs which includes _____________(a) Decision support(b) Data mining(c) OLAP(d) All of the mentionedThe question was posed to me in an online interview.I'd like to ask this question from Business Intelligence in section Business Intelligence of SQL Server
Answer» RIGHT option is (d) All of the mentioned The BEST I can explain: Business INTELLIGENCE (BI) is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to DATA from VARIOUS data sources.