MindMajix.com

OVERVIEW MindMajix Microsoft Cortana Intelligence Trainig crafted by leading industry experts who has enormous knowledge in Cortana Analytics. They developed the simplest way to explain the features and benefits of Cortana in Microsoft Azure Suite. Cortana Intelligence course include app building and installation on cloud followed by an assessment to verify your level of understanding. Enroll & Become Certified! What is the Cortana Intelligence Suite? First things first, the suite is not a product in and of itself, though it will have its own pricing. The suite can be thought of as a bundle of integrated products and services. It’s somewhat similar to the idea of the Office suite or the SQL Server suite, both of which contain various components that are interoperable (at least to a certain extent). I get the feeling with the Cortana Intelligence Suite that interoperability/integration will be a huge emphasis. Another big emphasis will be on the availability of templates an...

Q. List four possible ways (direct or indirect) to execute an SQL query against an Oracle Database? 1. Using the SQL*Plus command line tool. With this tool, you can directly execute SQL commands. 2. Using a GUI (Graphical User Interface) tool like SQL Developer. You can directly execute SQL commands with such tools. 3. Using Oracle Enterprise Manager. This is an indirect way of executing an SQL query. When you perform certain operations with Oracle Enterprise Manager, they are converted to SQL queries implicitly and these SQL queries are executed against the database. 4. Writing your own program. This is not a conventional way of executing your queries but actually it is widely used. Any web or windows program that uses Oracle database at backend, executes SQL queries. These programs are written using a programming language like .NET or JAVA and they use a driver to connect to database. Q. What is SQL*Plus? How can one acquire it and what kind of operations can be performed with it...

Q. What is SSIS? SSIS was first introduced with SQL Server 2005, which was the next generation of SQL Server software after SQL Server 2000.  SSIS is an ETL tool that handles data Extraction, Transformation and load. In addition, it can handle more tasks besides the ETL tasks such as data profiling, file system manipulation etc….  If you know C#.net or VB.net, you can use the script task to perform much more efficient batch operations. Q. What is SSIS control flow integration? SSIS control flow  allows you to program graphically how the tasks will run by using the logical connectors between tasks.  there are three basic logical connectors that you can use: success, failure, or complete.  Furthermore, you can use the FX (expression) to handle more complex conditions in your control flow. Q. What is Data Transformation? The data transformation stage applies a series of rules or functions to the extracted data from the source to derive the data for loading in...

Q. What exactly do you mean by ETL? ETL stands for Extract Transform Load and is widely regarded as one of the essential tools in the data warehousing architecture. Its main task is to handle data management for the businesses process which is complex and are useful to the business in many ways. Extracting simply means reading the data from a database. Transformation means converting the data into a form which is suitable for analysis and reporting. The load on the other side handles the process of writing and managing the data into the database which users want to target simply. Q. There is a group of parameters that direct the server regarding the movement of the data from the source to the target. What it is called as? It is called as Session. Q. Do you have any idea about the ETL testing and the operations that are a part of the same? Well, there are certain important tasks that are opted in this. It simply means verifying the data in terms of its transformation in the correc...

Q. What is JavaScript? JavaScript is a lightweight, interpreted programming language with object-oriented capabilities that allows you to build interactivity into otherwise static HTML pages. The general-purpose core of the language has been embedded in Netscape, Internet Explorer, and other web browsers. Q. JavaScript Vs Jscript? JavaScript and Jscript are almost similar, whereas JavaScript was developed by Netscape. Microsoft reverse engineered Javascript and called it JScript. Q. How to create a class? JavaScript does not have a class definition. To mimic classes in JavaScript functions can be used to declare a class. Example: Let’s create a student class in JavaScript which takes two parameters name and roll as property. The code will look like below, Function Student (name .roll){ this.name = name; this.roll = roll; } Q. What is callback?  A callback is a plain JavaScript function passed to some method as an argument or option. Some callbacks are just events,...

Q. What is the lifespan of scrum cycle?  The project size and team size are the two main factors which determine the time length of the scrum cycle. The size of a team can be 3 to 9 members. Usually, it can be estimated that the time span of a scrum sprint of about 3 to 4 weeks on average.  Q. What does the term increment mean?  When the sprint id finished by the team it is usually meant that all the tasks that they have planned have been completed. The term increment refers to the sum of all the backlog product items that were completed in a sprint. The new increment value will have the value of the last sprint value.  Q. What does the term impediment mean?  Any obstacles that do not allow smooth flow of work which results in the underperformance of the team to perform tasks in a better way is known as an impediment.  Q. What do you mean by planning poker or scrum poker technique?  The technique which is a card based estimation based on a ge...