gs gs116 Data Connectivity - SQL Server Integration Services - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Data Connectivity. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: SSMS provides different options to develop your SSIS package starting with ___________ wizard.
Import and Export
Copy and Import
Export and BulkInsert
None of the mentioned
Question 2: Point out the wrong statement.
Prior to SSIS, Data Transformation Services (DTS) in SQL Server 2000 performs the tasks with fewer features
SSIS is used to perform operations like loading the data based on the need, performing different transformations on the data like doing calculations
Business Intelligence Development Studio (BIDS) is a tool which can be used to develop only SSIS packages
All of the mentioned
Question 3: Which of the following is the best practice related to SSIS?
Plan for capacity by understanding resource utilization
SSIS is an in-memory pipeline, so ensure that all transformations occur in memory
Baseline source system extract speed
All of the mentioned
Question 4: If SSIS is not able to drive close to 100% CPU load, this may be indicative of ____________
Software Contention
Application contention
Processor contention
None of the mentioned
Question 5: Point out the wrong statement.
SSIS moves data as fast as your network is able to handle it
It is important to understand your network topology and ensure that the path between your source and target have both low latency and high throughput
Integration Services can be tuned beyond the speed of your source
All of the mentioned
Question 6: The key counters for Integration Services and SQL Server are _______________
Process Bytes
Public Bytes
Private Set
All of the mentioned
Question 7: _________ represents to total memory pressure on the system in SSIS.
Page sec
Page Reads
Memory reads
All of the mentioned
Question 8: The following Network perfom counters can help you tune your topology?
Total Bandwidth
Current Bandwidth
Bandwidth bound
All of the mentioned
Question 9: What do you understand by design limitation in SSIS package?
Making use of parallelism
Not making use of parallelism
Package uses few single-threaded tasks
None of the mentioned
Question 10: ___________ represents how many network transfers per second are occurring.
Network Bytes
Network Transfers
Memory reads
None of the mentioned
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
