callicon +1 210-504-8191
whatsAppIcon +1 210-504-8191
emailIcon info@koenig-solutions.com
koenig-logo
logo-30-years
Login
koenig-logo
+1 210-504-8191
+1 210-504-8191

Implementing a SQL 2016 Data Warehouse (SSIS) Quiz Questions and Answers

Answer :
  • Use a granularity of one day.

Explanation :

We create on partition for each day, which means that a granularity of one day is used. Note: If we calculate the partitions that are needed, we get: 7 years times 365 days is 2,555. Make that 2,557 to provide for leap years. From scenario: Partition the Fact.Order table and retain a total of seven years of data. The Fact.Order table is optimized for weekly reporting, but the company wants to change it to daily. Maximize the performance during the data loading process for the Fact.Order partition. Reference: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-partition PrepAway - Latest Free Exam Questions & Answers In 70-767 (v.2)briefing 70-767 (v.2) Post navigation Previous question Leave a Reply You must be logged in to post a comment. 70-767 Training Products 70-767 Questions & Answers Premium File 147 Q& A $49.99 Last Update: Jul 19,21 70-767 Video Training Course Training Course 60 Lectures $24.99 Last Update: Jul 21,21 70-767 Study Guide Study Guide 1080 PDF Pages $24.99 Last Update: Jul 22,21 By Prepaway.com Related questions Question 1 Question 2 Question 3 Question 4 Question 5 Question 6 Question 7 Question 8 Question 9 Question 10 Question 11 Question 12 Question 13 Question 14 Question 15 Question 16 Question 17 Question 18 Question 19 Question 20 Question 21 Question 22 Question 23 Question 24 Question 25 Question 26 Question 27 Question 28 Question 29 Question 30 Question 31 Question 32 Question 33 Question 34 Question 35 Question 36 Question 37 (2 comments) Question 38 Question 39 Question 40 Question 41 Question 42 Question 43 Question 44 (1 comment) Question 45 Question 46 Question 47 Question 48 Question 49 PrepAway - Latest Free Exam Questions & Answers Recent comments wellingtonluis wrote Bec
Answer :
  • Deploy to the msdb database on the secondary replica.

Explanation :

Before you can configure SSIS to enable support of AlwaysOn on the new added secondary Replicas, you must connect to all new added secondary replicas.Note: To use SSIS with AlwaysOn, you-ll need to add the SSIS Catalog (SSISDB) into an Availability Group. You-ll need to do the following steps: Make sure you meet the prerequisites for using AlwaysOn Connect to every node and create the SSISDB catalog. We need to create the catalog even on secondary nodes to create the other server-level objects (cleanup jobs, keys, accounts etc) that are used by SSIS. Delete the SSISDB databases on secondary nodes. Create an availability group, specifying SSISDB as the user database Specify secondary replicas. References: https://chrislumnah.com/2017/05/09/enabling-alwayson-for-ssisdb/
Answer :
  • No

Explanation :

Use a matching rule, and use completeness and uniqueness data to determine what weight to give a field in the matching process. If there is a high level of uniqueness in a field, using the field in a matching policy c an decrease the matching results, so you may want to set the weight for that field to a relatively small value. If you have a low level of uniqueness for a column, but low completeness, you may not want to include a domain for that column. References: htt ps://docs.microsoft.com/en-us/sql/data-quality-services/create-a-matching-policy?view=sql-server-2017
Answer :
  • Yes

Explanation :

Use a matching rule, and use completeness and uniqueness data to determine what weight to give a field in the matching process. If there is a high level of uniqueness in a field, using the field in a matching policy can decrease the matching results, so you may want to set the weight for that field to a relatively small value. If you have a low level of uniqueness for a column, but low completeness, you may not want to include a domain for that column. References: https://docs.microsoft.com/en-us/sql/data-quality-services/create-a-matching-policy?view=sql-server-2017
Answer :
  • RAID 6

Explanation :

According to the Storage Networking Industry Association (SNIA), the definition of RAID 6 is: -Any form of RAID that can continue to execute read and write requests to all of a RAID arrays virtual disks in the presence of any two concurrent disk failures.- Incorrect Answers: A: RAID 1 can only handle a single disk failure . B: RAID 5 can only handle a single disk failure. D: RAID 10 is a stripe of mirrors. It requires more disks compared with RAID 6. References: https://en.wikipedia.org/wiki/Standard_RAID_levels#RAID_6
Answer :
  • Enable change data capture.

Explanation :

SQL Server 2017 provides two features that track changes to data in a database: change data capture and change tracking. Change data capture provides historical change information for a user table by capturing both the fact that DML changes were made and the actual data that was changed. Changes are captured by using an asynchronous process that reads the transaction log and has a low impact on the system. References: https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/track-data-changes-sql-server
Answer :
  • sys.sp_cdc_disable_db

Explanation :

sys.sp_cdc_disable_db disables change data capture for all tables in the database currently enabled. All system objects related to change data capture, such as change tables, jobs, stored procedures and functions, are dropped. References: https://docs.microsoft.com/en-us/sql/relational -databases/system-stored-procedures/sys-sp-cdc-disable-db-transact-sql?view=sql-server-2017
Answer :
  • catalog.stop_operation

Explanation :

catalog.stop_operation stops a validation or instance of execution in the Integration Services catalog. Incorrect Answers: H: sys.sp_cdc_stop_job stops a change data capture cleanup or capture job for the current database. References: https://docs.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-stop-operation-ssisdb-database?view=sql-server-2017
Answer :
  • 55

Explanation :

The minimum similarity between the values of a field is 60%. If the calculated matching score for a field of two records is less than 60, the similarity score is automatically set to 0. References: https://docs.microsoft.com/en-us/sql/data-qu ality-services/create-a-matching-policy?view=sql-server-2017
Answer :
  • catalog.deploy_project

Explanation :

catalog.deploy_project deploys a project to a folder in the Integration Services catalog or updates an existing project that has been deployed previously. References: https://docs.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-deploy-project-ssisdb-database