Live Help (Start Chat)
View Count: 0
Duration: 63 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

MSBI introduction part very nice and understandable easily.

Posted By Aditya on 11-Sep-2017

MSBI introduction part very nice and understandable easily.

Posted By Aditya on 11-Sep-2017
Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 9
SSMS provides different options to develop your SSIS package starting with ___________ wizard? 
Options:
  1. Import and Export
  2. Copy and Import
  3. Export and Bulk Insert
  4. None of the mentioned
View Answer/Explanation:
a
Explanation:
With SSIS wizards, we can create a structure on how the data flow should happen and make a package and deploy it based on our needs to execute in any environment.

Question No: 2 of 9
Point out the wrong statement? 
Options:
  1. Prior to SSIS, Data Transformation Services (DTS) in SQL Server 2000 performs the tasks with fewer features
  2. SSIS is used to perform operations like loading the data based on the need, performing different transformations on the data like doing calculations
  3. Business Intelligence Development Studio (BIDS) is a tool which can be used to develop only SSIS packages
  4. All of the mentioned
View Answer/Explanation:
c
Explanation:
BIDS is available with SQL Server as an interface which provides the developers to work on the work flow of the process that can be made step by step.

Question No: 3 of 9
Which of the following is the best practice related to SSIS? 
Options:
  1. Plan for capacity by understanding resource utilization.
  2. SSIS is an in-memory pipeline, so ensure that all transformations occur in memory
  3. Baseline source system extract speed
  4. All of the mentioned
View Answer/Explanation:
a
Explanation:

Question No: 4 of 9
If SSIS is not able to drive close to 100% CPU load, this may be indicative of___________? 
Options:
  1. Software Contention
  2. Application contention
  3. Processor contention
  4. None of the mentioned
View Answer/Explanation:
b
Explanation:
In Application contention, SQL Server is taking on more processor resources, making them unavailable to SSIS.

Question No: 5 of 9
Point out the wrong statement? 
Options:
  1. SSIS moves data as fast as your network is able to handle it
  2. 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
  3. Integration Services can be tuned beyond the speed of your source
  4. All of the mentioned
View Answer/Explanation:
c
Explanation:
You cannot transform data faster than you can read it in SSIS.

Question No: 6 of 9
The key counters for Integration Services and SQL Server are _________? 
Options:
  1. Process Bytes
  2. Public Bytes
  3. Private Set
  4. All of the mentioned
View Answer/Explanation:
a
Explanation:
Process byte is the amount of memory currently in use by Integration Services. This memory cannot be shared with other processes.

Question No: 7 of 9
_________ represents to total memory pressure on the system in SSIS? 
Options:
  1. Page sec
  2. Page Reads
  3. Memory reads
  4. All of the mentioned
View Answer/Explanation:
d
Explanation:

Question No: 8 of 9
What do you understand by design limitation in SSIS package? 
Options:
  1. Making use of parallelism
  2. Not making use of parallelism
  3. Package uses few single-threaded tasks
  4. None of the mentioned
View Answer/Explanation:
b
Explanation:
The design limitation of SSIS package is not making use of parallelism

Question No: 9 of 9
___________ represents how many network transfers per second are occurring? 
Options:
  1. Network Bytes
  2. Network Transfers
  3. Memory reads
  4. None of the mentioned
View Answer/Explanation:
b
Explanation:

  1