Quiz
BCIS 4660 Final
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (35)
1An SSIS package typically contains _____________, _____________, and __________.
- Adata flow and control flow only
- Bdata flow, control flow, connection manager
- Ccontrol flow and connection manager only
- Ddata flow and connection manager only
2SSDT/SSIS is an ETL development environment.
- ATrue
- BFalse
3SSMS is an ETL administration environment.
- ATrue
- BFalse
4The Slow Changing Dimension task is part of Control Flow
- ATrue
- BFalse
5The Import and Export Wizard allows us to load data between different sources and destinations outside of SSIS.
- ATrue
- BFalse
6Which of the following is the default data source connection manager for SQL Server Database?
- AADO.Net
- BOLE DB
- CExcel
- DODBC
7Manipulating files in SSIS requires the use of the ____________task?
- AFile configuration
- BBulk file insert
- CFile system
- DFTP
8What is the main difference between the Execute SQL Task and the Execute T-SQL Statement?
- AExecute T-SQL Statement performs more SQL tasks such as executing a stored procedure
- BExecute SQL Task performs more SQL tasks than the Execute T-SQL statement
- CExecute SQL Task is located in the data flow tab
- DExecute T-SQL Statement only works with Oracle data sources
9Which of the following are grouping containers in SSIS?
- AFor loop
- BFor each loop
- CFor while
- DSequence
10It is impossible to create multiple SSIS packages in an SSIS Solution Project.
- ATrue
- BFalse
11Which of the following tasks can the File System task perform?
- ADelete file
- BCreate folder
- CDelete folder
- DCopy file
12The main difference between nvarchar and varchar is _______________________.
- Anvarchar is unicode and varchar is not
- Bvarchar is unicode and nvarchar is not
- Cvarchar and nvarchar can both store unicode data
- Dneither varchar and nvarchar can store unicode data
13When one is designing a data transformation task, it is usually a best practice to retain the default data types that have been suggested by SSIS.
- ATrue
- BFalse
14SSIS/ETL can be used to import and export data. However, SSIS cannot be used to export data to a CSV file.
- ATrue
- BFalse
15Of the following, which one is the encoding standard for string characters in SSIS/ETL?
- AASCII
- BSQL Server Data Types
- CUnicode
- DDT_Text
16Both data flow and control flow processing is performed in memory.
- ATrue
- BFalse
17A scorecard is mainly used for displaying ___________, while a dashboard is used to displaying _______________.
- APerformance, Progress
- BProgress, performance
- CProgress, surrogate keys
- DPerformance, presentation
18Report view
- AThe canvas where visualization is designed
- BThe data in table format
- CA representation of the data model and their cardinalities
19Data view
- AThe data in table format
- BA representation of the data model and their cardinalities
- CThe canvas where visualization is designed
20Relationship view
- AThe data in table format
- BA representation of the data model and their cardinalities
- CThe canvas where visualization is designed
21A report is a written document that presents business information in a structured format.
- ATrue
- BFalse
22A business report can only get its source data from a Data warehouse database.
- ATrue
- BFalse
23Business reports fulfil many functions. Which of the following is not a function of business reports?
- AProvides business insights
- BProvides results of analysis
- CProvides infographics of the business
- DProvides information to decision makers
24Type of learning where computer is only presented with inputs and attempts to classify them based on similarity/dissimilarity.
- AUnsupervised learning
- BSupervised learning
25Type of learning where computer is given inputs and their labels, attempts to learn the rule that maps each inputs to a class and requires training, learning, and evaluation
- ASupervised learning
- BUnsupervised learning
26This type of learning is a subset of machine learning and has algorithms that allow the software system to train itself to perform tasks.
- AMachine Learning
- BArtificial Intelligence
- CDeep Learning
27This type of learning is a subset of AI and is a method of data analytics that automates model building through learning and with little human interaction
- AArtificial Intelligence
- BMachine Learning
- CDeep Learning
28This type of learning is when machines learn from experience and adjust to new inputs and perform human-like tasks
- AArtificial Intelligence
- BDeep Learning
- CMachine Learning
29What might happen?
- APredictive
- BPrescriptive
- CDescriptive
30What should be done?
- APrescriptive
- BDescriptive
- CPredictive
31What has happened?
- ADescriptive
- BPredictive
- CPrescriptive
32Elastic computing is the ability to scale up and down based on business need.
- ATrue
- BFalse
33Which of the following are types of cloud services?
- ASaas
- BIaaS
- CPaas
- DETL
- ESQL
34Type of report that shows business goals versus performance measures
- AScorecard
- BDashboard
35Type of report that shows graphical representations of several performance indicators on a single page.
- AScorecard
- BDashboard
Information
- Description
- Quiz on BCIS 4660 Final, created by Cameron Largent on 07/12/2020.
- Author
- Cameron Largent
- Language
- English
- Views
- 1
- Rating
- No ratings yet Rate this quiz