GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Karteikarten

PEBA Final Exams

yeet yeet Englisch 85 Karten

Karten in diesem Stapel (85)

  1. 1?It tells us that we can CRUD (create, retrieve, update, and delete) our data within the DBMS.Manipulation of Data
  2. 2?Metadata describes the contents of your database. This is data that describes another data in terms of its constraints, size, and the data type of the tables or the databases that are contained within your DBMS.Database Definition
  3. 3?Those groups of people who create the application programs that cater to the user requirements.System Developers
  4. 4?An initialization and maintenance operations on a database.Utility Services
  5. 5?According to (Crisanto, 2018), This is a computer program that allows users to manipulate the data in a DBMS through a user-friendly interfaceDatabase Application
  6. 6?This refers to mechanisms for recovery of data that is apparently lost due to system crashes.Recovery Services
  7. 7?This means that within a database, privileges are provided to different types of users. Different types of users can access the same database but the same users can have different privileges.Data Sharing
  8. 8?According to (Crisanto, 2018), It is a collection of data, not necessarily always stored in a computer, such as records stored in a filing cabinet, in a notebook.Database
  9. 9?Examples of DBMS include the following EXCEPT:Microsoft Navision
  10. 10?A collection of interrelated data using the software and hardware used to access the data in a useful manner such as database or set of databases stored in a disk or other media, a computer, or set of computers where the software to access the database can run (Crisanto, 2018).Database Management System
  11. 11?According to (Recario, 2018), It is a collection of logically related data and it is typically visualized as tables; composed of cells matched with several columns and rows.Database
  12. 12?Data are facts or figures which we can store in a database. An example of this is are the following EXCEPT:Your database tables
  13. 13?Which of the following is component of a DBMS according to (Recario, 2018)?Parser
  14. 14?A software package or software that allows you to store, retrieve, package your database (Recario, 2018).Database Management System
  15. 15?It is responsible for checking the correctness of the syntax that was provided by the end user through the interface.Parser
  16. 16?This allows the user to perform different types of operations such as string manipulation, date operations and so on.Data Processing
  17. 17?According to (Recario, 2018), It is also called the “middleman” as it communicates between two different parties: the end user, which is you, and the database management systems.Interface
  18. 18?Which of the following is component of a Database System according to (Crisanto, 2018)?User
  19. 19?DBMS maintains the segregation between the program and the data.Data Independence
  20. 20?This refers to a process to ensure that data is updated correctly and appropriately when more than one person is accessing the data.Concurrency Control
  21. 21?When a credit card company used a data on a client’s purchases which he never made in the first place, or mistakenly used on a different client with the same name. It can also be using correct data but interpreting it the wrong way. These are just some of the examples of:Integrity of Data Analytics
  22. 22?According to (Ligot, 2018), Our information are being collected and analyzed, each time we do the following EXCEPT:Accept a cookie
  23. 23?The following are some of the general information found in the data privacy act EXCEPT:The Right to Fortify
  24. 24?According to (Bañez, 2018).As a business analytics practitioner, you need to know some of the general information about the _________.Data Privacy Act
  25. 25?In Data Analytics, the right tool is useless if we have the following EXCEPT:Relevant data
  26. 26?This happens when our judgement and assumptions are influenced by our own biases.Discrimination and Bias
  27. 27?Before you can collect and process one’s information, you need to get his/her consent. The consent has to be recorded and informed, meaning the person has to understand the purpose which his/her data is being collected and processed.Consent Required and the Right to be Informed
  28. 28?As we use the results of analytical analysis to make certain decisions, we should also take consideration the assumptions used to ensure its validity. Using wrong assumptions, even if we use the right analytical tools will bring us to ________.Wrong Data
  29. 29?Suppose you used business analytics to screen candidates for employment, and you decided that we are going to eliminate those who are not employed one year prior application, since you may feel that this seems objective and rational. You want to hire people who have continuity in working and the one-year gap may be a source of suspicion. These are just some of the examples of:Discrimination and bias
  30. 30?If the information they have about you is inaccurate our outdated, under the data privacy act, you have the right to have it corrected.The Right to Rectify
  31. 31?Once it is established that your rights are violated, the company which violated your rights can be made to pay a fine, and pay you directly, damages. In some cases, the company’s officers may become criminally liable – they can go to jail.The Right to Complain
  32. 32?The following are examples of ethical and legal considerations in business analytics EXCEPT:Lack of Data Privacy Law
  33. 33?In the Philippines, the Data Privacy Act was made to protect people and bring back control of their own information.Data Privacy Act
  34. 34?Suppose you think that your company made a wrong decision in not promoting you. So how do you appeal to this if you think that their method is based on bias, and thus faulty? How can you now question that decision and make your appeal if you don’t know how the decision arrived at? These are just some of the examples of:Lack of Transparency
  35. 35?A moral principle that somehow guides a person on what is bad and what is good.Ethics
  36. 36Data Independence refers to a process to ensure that data is updated correctly and appropriately when more than one person is accessing the data.False
  37. 37A DBMS is a collection of interrelated data using the software and hardware used to access the data in a useful manner such as database or set of databases stored in a disk or other media, a computer, or set of computers where the software to access the database can run.True
  38. 38Data are facts or figures that we can store in a database.True
  39. 39In the data extraction, there are at least 3 sources of data which are the source systems, raw transactions, and from documents and forms.True
  40. 40The databases store all its data in one location, thereby limiting data duplication.True
  41. 41Manipulation of data tells us that we can CRUD (create, retrieve, update, and delete) our data within the DBMS.True
  42. 42In big data veracity includes how many pieces of data we gather together from social media data, government data, financial data, banking data, all sorts of transactions all combined together to make one or more profiles for your customers.False
  43. 43The main responsibility of engine is to execute the output of the query optimizer. Once the query has been optimized, then it will pass the data or the optimized query to the execution engine whose sole purpose is to execute the command.True
  44. 44In the data warehouse, the data is cleaned, curated, organized, and prepared for analysis.False
  45. 45A DBMS is a software package or a software that allows you to store, retrieve, package your database.True
  46. 46According to Galleto (2018), business Analytics is the study of data through statistical and operations analysis, the formation of predictive models, application of optimization techniques, and the communication of these results to customers, business partners, and college executives.True
  47. 47In big data, variety is about how huge the data sets.False
  48. 48In big data volume means that there is a lot of uncertainty, meaning, with all of these different data coming altogether but the problem is we don’t know what to do with them.False
  49. 49Recovery Service is the initialization and maintenance operations on a database.False
  50. 50The first step to turning data into analytics is the data warehousing phase.False
  51. 51For the data to become business value, it has to be extracted from sources, curated and cleansed, and joined in a data warehouse.True
  52. 52DBMS maintains the segregation between the program and the data.True
  53. 53Predictive Analytics is the type of analytics where data is used to benchmark or to profile.False
  54. 54Storage is the physical location of your database, which can be the secondary or the primary memory.True
  55. 55In marketing, prescriptive analytics can be seen through the recommendation engines which are found to be successful in driving more sales.True
  56. 56Data sharing allows the user to perform different types of operations such as string manipulation, date operations and so on. You can also manipulate the data based on an event or what they call ‘triggers’ which is based on the event or the conditions of the event.False
  57. 57Once we know the relationships inside the data, we can make predictions and forecasts by feeding new data into the predictive model.True
  58. 58The process of moving data from source systems into a data warehouse, and from a data warehouse into an analytical tool is often called ETL (Extract, Transform, or Load processes).True
  59. 59Descriptive analytics involves providing advice on what actions can be taken given the predictions about the future and what drives the future.False
  60. 60In every database systems, the heart of each system is what you call the data.True
  61. 61Business Intelligence is the process of collecting information from all sources to make data-driven decisions in an organization.True
  62. 62Utility Services refers to mechanisms for recovery of data that is apparently lost due to system crashes.False
  63. 63In business analytics, you need to follow a process turn data into value.True
  64. 64Interface is responsible for checking the correctness of the syntax that was provided by the end user through the interface. So it also checks the tables and other objects in the query.False
  65. 65Data Processing means that within a database, privileges are provided to different types of users. Different types of users can access the same database but the same users can have different privileges.False
  66. 66Prescriptive analytics is a way of providing recommendations and providing the decision-maker the costs and benefits of a decision.True
  67. 67The users of a database system are the database administrator, system developer, and end user.True
  68. 68According to Evans (2012), business Analytics is the use of data, information technology, statistical analysis, quantitative methods, and mathematical or computer-based models to help managers gain improved insight about business operations and make better, fact-based decisions.True
  69. 69In computer terms, database is a collection of data, not necessarily always stored in a computer, such as records stored in a filing cabinet, in a notebook.True
  70. 70Predictive analytics is used when you want to find relationships between two different types of data and making predictions about future data.True
  71. 71The DBMS can provide a convenient and efficient interface for storing, retrieving, and updating data, and for extracting useful information from the database, and a clear and logical view of the process that manipulates the data.True
  72. 72Understanding how the traffic is today or how bad the traffic is in a certain location is an example of descriptive analytics.True
  73. 73Database application can be divided into four broad categories: Personal which is restricted to a single user; Departmental which is referenced by hundreds of users over a shared system or network; Enterprise which extensions of departmental applications involving thousands of users; and the Internet which is the largest form of information sharing where billions of users are involved.True
  74. 74Veracity means that there are a lot of uncertainty meaning, with all of these different data coming altogether but the problem is we don’t know what to do with them.True
  75. 75Big data includes large volumes of structured and unstructured data that inundates a business on a day-to-day basis.True
  76. 76Database is the space in the disk or computer where the data are actually stored.True
  77. 77The query optimizer comes from the root word ‘optimize’, which means it simplifies the query form or the input into a simpler type of input that can be digested and can be understood by the database management system. This allows the DBMS to save time and save space when performing operations.True
  78. 78Business Intelligence is the process of combining aspects of reporting, monitoring and alerting, dashboards, scorecards, and ad hoc query data exploration.True
  79. 79Metadata describes another data in terms of its constraints, size, and the data type of the tables or the databases that are contained within your DBMS.True
  80. 80Descriptive analytics is used to benchmark and to profile to be able to establish historical trends.True
  81. 81Database application is a computer program that allows users to manipulate the data in a DBMS through a user-friendly interface.True
  82. 82The process of turning raw data into business action is the framework for business analytics.True
  83. 83Database is a collection of logically related data and it is typically visualize as tables; composed of cells matched with several columns and rows.True
  84. 84The parser is responsible for interacting with the user. It is also called the “middleman” as it communicates between two different parties: the end user, which is you, and the database management systems.False
  85. 85Business intelligence is about combining aspects of reporting, data exploration, and ad hoc queries.True

Informationen

Beschreibung
Karteikarten am PEBA Final Exams, erstellt von yeet yeet am 15/05/2023.
Erstellt von
yeet yeet
Aufrufe
1
Bewertung

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck